PH65743: ABEND0C4 RC00000010 DSNXECL OFFSET00B84 DUE TO A ONE BIT OVERLAYIN DSNGEPDL WHEN DDL STATEMENT DOES STATEM 25/05/21 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC10 DSNXECL OFFSET00B84 occurs due to a 1-bit overlay
  in DSNGEPDL. When a DDL statement does statement level
  invalidation (partially invalidating a package/SKPT) , it is
  missing latch to serialize against LRU. If the SKPT is LRUed out
  
  and the storage is reused, this 1-bit overlay can occur.
  
  Additional symptom: ABEND 0C4 PIC10 DSNICUMW+0FAD8
  
  Additional keywords:  DB2OVRLAY/K SQLSTORAGE SQLDYNSTMTCACHE
                       ABENDS0C4 0C4 0000003B RC3B PIC3B
                       DSNB1DCM OFFSET00D2E
                       PIC10 DSNICUMW OFFSET0FAD8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Db2 13 z/OS users of statement level         *
  *                 package dependency with PH55497/UI93128      *
  *                 applied.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 RC00000010 DSNXECL             *
  *                      OFFSET00B84 DUE TO A ONE BIT OVERLAY    *
  *                      Other abend symptoms:                   *
  *                      ABEND0C4 RC0000003B DSNIDM.DSNIFDIC     *
  *                      OFFSET00C06                             *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  With PH55497/UI93128 applied, 1-bit storage overlay may occur
  during statement level invalidation operation:
  
  When BIND or REBIND package operates with DEPLEVEL(STATEMENT)
  option, the package has statement level dependency.
  
  When a DDL statement operation does statement level
  invalidation(partially invalidating) for a dependent package in
  EDM skeleton pool, it is missing latch to serialize against
  LRU. If the package is LRUed out and the storage is reused,
  this 1-bit overlay can occur.
  
  There can be other symptoms due to the storage overlay.
  
  Additional keywords:  DB2OVRLAY/K SQLSTORAGE SQLDYNSTMTCACHE
  

Problem conclusion

• Db2 is fixed to correctly hold a latch when it does statement
  level invalidation.
  

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:

  UO03312

Modules/Macros

• DSNGEPDL DSNXIDPM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO03312

     UP25/05/29 P F505 ­

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.