IBM Support

JR58736: CDC FOR DB2 INSTANCE WITH A LOWERCASE SCHEMA NAME FAILS TO START WHEN CDC IS UPGRADED FROM 10.2.1 TO 11.3.3 GA

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When a new CDC for Db2 instance is created with a lowercase
    schema name (Eg: schema1) in v10.2.1 through the configuration
    tool and later upgraded to 11.3.3 GA, the instance fails to
    start after upgrade with error
    java.lang.RuntimeException: Error accessing your database.
    Error: "SCHEMA1.TS_CONFAUD" is an undefined name..
    SQLCODE=-204, SQLSTATE=42704, DRIVER=4.15.82
    
    
    com.datamirror.ts.metadata.migration.Migration169    migrate()
      V153 to V169 migration started.
    18    2017-11-15 04:36:11.077    Agent Reader{28}
    com.datamirror.ts.jdbcagent.message.custom.MsgStartMetadata$Hand
    ler    handleRequest()    Error: "SCHEMA1.TS_CONFAUD" is an
    undefined name.. SQLCODE=-204, SQLSTATE=42704,
    DRIVER=4.15.82 com.datamirror.ts.metadata.CustomerDatabaseExc
    eption Error: "SCHEMA1.TS_CONFAUD" is an undefined name..
    SQLCODE=-204, SQLSTATE=42704, DRIVER=4.15.82    at
    com.datamirror.ts.metadata.migration.Migration169.migrateDb2TsCo
    nfAudTableToNewVersion(Migration169.java:262)    at
    com.datamirror.ts.metadata.migration.Migration169.migrateCustome
    rDatabase(Migration169.java:198)    at
    com.datamirror.ts.metadata.migration.Migration169.migrate(Migrat
    ion169.java:162)    at
    com.datamirror.ts.metadata.migration.Migration169.migrate(Migrat
    ion169.java:133)    at
    com.datamirror.ts.metadata.migration.MigrationLatest.migrate(Mig
    rationLatest.java:191)    at
    com.datamirror.ts.metadata.MetadataManager.getMetadataDbConnecti
    onWithMigration(MetadataManager.java:882)    at
    com.datamirror.ts.metadata.MetadataManager.getMetadataDbConnecti
    on(MetadataManager.java:465)    at
    com.datamirror.ts.metadata.MetadataManager.startDatabase(Metadat
    aManager.java:446)    at
    com.datamirror.ts.metadata.MetadataManager.startDatabase(Metadat
    aManager.java:1339)    at
    com.datamirror.ts.jdbcagent.message.custom.MsgStartMetadata$Hand
    ler.handleRequest(MsgStartMetadata.java:155)    at
    com.datamirror.ts.jdbcagent.messagehandler.generated.MsgTsjavaTo
    olsHandler.handleMessage(MsgTsjavaToolsHandler.java:80)    at
    com.datamirror.ts.jdbcagent.main.MessageReader.runThread(Message
    Reader.java:142)    at
    com.datamirror.ts.util.TsThread.run(TsThread.java:130) Caused
    by: java.sql.SQLSyntaxErrorException "SCHEMA1.TS_CONFAUD" is an
    undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.15.82
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue affects users upgrading from IDR/CDC 10.2.1 to    *
    * 11.3.3 or 11.4 for DB2, where the DB2 instance has a         *
    * lowercase schema name.                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CDC FOR DB2 INSTANCE WITH A LOWERCASE SCHEMA NAME FAILS TO   *
    * START WHEN CDC IS UPGRADED FROM 10.2.1 TO 11.3.3 GA          *
    *                                                              *
    * More details:                                                *
    * When a new CDC for Db2 instance is created with a lowercase  *
    * schema name (e.g: schema1) in version 10.2.1 through the     *
    * configuration                                                *
    * tool and later upgraded to version 11.3.3 GA, the instance   *
    * fails to start after upgrade with error:                     *
    *                                                              *
    * java.lang.RuntimeException: Error accessing your database.   *
    * Error: "SCHEMA1.TS_CONFAUD" is an undefined name..           *
    * SQLCODE=-204, SQLSTATE=42704, DRIVER=4.15.82                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade from IDR/CDC 10.2.1 to 11.3.3 GA, then upgrade to    *
    * IDR/CDC 11.3.3.3-71 or 11.4.0.0-5050 or later.               *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IDR/CDC 11.3.3.3-71 or 11.4.0.0-5050 or later for
    DB2 resolves the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR58736

  • Reported component name

    IS CDC DB2 LUW

  • Reported component ID

    5725E30DL

  • Reported release

    B33

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-11-16

  • Closed date

    2020-04-24

  • Last modified date

    2020-04-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    IS CDC DB2 LUW

  • Fixed component ID

    5725E30DL

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 April 2020