IBM Support

PK99747: INCOMPATIBLE RETAINED LOCKS DETECTED DURING GROUP RESTART.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Module DXRRL2R2:03 RETLOCK Detected Incompatible Lock
    detected.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 data sharing users.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Failures during a group restart, when   *
    *                      a page set is in GRECP state and has    *
    *                      indoubt URs with an interest in it:     *
    *                      - For V8 only, abend in IRLM module     *
    *                        DXRRL2R2 due to incompatible retained *
    *                        lock.                                 *
    *                      - For both V8 and V9, ABEND04E          *
    *                        RC00C2010E in DSNB1LPL.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    For DB2 V8, an attempt to open a page set in GRECP state will be
    treated as a failure, and the page set will immediately be
    closed and its P-lock released.  If the page set has indoubt URs
    interested in it, it will be logged during DB2 checkpoints, but
    as "non-GBP-dependent" since no P-lock is held.  If two members
    have indoubt URs, then they will both be logging the page set as
    "non-GBP-dependent".  In the event of a group restart, DB2 will
    attempt to build retained page set P-locks for both members
    based on these log records, and will try to build a retained X
    lock for both.  This causes an abend in IRLM since the locks are
    incompatible.
    
    For both V8 and V9, a group restart with indoubt URs and a page
    set in GRECP state may attempt to put the page set into LPL.
    The LPL logic may try to use a peer member's restart LRSN as
    the starting LRSN for the LPL range, but if that member was
    quiesced then its restart LRSN will be x'FFFFFFFFFFFF'.  Using
    that value results in an ABEND04E RC00C2010E in DSNB1LPL, since
    it will be higher than the ending LRSN.
    

Problem conclusion

  • The V8 page set open logic has been modified to hold on to the
    page set P-lock if the page set is in GRECP state.  This ensures
    that it will correctly be logged as GBP-dependent.
    
    The V8 and V9 LPL logic has been modified to not consider the
    peer's restart LRSN if it is set to x'FFFFFFFFFFFF' (member was
    quiesced).
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PK99747

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-27

  • Closed date

    2009-11-20

  • Last modified date

    2010-01-05

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

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

    UK52192 UK52193

Modules/Macros

  • DSNB1LPL DSNB1OPP DSNB1OPS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK52192

       UP09/12/08 P F912

  • R910 PSY UK52193

       UP09/12/08 P F912

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

Document Information

Modified date:
05 January 2010