PM87360: STATIC INSERT WITH CONCURRENT DROP INDEX CAUSES ABEND04E RC00C90101 DSNICTBU:5004.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Dump Title: D1E1,ABND=04E-00C90110,U=LOW12OTM,M=(N),C=910.DMC
    -DSNICTBU,M=DSNTFRCV,LOC=DSNIDM  .DSNICTBU:5004
    A static INSERT issued ABEND04E RC00C90101 DSNICTBU:5004 when a
    DROP INDEX of an index on the table to be inserted was executed
    concurrently.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 9 and 10 for z/OS users of CREATE INDEX  *
    *                 and DROP INDEX.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: User receives ABEND04E RC00C90110 in    *
    *                      DSNICTBU erqual5004 on a DROP INDEX     *
    *                      statement.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The following abends were received during DROP INDEX processing
    when a static insert is concurrently executing against the
    table on which the index is defined:
    ABEND04E RC00C90110 DSNIDM DSNICTBU erqual5004
    ABEND04E RC00C90101 DSNK2DM DSNKINSL erqual5003
    The abends occur due to DB2 incorrectly serializing DROP INDEX
    and CREATE INDEX execution with concurrent DML.  While this
    APAR addresses specific reported symptoms, other symptoms are
    possible.
    

Problem conclusion

  • DB2 has been changed to obtain a lock of commit duration on
    packages dependent on the base table during execution of CREATE
    INDEX and DROP INDEX, serializing execution of CREATE INDEX
    and DROP INDEX with concurrent DML on the table.  With PM87360
    applied, concurrently running DML referencing a table on which
    CREATE INDEX or DROP INDEX is executing may result in
    SQLCODE -911 or SQLCODE -904.
    
    ADDITIONAL KEYWORDS:
    SQLCODE911
    SQLCODE904
    SQLCREATE
    SQLDROP
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87360

  • 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

    2013-04-18

  • Closed date

    2013-06-24

  • Last modified date

    2013-08-02

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

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

    UK95365 UK95366

Modules/Macros

  •    DSNXIDPM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK95365

       UP13/07/10 P F307

  • R910 PSY UK95366

       UP13/07/10 P F307

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:

910

Reference #:

PM87360

Modified date:

2013-08-02

Translate my page

Machine Translation

Content navigation