IBM Support

PI87085: DOWNLEVEL DETECTION ON CATALOG TABLES AFTER ENFM MIGRATION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • V11 IVP job issues down-level detection on DB2 catalog table
    spaces with wrong EXPECTED LEVEL ID. SYSLGRNX contains bad entry
    with START RBA value ending with x001F and END RBA value having
    xA3 in the front of the correct RBA value, which caused DLD at
    the following IVP job that accesses the table in question.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of the DSNTIJEN    *
    *                 ENFM processing job.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: Down-level detection message DSNB232I   *
    *                      is issued for several catalog table     *
    *                      spaces after the V11 DSNTIJEN ENFM job  *
    *                      step ENFM0027 completes processing      *
    *                      directory table space DSNDB01.SYSLGRNX. *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    During the DB2 11 for z/OS ENFM process (DSNTIJEN job) the
    DSNDB01.SYSLGRNX directory table space is processed in step
    ENFM0027. ENFM0027 is a REORG with SHRLEVEL CHANGE. During
    the REORG LOG phase, UPDATE log records that are processed
    might be incorrectly manipulated which can result in invalid
    START_RBA and STOP_RBA columns values in DSNDB01.SYSLGRNX.
    
    The UPDATE log records being applied during the REORG LOG phase
    reflect changes being made to the STOP_RBA column values in
    DSNDB01.SYSLGRNX.
    
    If the START_RBA and STOP_RBA are changed incorrectly then
    this can cause the reported down-level detection problems.
    The down-level detection errors reported are false, the data
    in the table spaces is valid. The invalid START_RBA and
    STOP_RBA column values could also impact the ability to recover
    the objects whose values were broken.
    

Problem conclusion

  • DB2 11 for z/OS ENFM code has been changed to correct the
    problem that can result in damaged START_RBA and STOP_RBA
    columns values in the DSNDB01.SYSLGRNX directory table.
    
    Additional keywords: DB2MIGV11/K MSGDSNB232I SYSLGRNX
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PI87085

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-09

  • Closed date

    2017-09-21

  • Last modified date

    2017-11-01

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

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

    UI50515

Modules/Macros

  • DSNURFIT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI50515

       UP17/10/07 P F710 Ž

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

Document Information

Modified date:
01 November 2017