APAR status
Closed as program error.
Error description
Db2z remote issues event 9827 for existing instances when processing DDL if Db2z is upgraded and SYSTABLES or SYSCOLUMNS have different schemas. If the user upgrades Db2z and in the new version the schema of SYSTABLES or SYSCOLUMNS has changed, i.e. if the DDL of these tables is different, when DDL is seen in any existing CDC instance event 9827 E_CDC_SCRAPE_UNPARSABLE_SYSTEM_TABLE_OP is issued.
Local fix
Export all subscriptions, drop and recreate the instance, then import the subscriptions into the new instance. This will force CDC to pick up the new SYSTABLES and SYSCOLUMNS table definitions.
Problem summary
**************************************************************** * USERS AFFECTED: * * This issue might affect you if the Db2 for z/OS database * * from which you are replicating tables was recently upgraded. * **************************************************************** * PROBLEM DESCRIPTION: * * The CDC replication engine issues an error and skips * * subsequent DDL changes. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDR 11.4.0.4-5644 or newer for Db2 for z/OS * * remote source. * ****************************************************************
Problem conclusion
Upgrading to IDR 11.4.0.4-5644 or newer for Db2 for z/OS remote source resolves the issue.
Temporary fix
Comments
APAR Information
APAR number
JR65081
Reported component name
IS DATA REPLICA
Reported component ID
5725E3000
Reported release
B40
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-07-04
Closed date
2022-07-29
Last modified date
2022-09-08
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 DATA REPLICA
Fixed component ID
5725E3000
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"}],"Version":"11.4","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 September 2022