PM87363: RC00C20305 AT DSNB1LCM+09AA

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND RC00C20305 at DSNB1LCM+09AA, after user alter tablespace's
    MAXPARTITIONS to higher number.
    NPI's PBLPART is get from old version OBD and is smaller than
    CLMPART which cause the abend.
    

Local fix

  • STOP/START problem tablespace can force update PBLPART and will
    avoid the abend.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS users of ALTER TABLESPACE.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: User receives ABEND04E RC00C20305       *
    *                      in DSNB1LCM +09AA on an ALTER           *
    *                      TABLESPACE MAXPARTITIONS statement.     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    
    ****************************************************************
    ABEND04E RC00C20305 DSNIDM DSNB1LCM +09AA received during
    ALTER TABLESPACE MAXPARTITIONS processing when concurrent DML
    is executing against the table space.  The abend occurs due to
    DB2 incorrectly serializing the ALTER TABLESPACE execution
    with the concurrent DML.  While this APAR addresses a specific
    reported symptom, other symptoms are possible.
    

Problem conclusion

  • DB2 has been changed to obtain an X-lock on the SYSTABLESPACE
    row during execution of ALTER TABLESPACE, serializing execution
    of ALTER TABLESPACE with concurrent DML on the table space.
    With PM87363 applied, concurrently running DML referencing a
    table space being altered may result in SQLCODE -911 or
    SQLCODE -904.
    
    ADDITIONAL KEYWORDS:
    SQLCODE911
    SQLCODE904
    SQLALTER
    OFFSET09AA
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87363

  • 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-04-19

  • Closed date

    2013-06-06

  • Last modified date

    2013-07-15

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

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

    UK94918

Modules/Macros

  • DSNXIATS DSNXISB1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94918

       UP13/06/21 P F306

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:

A10

Reference #:

PM87363

Modified date:

2013-07-15

Translate my page

Machine Translation

Content navigation