IBM Support

PI96006: DATABASE UTILITIES ON A MIRRORED TABLE CAN CAUSE MIRRORING TO END ABNORMALLY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In IDAA environments only with CDC z/OS PTF UI53200 applied,
    if a desynchronizing database utility is run against an
    actively mirrored table and the source has the standard IDAA
    setting ONUNTILITYACTION=IDLE, then the subscription might end
    abnormally with a dump immediately after it was idled. The
    following event log messages are generated,
    CHC0742I Table <tablename> in subscription <subname> has been
    set to status IDLE by <subname>
    CHC0330E An internal error was detected, Task(SDT),
    Module(CHCSDTPF), MaintLvl(PI79094), Line(1935), an SVC Dump
    will be requested
    

Local fix

  • If the problem occurs, the subscription can be restarted. To
    avoid the issue, idle all mirrored tables that are affected by
    the database utility prior to running the utility and then
    resynchronize the tables.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: IDAA users of InfoSphere Change Data         *
    *                 Capture for z/OS.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION: In IDAA environments only with CDC z/OS *
    *                      PTF UI53200 applied, if a               *
    *                      desynchronizing database utility is run *
    *                      against an actively mirrored table and  *
    *                      the source has the standard IDAA        *
    *                      setting ONUNTILITYACTION=IDLE, then the *
    *                      subscription might end abnormally with  *
    *                      a dump immediately after the table was  *
    *                      idled. The following event log messages *
    *                      are generated,                          *
    *                                                              *
    *                      CHC0742I Table <tablename> in           *
    *                      subscription <subname> has been set to  *
    *                      status IDLE by <subname>                *
    *                                                              *
    *                      CHC0330E An internal error was          *
    *                      detected, Task(SDT), Module(CHCSDTPF),  *
    *                      MaintLvl(PI79094), Line(1935), an SVC   *
    *                      Dump will be requested                  *
    ****************************************************************
    * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
    ****************************************************************
    The code in PTF UI53200 that notifies the target of the table's
    state change to idle when a database utility was run did not
    properly initialize the interval variables that identify the
    table.
    

Problem conclusion

  • The notification code was updated to track the idled table
    correctly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI96006

  • 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

    2018-03-30

  • Closed date

    2018-04-13

  • Last modified date

    2018-05-01

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

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

    UI55213

Modules/Macros

  •    CHCDLSGP
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • RA21 PSY UI55213

       UP18/04/19 P F804

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

Document Information

Modified date:
01 May 2018