Question & Answer
Question
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
Cause
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
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m50000000CbCgAAK","label":"System"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
23 February 2024
UID
ibm17123111