A fix is available
APAR status
Closed as program error.
Error description
In an IDAA environment, the start of a Change Data Capture for z/OS subscription may fail for idle tables that have had replication-affecting DDL changes such as DROP COLUMN. The subscription will issue CHC0603W, CHC0860E messages and end in error.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of IDAA with Change Data Capture for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: In an IDAA environment that uses * * continuous replication, if a table was * * idled upon a replication-affecting * * schema change (for example, DROP * * COLUMN), when the subscription is * * restarted it will end in error with * * CHC0603W, CHC0860E and CHC0102E events * * in the event log. * **************************************************************** * RECOMMENDATION: APPLY CORRECTIVE SERVICE * **************************************************************** The code to load metadata for idle tables in an IDAA setting should not attempt to do further validation because the table is not being replicated.
Problem conclusion
The module CHCSDTDB was updated to correct the issue.
Temporary fix
Use IDAA administration to remove and re-add the table to the accelerator.
Comments
APAR Information
APAR number
PI74715
Reported component name
INFO SRVR CDC Z
Reported component ID
5655U7600
Reported release
A21
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-10
Closed date
2017-01-12
Last modified date
2017-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI43865
Modules/Macros
CHCSDTDB
Fix information
Fixed component name
INFO SRVR CDC Z
Fixed component ID
5655U7600
Applicable component levels
RA21 PSY UI43865
UP17/01/26 P F701 Ø
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTVMA","label":"InfoSphere Data Replication for DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 February 2017