IBM Support

PH52527: IIDR CDC FOR Z/OS SHOULD BE ABLE TO SUPPORT TABLE REFRESH ONLY ACTIVITY WITHOUT DATA CAPTURE CHANGES MANDATORY.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a table is used in one or more source subscriptions, but in
    none of them is it configured with Method set to Mirror, i.e.
    all are Method:Refresh, then it should not be required to set
    the table's DATA CAPTURE attribute to CHANGES.  DATA CAPTURE
    should only need to be set to CHANGES if at least one of the
    subscriptions has configured the table to use Method:Mirror.
    

Local fix

  • No
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IIDR CDC for z/OS who use refresh   *
    *                 only activity for synchronizing the source   *
    *                 and target tables.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: IIDR CDC for z/OS requires a table's    *
    *                      DATA CAPTURE attribute to CHANGES to    *
    *                      perform Describe, Refresh and Mirror    *
    *                      activity. However, Describe or Refresh  *
    *                      activity has nothing to do with the Db2 *
    *                      log data, their DATA CAPTURE CHANGES    *
    *                      restriction for the object table should *
    *                      be lifted.                              *
    ****************************************************************
    The table's DATA CAPTURE CHANGES restriction for Describe and
    Refresh activity has been found to be too wide reaching.
    

Problem conclusion

  • The table's DATA CAPTURE CHANGES restriction for Describe and
    Refresh activity has been removed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH52527

  • 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

    2023-02-10

  • Closed date

    2023-08-10

  • Last modified date

    2023-09-01

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

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

    UI93151

Modules/Macros

  • CHCBNDPL CHCDDTDB CHCDDTPF CHCSDTDB CHCTVHDL
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • RA21 PSY UI93151

       UP23/08/29 P F308

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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 September 2023