IBM Support

PI65350: SUBSCRIPTION WILL NOT RESTART AFTER TABLE DROPPED IN DB2.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Allow a subscription to start where all tables in the
    subscription are IDLE due to schema changes.
    

Local fix

  • Remove dropped table and restart subscription.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users making schema changes when running     *
    *                 InfoSphere CDC for z/OS with IDAA.           *
    ****************************************************************
    * PROBLEM DESCRIPTION: When a schema change is detected for a  *
    *                      table when a subscription is starting,  *
    *                      the subscription will not start.  When  *
    *                      running with IDAA, this is undesireable *
    *                      when ONSCHEMACHANGE is set to IDLE.     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    IDAA subscriptions won't start if a schema change is detected.
    

Problem conclusion

Temporary fix

Comments

  • Small enhancement allows a subscription to proceed when starting
    up and running under IDAA if a schema change is detected and the
    ONSCHEMACHANGE keyword is set to IDLE.
    ×**** PE17/01/11 FIX IN ERROR. SEE APAR PI74715  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI65350

  • Reported component name

    INFO SRVR CDC Z

  • Reported component ID

    5655U7600

  • Reported release

    A21

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-06

  • Closed date

    2016-07-26

  • Last modified date

    2017-01-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI39653

Modules/Macros

  •    CHCSDTDB
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • RA21 PSY UI39653

       UP16/08/04 P F608

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 #: PI65350

Modified date: 12 January 2017


Translate this page: