IBM Support

PI69113: ISSUE WITH ALTER TABLE ADD COLUMN(S) THAT ADDS MULTIPLE COLUMNS TO THE SAME TABLE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ALTER TABLE ADD COLUMN(s) that adds multiple columns to the
    same table within the same transaction while multiple source
    subscriptions are mirroring that table will introduce a latent
    issue where the NEXT alter table can cause problems mirroring
    historical log records (from before the most recent ALTER).
    

Local fix

  • Should the issue occur, then a refresh followed by a re-org of
    the table will bring the table current and avoid the processing
    of the historical log records. To avoid the issue entirely, a
    couple of workarounds are to issue the ALTER TABLE ADD COLUMNs
    as one column per commit, or multiple columns can be addedwith
    a single subscription actively mirroring at the time.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of InfoSphere Data Replication Change  *
    *                 Data Capture for z/OS                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: If more than one subscription is        *
    *                      mirroring the same table to which ALTER *
    *                      TABLE ADD COLUMN is done and the        *
    *                      alteration adds more than one column in *
    *                      a single transaction, then a subsequent *
    *                      ALTER TABLE that results in a table     *
    *                      version change could cause mirroring to *
    *                      fail with the events CHC0050E ("Data    *
    *                      with an invalid length was received")   *
    *                      and CHC0330E ("An internal error was    *
    *                      detected").                             *
    ****************************************************************
    * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
    ****************************************************************
    CDC saves the current table version in its version history
    metadata as a new version is encountered. A timing condition
    exists with multiple columns where a partially processed new
    table version is saved to the version history with only the
    first column being accounted for. A check should be added to
    prevent the new version from being added to the version history
    as it is being processed.
    

Problem conclusion

  • Module CHCTVHDL was updated to correct the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI69113

  • 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

    2016-09-13

  • Closed date

    2016-11-15

  • Last modified date

    2016-12-01

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

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

    UI42626

Modules/Macros

  •    CHCTVHDL
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • RA21 PSY UI42626

       UP16/11/23 P F611

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 December 2016