PM50870: ABEND04E RC00E2000C FROM DSNSVSVB OFFSET0AAA FOR THE STMT CACHE BLOCKS 2G POOL WITH FULL OF STMT TEXT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E2000C from DSNSVSVB OFFSET0AAA
  for the STMT CACHE BLOCKS 2G pool with full of STMT text that
  was allocated by DSNGEPLC at UK69377 OFFSETE324. This offset
  resolves to DSNXEISH get storage call.
  Turning on IFCID 401 causes this issue.
  Additional symptoms : 04E 00E2000C DSNGEPLC DSNSVSVB OFFSET0B10
                        04E 00E2000C DSNXODMH DSNSVSVB OFFSET0B10
                        04E 00E2000C DSNXEDS1 DSNSVSVB OFFSET0B10
  .
  ADDITIONAL KEYWORD: ACOMDSC2GP IFCID401 DB2STGLK/K
  

Local fix

• Disable IFCID401
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users of PROFILE MONITORING of       *
  *                 static sql statements.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following abends can be received:   *
  *                      ABND04E RC00E2000C in                   *
  *                         DSNGEPLC.DSNSVSVB+0B10               *
  *                         DSNXODMH.DSNSVSVB+0B10               *
  *                         DSNXEDS1.DSNSVSVB+0B10               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using PROFILE MONITORING or when IFCID 400 or 401 are on
  a storage leak can occur. This can result in one of the
  following abends:
  
  ABND04E RC00E2000C in DSNGEPLC.DSNSVSVB+0B10
  ABND04E RC00E2000C in DSNXODMH.DSNSVSVB+0B10
  ABND04E RC00E2000C in DSNXEDS1.DSNSVSVB+0B10
  

Problem conclusion

• When an SKPT is removed from the EDM pool any SHTE control
  blocks that were created for the SKPT that are not in use are
  freed.  DB2 code did not check the SHTE to see if storage had
  been allocated for the statement text.  The storage for the
  statement text could be orphaned eventually causing the ABEND
  with RC00E2000C.  The code has been updated to free the storage
  used for the statement text when the SHTE is freed.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK73903

Modules/Macros

• DSNGEPSH
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK73903

     UP11/12/02 P F112

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.