PM54903: ABEND04E RC00C90110 DSNIREFS:5003 AFTER AN INSERT FAILED DUE TO A DATABASE LOCK FAILURE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Dump Title: D99T,ABND=04E-00C90110,U=D9SATWCC,M=C8 ,C=101.DMC
  -DSNILREP,M=DSNTFRCV,LOC=DSNIDM  .DSNIREFS:5003
  An UPDATE issued ABEND04E RC00C90110 DSNIREFS:5003 because a
  part of stack area was overlaid.
  The overlaid area was pointed by CTIMKBUF as an index key buffer
  area.
  The pointer in CTIMKBUF was set in previous INSERT process and
  should have been cleared at end of the process.
  But the INSERT failed due to a deadlock on the database lock and
  the error path after the deadlock missed to clear the pointer.
  DSNT501I  -D99T DSNILMCL RESOURCE UNAVAILABLE 398
                  CORRELATION-ID=D9SATWCC0A06
                  CONNECTION-ID=RRSAF
                  LUW-ID=USNBNET.APPLD99T.C8D44BD4335C=725322
                  REASON 00C90088
                  TYPE 00000100
                  NAME WCC0205D
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of insert with     *
  *                 IO Parallelism                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90110 DSNIREFS ERQUAL5003 *
  *                      or other symptom may occur because a    *
  *                      variable was overlaid while doing       *
  *                      update with index key updated.          *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  The overlay occurred due to a residual pointer pointing to an
  index IO parallelism resource. Before the overlay, there was an
  insert operation with index IO parallelism happened. And during
  the insert, some error like dead lock RC00C90088 occurred, which
  led to the code path without cleaning that resource pointer.
  

Problem conclusion

• DB2 code was changed to handle the error code path correctly to
  make sure the IO parallelism related resource clean up is done.
  

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:

  UK75944

Modules/Macros

• DSNISRTI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK75944

     UP12/02/21 P F202

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.