PI31527: ABEND04E RC00E20004 DSNSVBK OFFSET0718 , CALLER DSNIGSEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following abends were received as the ADMF AGL pool became
  filled with 'SELK' and/or 'SELP' blocks.
   DSN ,ABND=04E-00E20004,U=uuuuuuu ,M=N  ,C=101.DMC
   -DSNIRSET,M=DSNTFRCV,LOC=DSNIGSEL.DSNSVBK +0718
                                                                 .
   DSN ,ABND=04E-00E20004,U=uuuuuuu ,M=N  ,C=101.DMC
   -DSNIFDPO,M=DSNTFRCV,LOC=DSNKGSEL.DSNSVBK +0718
                                                                 .
  (Looking at the thread which abends ds=3:
  ACE: 15FBFC00 Status: T * Req: 0CEE    Allied Chain
   CT: 000002517BD9AD08 Lg: nnnnnnnn 1048584K AGL ..
                        [[[[[[[[[[[[[[[[[[[[[[[[[
  Then under sm=5 , find on address nnnnnnnn
                                                                 .
  nnnnnnnn  ADMF AGL 31 correlation-id   Var    1048584K  12 229
  ..         SelK............  00000000  DSNKGSEL +1757    UK79393
  ..         SelP............  00000000  DSNIGSEL +1895    UK79393
  ..         SelK............  00000000  DSNKGSEL +1757    UK79393
  ..         SelP............  00000000  DSNIGSEL +1895    UK79393
   many lines like above, repeated.
                                                                 .
  Additional keywords: pproc . phbmstor , mstor exceeded .
                       rc00e40002 with dsnsvbk caller dsnigsel or
                       dsnkgsel .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 z/OS V10 and V11 queries using the       *
  *                 Data Partitioned Secondary Index (DPSI)      *
  *                 with a WHERE clause.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E20004 DSNSVBK +'0718'     *
  *                      and the caller is DSNIGSEL. Large       *
  *                      number of SelP and SelK blocks were     *
  *                      requested by DSNIGSEL and DSNKGSEL.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABENDS04E RC00E20004 occurred due to ADMF storage pool full.
  The storage was filled with a rather large number of SELK and
  SELP storage blocks. These SELK and SELP storage blocks were
  acquired repeatedly for the same query, causing the storage
  pool to be full.
  

Problem conclusion

• DB2 code was fixed to acquire the SELP and SELK storage
  block correctly.  This error is only relevant to queries
  using DPSI indexes.
  

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:

  UI25534 UI25535

Modules/Macros

•    DSNIFDPO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI25534

     UP15/03/14 P F503 Ž

• RB10 PSY UI25535

     UP15/03/14 P F503 Ž

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.