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

Obtain the fix for this APAR.

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 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.