IBM Support

PI88223: A RENAMED SOURCE TABLE SHOULD BE IDLED IF ONSCHEMACHANGE=IDLE

A fix is available

Subscribe

You can track all active APARs for this component.

 

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
    

Publications Referenced
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