PM91151: Timeout during REBUILD INDEX of DSNDB01X or DSNDB1XA

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DSNT501I and RC00C90094 during a REBUILD INDEX of
    DSNDB01X or DSNDB1XA when the index was deleted and
    redefined prior to the REBUILD.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL DB2 10 for z/OS users of REBUILD INDEX   *
    *                 rebuilding indexes on database DSNDB01.      *
    ****************************************************************
    * PROBLEM DESCRIPTION: DSNT501I and DSNT376I timeout           *
    *                      during REBUILD INDEX SHRLEVEL           *
    *                      CHANGE of DSNDB01X or DSNDB1XA.         *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    REBUILD INDEX SHRLEVEL CHANGE of index SYSIBM.DSNDB01X
    and SYSIBM.DSNDB1XA take a long time.  While building
    the index when the underlying data set does not exist,
    the elapsed time taken to complete the utility takes
    thirty minutes to build an index with only 38 entries.
    
    During the execution of the utility, MSGDSNT376I with
    CORRELATION-ID REBUILD CONNECTION-ID UTILITY and
    MSGDSNT501I RC00C900BA are issued on the console.  The
    subtask within REBUILD to build the index is getting a
    timeout on the REBUILD INDEX main task.
    

Problem conclusion

  • The code has been changed to recognize directory index
    spaces DSNDB01.DSNDB01X and DSNDB01.DSNDB1XA. They will now
    be processed by the REBUILD logic containing special handling
    for directory objects.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM91151

  • 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-06-14

  • Closed date

    2013-07-24

  • Last modified date

    2013-09-03

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

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

    UK96122

Modules/Macros

  •    DSNUGUTC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK96122

       UP13/08/14 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM91151

Modified date:

2013-09-03

Translate my page

Machine Translation

Content navigation