Can you please create a case with us, and send us the DMC collector for further analysis? Here are the instructions:
https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=support-exchanging-information
Original Message:
Sent: Tue November 07, 2023 02:06 AM
From: qing liu
Subject: DMC 3.1.12 connect DB error
Hi Cintia Ogura,
We do create the repository database by following the manual, and configured into DMC successfully.
But when we try to add a database connection which was created with "codeset GBK territory CN COLLATE USING SYSTEM", we get this error:
When we add a new database created on the same server without define the codeset, it works.
And the same enviroment works under DMC 3.1.3.
------------------------------
qing liu
Original Message:
Sent: Mon November 06, 2023 08:53 AM
From: Cintia Ogura
Subject: DMC 3.1.12 connect DB error
Hello qing liu,
Can you please confirm if you are creating the repository database by following the instructions from the DMC manual at:
https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=tasks-creating-repository-database
------------------------------
Cintia Ogura
Original Message:
Sent: Thu November 02, 2023 11:32 PM
From: qing liu
Subject: DMC 3.1.12 connect DB error
we run DMC 3.1.12 on windows 2019, when we configing the repository database ,we failed many times with error "ERRORCODE=-4228, SQLSTATE=null"。
Then we created a database without setup the codeset and we succesed to create the repository database with this database.
But when we try to add database connection ,we still get the message "Unexpected Throwable caught: Cannot invoke "java.lang.String.equalsIgnoreCase(java.lang.String)" because the return value of "com.ibm.db2.jcc.t4.T4Sqlca.getSqlState()" is null.".
Those databases created with "codeset GBK territory CN COLLATE USING SYSTEM" can't be added.
We searched that it seeams we hit a known issue DT195835.
Is there a fix to resolve this problem?
------------------------------
qing liu
------------------------------