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