PI96536: ABEND0C4-0000003B DSNICMT1+0224 IS FOLLOWED BY ABEND0C4-00000038 DSNB1PCK+1E82 ON EVERY CHECKPOINT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4-0000003B DSNICMT1+0224 is followed by
  ABEND0C4-00000038 DSNB1PCK+1E82 on every checkpoint.
  some value of control blocks were overlaid with 'VSFB'.
  The subsequent recreation also generate dumps of
  ABND=0C4-00000011 DSNB1DCM+0E0A,DSNB1DBP+3AB4,DSNB1PMT+2274 with
  the 'VSFB' overlay issue.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 and 12 for z/OS users of          *
  *                 autonomous stored procedures                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 RC3B DSNICMT1 OFFSET+0224      *
  *                      may occur when autonomous procedures    *
  *                      is executed and it invokes further      *
  *                      nested routine or trigger.              *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  ABEND0C4 RC3B DSNICMT1 OFFSET+0224 may occur when autonomous
  procedures is invoked. The following abends may also occur:
  ABEND0C4 RC11 DSNB1DCM OFFSET+0E0A
  ABEND0C4 RC11 DSNB1DBP OFFSET+3AB4
  ABEND0C4 RC11 DSNB1PMT OFFSET+2274
  
  When an autonomous procedure invokes another nested routine or
  trigger, and the invoking statement has raised a positive SQL
  condition, Db2 may allocate storage to save the SQL condition in
  the autonomous thread's pool advertently.
  
  This storage is supposed to be allocated in the calling thread's
  pool since it could be reused by this thread later.
  
  The allocation in the incorrect storage pool can cause a storage
  overlay when the autonomous thread de-allocates at the end of
  the autonomous procedure execution and its pool is freed.
  

Problem conclusion

• Db2 code has been changed to allocate the saved SQL condition
  storage from the calling thread's pool when processing
  autonomous procedure.
  
  Additional Keywords:
  SQLSP SQLSTOREDPROC ABEND0C4
  

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:

  UI57531 UI57532

Modules/Macros

•    DSNXESTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI57532

     UP18/08/11 P F808

• RC10 PSY UI57531

     UP18/08/11 P F808

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.