PM67539: ABEND04E RC00E20003 OR 00E20004 FROM DSNSVBK FOR THE POOL CALLED ADMF AGL 31 OR CTLNGSTP FILLED WITH SELP STRUCTURES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E20003 or RC00E20004 for ADMF AGL 31 pool or
  CTLNGSTP. The pool is filled with SelP structures.
  Creating module for this structure is DSNIGSEL
  This happens for the process using the created temp table
  CGTT SQLCGTT
  DB2STGLK/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS (CM and above) users of  *
  *                 created global temporary tables (CGTT)       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E DSNSVBK RC00E20003 RC00E20004  *
  *                      on ADMF AGL 31 pool while running CGTT  *
  *                      application                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Storage leak may occur in the ADMF AGL 31 storage pool
  (CTLNGSTP) after continued runs of queries that use CGTTs.
  
  The leak involves the so-called P Procs or PProcs (predicate
  procs), new in V10 CM and higher, when they are built for CGTT.
  The eyecatcher in the dump was 'SelP'.
  
  The particular reported case for this APAR involved the CGTT
  application going through bind or dynamic prepare processing.
  Even though a P Proc, as expected, was not built at bind time/
  dynamic prepare time, a bit in the internal MSIB structure
  remained on by mistake through runtime, implying that it is OK
  to build the P Proc. However, P Procs are not supported for
  CGTTs as there is no freeing infrastructure in place for such
  cases.
  

Problem conclusion

• Code has been changed to ensure that the internal MSIB bit which
  affects P Proc building is not left on past bindtime/dynamic
  prepare time for CGTTs.
  
  In addition, code has been added for execution time (runtime) to
  ensure that P Procs are not built for CGTTs, so that a rebind is
  not necessary for this APAR to become effective.
  
  Additional keywords: DB2STGLK/K SQLCGTT
  

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:

  UK80931

Modules/Macros

• DSNIIMSI DSNXOMI  DSNXOMS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK80931

     UP12/08/24 P F208

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.