PL40865: RC00C90088 DBD TYPE 100 - DEADLOCK WHEN LOADING A SEGMENTED TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• THE LOAD UTILITY IS LOADING SEGMENTED TABLES AND IS PERFORMING
  (2) LOADS ON (2) TABLES THAT RESIDE IN (2) DIFFERENT TABLESPACES
   IN THE SAME DATABASE AND RECEIVES RC00C90088 DBD TYPE 100 WHICH
   IS A DEADLOCK.  THE PROBLEM IS INTERMITTENT.  ALSO, WHEN THEY
  RUN A DYNAMIC QUERY AGAINST TABLE 'A' TABLESPACE 'A' AND DOING
  A LOAD OF TABLE 'B' TABLESPACE 'B' THEY RECEIVE RC00C9008E
  DBD TYPE 100 WHICH IS A TIMEOUT CONDITION.  PL37153 IS APPLIED.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DB2 USERS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90088 DBD TYPE 100,       *
  *                      DEADLOCK WHEN LOADING SEGMENTED TABLES. *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF WHEN AVAILABLE.                    *
  ****************************************************************
  TWO LOAD UTILITY JOBS WERE RUN TO LOAD DATA INTO DIFFERENT
  SEGMENTED TABLESPACES IN THE SAME DATABASE.  THE ABEND WOULD
  OCCUR DUE TO A COMBINATION OF LOCKS OBTAINED ON THE DATA BASE
  DESCRIPTOR DURING THE UTILITY RELOAD PHASE.  DURING LOAD REPLACE
  OR REORG OF A SEGMENTED TABLESPACE, THE FIRST SEGMENT POINTER IN
  THE OBD IS UPDATED WHEN THE FIRST SEGMENT IS ALLOCATED DURING
  (RE)LOAD PHASE.  THIS WAS CAUSING AN 'X' LOCK TO BE OBTAINED ON
  THE DBD FOR COMMIT DURATION WHICH WAS CAUSING THE ABEND04E
  RC00C90088, DEADLOCK, OR RC00C9008E, LOCK TIMEOUT, ON ONE OR
  MORE OF THE UTILITY JOBS RUNNING ON THE SAME DATABASE.  AN
  ABEND04E RC00E400AF MAY ALSO BE PRODUCED BY THE UTILITY JOB
  DUE TO THE RESOURCE UNAVAILABLE CONDITION WHILE ATTEMPTING TO
  UPDATE THE DBD.
  

Problem conclusion

• CODE WAS CHANGED IN THE LOAD/REORG UTILITY ROUTINES TO ALLOW
  BYPASSING LOCK ESCALATION DURING A DSNGDALT CALL.  THIS ALLOWS
  BETTER CONTROL OF THE LOCKS OBTAINED ON THE DBD TO PREVENT THE
  DEADLOCK CONDITION.  CODE WAS ALSO CHANGED TO CAUSE A COMMIT TO
  BE DONE RIGHT AFTER 1ST SEGMENT ALLOCATION DURING RELOAD PHASE
  OF A LOAD OR REORG OF A SEGMENTED TABLESPACE.  THIS WILL
  PREVENT THE LOCK TIMEOUT PROBLEM BY REDUCING THE TIME THAT
  LOCKS ARE HELD ON THE DBD.
  

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:

  UL55139

Modules/Macros

•    DSNDDSI  DSNDURIB DSNGDAII DSNUGAFS DSNUGRST
  DSNURILD DSNURWBF
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R210 PSY UL55139

     UP89/07/18 P F906

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.