PI69086: CONCURRENT LOAD JOBS ENFORCE REPLACE AT PARTITION LEVEL AGAINST DIFFERENT PARTITIONS GET DEADLOCK RC00C90088 RC00E4001C

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Concurrent load jobs using ENFORCE PART nn REPLACE against
  different partitions get DEADLOCK RC00C90088 RC00E4001C during
  catalog access
  
  Additional symptoms and search keywords
  RC00C90088 RC00E4001C
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 12 for z/OS users of the LOAD utility with ENFORCE   *
  * CONSTRAINTS.                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00E4001C with DSNT375I and DSNT500I, RC00C90088,  *
  * TYPE 304 during concurrent LOAD INTO TABLE PART x REPLACE    *
  * utility jobs of different partitions of the same dependent   *
  * table.                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  User ran concurrent LOAD INTO TABLE PART x REPLACE utility jobs
  of different partitions of the same dependent table space with
  ENFORCE CONSTRAINTS.  Several of the LOAD utility jobs abended
  with an ABEND04E RC00E4001C due to RC00C90088 DEADLOCK issuing
  MSGDSNT375I and MSGDSNT500I naming SYSTSTSP as the RESOURCE
  UNAVAILABLE.
  
  Deadlock scenario:
  
  Loser
    LOAD INTO TABLE PART x REPLACE utility in the UTILINIT phase
  acquiring object information:
      Held a shared lock on SYSTABLES
      Waiting on a shared lock for SYSTABLESPACE
  Winner
    LOAD INTO TABLE PART x REPLACE utility in the ENFORCE phase
  against a different partition of the same dependent table:
      Held an exclusive lock on SYSTABLESPACE
      Waiting on an exclusive lock for SYSTABLES
  
  The problem can also occur with other utilities running
  concurrently with a LOAD ENFORCE CONSTRAINTS INTO TABLE PART x
  REPLACE utility.
  
  A commit is needed for LOAD after catalog access when turning
  off CHECK PENDING status in the catalog.
  

Problem conclusion

• Code has been modified to correct the aforementioned problem.
  

Temporary fix

Comments

APAR Information

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

  PI68757

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

  UI42597

Modules/Macros

• DSNUGCKP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI42597

     UP16/12/02 P F612

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.