A fix is available
APAR status
Closed as program error.
Error description
On an IIDR CDC z/OS source system with the parameter ONSCHEMACHANGE set to IDLE, a renamed table causes the subscription to end abnormally with the error message "CHC1503E Table <tablename> no longer exists". With that setting the subscription should have idled the table and continued mirroring.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of InfoSphere Data Replication Change * * Data Capture for z/OS * **************************************************************** * PROBLEM DESCRIPTION: On an IIDR CDC z/OS source system with * * the parameter ONSCHEMACHANGE set to * * IDLE, a renamed table causes the * * subscription to end abnormally with the * * error message "CHC1503E Table * * <tablename> no longer exists". With * * that setting the subscription should * * have idled the table and continued * * mirroring. * **************************************************************** * RECOMMENDATION: APPLY CORRECTIVE SERVICE * **************************************************************** When schema changes occur for a mirroring table on an InfoSphere CDC for z/OS source system, the affected subscription behaves based on the setting of the parameter ONSCHEMACHANGE. The RENAME operation is not included in the changes that are being handled, a RENAME stops the subscription from mirroring even with the parameter ONSCHEMACHANGE set to IDLE.
Problem conclusion
Logic was added to detect if a RENAME occurred when handling the table schema change. New reason text for message CHC1503E was added stating that the affected table was idled because of the RENAME.
Temporary fix
Comments
APAR Information
APAR number
PI88223
Reported component name
INFO SRVR CDC Z
Reported component ID
5655U7600
Reported release
A21
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-10-02
Closed date
2018-02-27
Last modified date
2018-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI54077
Modules/Macros
CHCMBARA CHCMBCHS CHCMBCHT CHCMBDAN CHCMBDES CHCMBDEU CHCMBELL CHCMBENG CHCMBENP CHCMBENU CHCMBESP CHCMBFIN CHCMBFRA CHCMBFRB CHCMBFRC CHCMBFRS CHCMBHEB CHCMBISL CHCMBITA CHCMBITS CHCMBJPN CHCMBKOR CHCMBNLB CHCMBNLD CHCMBNOR CHCMBPTB CHCMBPTG CHCMBRMS CHCMBRUS CHCMBSVE CHCMBTHA CHCMBTRK CHCMBZZZ CHCTVHDL
SC19412700 |
Fix information
Fixed component name
INFO SRVR CDC Z
Fixed component ID
5655U7600
Applicable component levels
RA21 PSY UI54077
UP18/03/06 P F803
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:
03 April 2018