IBM Support

PI32168: 04E-00E2000C DSNLXRSQ.DSNSVSVB+0B06 DUE TO SLOW ACCUMULATION OF STORAGE DURING AN IDAA CONNECTION 15/04/30 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Defect 174809 d174809
    IDAA users can experience 04E-00E2000C DSNLXRSQ.DSNSVSVB+0B06
    abend due to slow accumulation of storage (storage leak) during
    an IDAA connection.
    The problem occurs after APAR PM96000 PTF UI17239.
    ***************************************************************
    Additional Symptoms and Keywords:
     IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
     ABEND04E AB04E S004E 04E
      04E-00E2000C 00E2000C RC00E2000C
       DSNLXRSQ DSNXVSVB DSNLXRSQ.DSNSVSVB+0B06 0B06 OFFSET0B06
       DSNIDBAE DSNXVSVB DSNIDBAE.DSNSVSVB+0B06 0B06 OFFSET0B06
       DSNIDBDF DSNXVSVB DSNIDBDF.DSNSVSVB+0B06 0B06 OFFSET0B06
       DSNIDBMG DSNXVSVB DSNIDBMG.DSNSVSVB+0B06 0B06 OFFSET0B06
       DSNIDBNG DSNXVSVB DSNIDBNG.DSNSVSVB+0B06 0B06 OFFSET0B06
       DSNIDBDR DSNXVSVB DSNIDBDR.DSNSVSVB+0B06 0B06 OFFSET0B06
     Short on Storage SOS storage leak
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users of the IBM Data Analytics      *
    *                 Accelerator (IDAA) who have applied          *
    *                 PM96000/UI17239.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 for z/OS systems which offload      *
    *                      queries to an IDAA server may           *
    *                      experience various Short on Storage     *
    *                      related symptoms. Known symptoms        *
    *                      include:                                *
    *                      ABND=04E-00E2000C at                    *
    *                       DSNLXRSQ.DSNSVSVB+0B06                 *
    *                      ABND=04E-00E2000C at                    *
    *                       DSNIDBAE.DSNSVSVB+0B06                 *
    *                      ABND=04E-00E2000C at                    *
    *                       DSNIDBDF.DSNSVSVB+0B06                 *
    *                      ABND=04E-00E2000C at                    *
    *                       DSNIDBMG.DSNSVSVB+0B06                 *
    *                      ABND=04E-00E2000C at                    *
    *                       DSNIDBNG.DSNSVSVB+0B06                 *
    *                      ABND=04E-00E2000C at                    *
    *                       DSNIDBDR.DSNSVSVB+0B06                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    After applying PM96000/UI17239, DB2 did not properly release
    storage for an internal control block for queries which are
    offloaded to IDAA.  This caused a storage leak within DB2.
    Over time, this storage leak can result in a storage shortage
    and DB2 ABEND04E-00E2000C.
    

Problem conclusion

  • DB2 has been changed to always free internal control block
    storage for queries offloaded to IDAA.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI32168

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-05

  • Closed date

    2015-05-07

  • Last modified date

    2015-06-01

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

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

    UI27441

Modules/Macros

  •    DSNLXSRX
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI27441

       UP15/05/22 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.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI32168

Modified date: 01 June 2015


Translate this page: