In suite administration, configuration section user gets an error related to database connection.
Error snippet:
Error: Message: JDBC configuration was unable to be verified: [IBM][CLI Driver][DB2/LINUXX8664] SQL0601N The name of the object to be created is identical to the existing name "DB2INST1.MYTESTTABLE" of type "TABLE". SQLSTATE=42710 SQLCODE=-601
An attempt to name an object failed because the name is already in use for an object of the same type.
Answer
DB2INST1.MYTESTTABLE table can be drop as it plays no role here.
Below is the command to drop table:
$ db2 drop table DB2INST1.MYTESTTABLE
For more information on SQLCODE=-601:
https://www.ibm.com/docs/en/db2-for-zos/11?topic=codes-601
https://www.ibm.com/docs/en/db2-for-zos/11?topic=codes-601
Reference Link: https://www.ibm.com/support/pages/node/7123111
No comments:
Post a Comment