Db2

 View Only
  • 1.  DMC 3.1.12 connect DB error

    Posted Fri November 03, 2023 05:06 PM

    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
    ------------------------------


  • 2.  RE: DMC 3.1.12 connect DB error

    Posted Mon November 06, 2023 08:54 AM

    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
    ------------------------------



  • 3.  RE: DMC 3.1.12 connect DB error

    Posted Tue November 07, 2023 02:06 AM

    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
    ------------------------------



  • 4.  RE: DMC 3.1.12 connect DB error

    Posted Tue November 07, 2023 11:28 AM

    Hello qing liu,

    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



    ------------------------------
    Cintia Ogura
    ------------------------------