PM51083: WHEN PACKAGE IS IN AUTOBIND AND ANOTHER THREAD IS EXECUTING PACKAGE, DEADLOCK ON DSNDB01.SPT01 RC00C90088 MAY OCCUR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • When a package is in auto-bind and another thread is executing
    package, both of them apply lock on SKPT and DSNDB01 SPT01
    DSNT375I DEADLOCK DSNT501I RESOURCE UNAVAILABLE 00C90088
    may occur.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 package users.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: When executing packages, customer hit   *
    *                      the following deadlocks,                *
    *                                                              *
    *                      1. DSNT375I -DP14 PLAN=ONL1PLAN WITH    *
    *                         238 CORRELATION-ID=ENTR30010014      *
    *                         CONNECTION-ID=CIQ6BQAG               *
    *                         LUW-ID=CNABCFSN.DP14APLS.            *
    *                         C89152C7EFC2 =15973                  *
    *                         THREAD-INFO=CICSDFLT:*:*:*           *
    *                         IS DEADLOCKED WITH PLAN= WITH        *
    *                         CORRELATION-ID=020.AUTBND06          *
    *                         CONNECTION-ID=DP12                   *
    *                         LUW-ID=CNABCFSN.DP12APLS.            *
    *                         C89152C800D9                         *
    *                         THREAD-INFO=SYSOPR:*:*:*             *
    *                                                              *
    *                      2. DSNT501I -DP12 DSNILMCL RESOURCE     *
    *                         UNAVAILABLE 179                      *
    *                         CORRELATION-ID=020.AUTBND06          *
    *                         CONNECTION-ID=DP12                   *
    *                         LUW-ID=CNABCFSN.DP12APLS.            *
    *                         C89152E7A52E=0                       *
    *                         REASON 00C90088                      *
    *                         TYPE 00000302                        *
    *                         NAME DSNDB01 .SPT01   .X'00187A'     *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    After a DB2 object is altered or drop/re-created, the packages
    which reference that DB2 object are invalidated. Executing
    such packages will trigger auto-bind. If this auto-bind happens
    at the same time as loading the package from DASD, there could
    be a deadlock situation.
    

Problem conclusion

  • DB2 has been changed to avoid acquiring a page set S-lock when
    reading a package from DASD, which fixes the deadlock problem.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM51083

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-27

  • Closed date

    2011-12-02

  • Last modified date

    2012-04-02

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

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

    UK74454 UK74455 UK74456

Modules/Macros

  •    DSNGEFLC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UP

       AM51083

  • R810 PSY UP

       AM51083

  • R910 PSY UP

       AM51083



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM51083

Modified date:

2012-04-02

Translate my page

Machine Translation

Content navigation