PK51648: LOAD RESUME YES SHRLEVEL CHANGE ABENDED WITH RC00E41002 AND DSNT500I WITH RC00C900E ON AN XML TABLE SPACE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • LOAD RESUME YES SHRLEVEL CHANGE ABENDED WITH RC00E41002 AND
    DSNT500I WITH RC00C900E ON AN XML TABLE SPACE
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS V9 utility users            *
    ****************************************************************
    * PROBLEM DESCRIPTION: LOAD SHRLEVEL CHANGE with XML columns   *
    *                      abended with RC00E41002 and issued      *
    *                      MSGDSNT500I with RC00C9008E indicating  *
    *                      a time out occurred trying to escalate  *
    *                      the locks on the indicated XML table    *
    *                      space                                   *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    LOAD SHRLEVEL CHANGE with XML columns was run concurrently with
    other jobs operating on the same XML table space.  The LOAD job
    abended with RC00E41002 and issued MSGDSNT500I with RC00C9008E
    indicating a time out occurred trying to escalate the locks on
    the indicated XML table space.  The time out occurred because
    another concurrent job already had a lock on the XML table
    space.
    

Problem conclusion

  • Code has been changed to disable lock escalation on XML table
    spaces for LOAD SHRLEVEL CHANGE.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK51648

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-08-23

  • Closed date

    2007-10-03

  • Last modified date

    2007-11-02

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

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

    UK29875

Modules/Macros

  • DSNDPSFI DSNIFPSC DSNIINFL DSNIPSCB DSNIPSFI
    DSNURPLI DSNURWI
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK29875

       UP07/10/18 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

9.1

Reference #:

PK51648

Modified date:

2007-11-02

Translate my page

Machine Translation

Content navigation