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

Obtain the fix for this APAR.

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 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.