PM64912: ECSA STORAGE GROWTH FOR EXCSQLSET PARAMETER LIST AND REPLY BUFFER WHEN QUERY IS REPEATEDLY PREPARED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF defect pm64912 dpm64912
  ECSA storage growth for EXCSQLSET parameter list and reply
  buffer when query is repeatedly prepared.
  LCOMGSVL or DDF GLOBAL VL POOL grows very large.
  DSNLXRSQ UK75330 OFFSET7764 is the module acquiring storage.
  This happens for IDAA user.
  .
  DB2STGLK/K   IDAAV2R1/K
  **************************************************************
  Additional symptoms and keywords:
   ABEND04E ABND04E AB04E S004E 04E RC00E2001F 00E2001F
   ABEND04E ABND04E AB04E S004E 04E RC00E20022 00E20022
   ABEND878 ABND878 AB878 S0878 878 RC00000008 00000008 PIC8
   Storage leak leaked
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of IBM   *
  *                 DB2 Analytics Accelerator (IDAA).            *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ECSA storage pool with the           *
  *                      eyecatcher 'DDF GLOBAL VL POOL'         *
  *                      accumulates storage due to a storage    *
  *                      leak in the support of IDAA.  DB2 may   *
  *                      experience various symptoms due to the  *
  *                      excessive consumption of ECSA storage.  *
  *                      The symptoms include, but are not       *
  *                      limited to, DB2 and system abends such  *
  *                      as:                                     *
  *                      . 04E-00E2001F                          *
  *                      . 04E-00E20022                          *
  *                      . 878-00000008                          *
  *                      If the ECSA storage shortage becomes    *
  *                      severe, other subsystems and the        *
  *                      operating system itself may be          *
  *                      affected.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A DB2 for z/OS application repeatedly prepares a cursor
  statement to be offloaded to the IBM DB2 Analytics Accelerator.
  The application does not open the cursor after it is prepared.
  Each time the cursor statement is re-prepared, DB2 allocates a
  new block of ECSA storage for internal control blocks.  This
  caused a leak of the storage allocated during the previous
  prepare.  The ECSA storage leak will be associated with a DB2
  storage pool containing the following eyecatcher:
  . 'DDF GLOBAL VL POOL'
  To circumvent this issue, open all cursors prepared for query
  offload to IDAA.  Even if no rows are fetched, the ECSA storage
  will be freed correctly.
  

Problem conclusion

• DB2 has been corrected to release all storage acquired when
  preparing a cursor statement for offload to IDAA.
  

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:

  UK79589 UK79590

Modules/Macros

• DSNLXRSQ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK79589

     UP12/06/29 P F206

• R910 PSY UK79590

     UP12/06/29 P F206

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.