A fix is available
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 number
PI31527
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-12-15
Closed date
2015-02-27
Last modified date
2015-04-02
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 May 2020