IBM Support

PI74715: SUBSCRIPTION START MAY FAIL FOR IDLE TABLES

A fix is available

Subscribe

You can track all active APARs for this component.

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.



Document information

More support for: InfoSphere Data Replication for DB2 for z/OS

Software version: 10.2.1

Reference #: PI74715

Modified date: 01 February 2017


Translate this page: