IBM Support

PM65640: SOME CUSTOMERS NEED A SUBSCRIPTION TO STOP IF A COLUMN IS ADDED TO A TABLE BEING MIRRORED.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • CDC for z/OS detects when a column is added to a table being
    mirrored, makes internal adjustments for the new column, and
    automatically continues mirroring the table, not including the
    newly added column.  Some customers need the subscription to end
    when the new column is added, so that the newly added column can
    be added to the list of columns being replicated.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of CDC for z/OS.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: CDC for z/OS always continues to mirror *
    *                      a table when a new column is added to   *
    *                      the table.  This does not give the user *
    *                      a change to change the table mapping    *
    *                      when the column is added.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The DDL resiliency feature of CDC for z/OS caused it to make the
    necessary internal adjustments in order to continue mirroring a
    table after a column is added to the table.  There was no
    provision made for the user to cause the subscription to end so
    that table mappings could be adjusted.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM65640

  • Reported component name

    INFO SRVR CDC Z

  • Reported component ID

    5655U7600

  • Reported release

    650

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-05-28

  • Closed date

    2012-05-28

  • Last modified date

    2016-03-01

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

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

    UK79132

Modules/Macros

  •    CHCDLSGP CHCDSCPF CHCTVHDL CHCTVHDL
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • R650 PSY UK79132

       UP12/06/02 P F206

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":"6.5","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":"6.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 March 2016