IBM Support

PM89162: DATA CAPTURE BIT NOT ON FOR SYSTABLES UPDATE IN REORG.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1). Create a tablespace with three tables, MA, MA2, and MA3.
    2). Alter MA to add a column to it. This updates MA's version.
        All necessary log records are returned by IFI and are marked
        as DATA CAPTURE.
    3). Alter MA3 to expand a column. This updates MA3's version and
        puts the table in an advisory reorg state.
    4). Reorg the tablespace created in Step 1. This updates *MA's*
        version. The log record necessary to catch the version
        update is *not* marked as DATA CAPTURE.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of REORG with the  *
    *                 Change Data Capture (CDC) attribute for the  *
    *                 catalog table SYSIBM.SYSTABLES.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: A REORG utility updated the data        *
    *                      version into the catalog table SYSIBM.  *
    *                      SYSTABLES, but the log records of these *
    *                      updates were not marked as DATA CAPTURE *
    *                      when this catalog table had the CDC     *
    *                      attribute.                              *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    The catalog table SYSIBM.SYSTABLES had the CDC attribute.  A
    REORG TABLESPACE ran on a multi-table table space and updated
    the data versions of the tables into SYSIBM.SYSTABLES.  These
    updates were not logged as DATA CAPTURE.
    

Problem conclusion

  • The code has been modified to log the data version updates into
    SYSIBM.SYSTABLES during a REORG if this catalog table has the
    CDC attribute.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM89162

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-16

  • Closed date

    2013-06-24

  • Last modified date

    2013-08-02

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

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

    UK95131

Modules/Macros

  • DSNUGPAM DSNUGUVR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK95131

       UP13/07/10 P F307

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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.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.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 August 2013