A fix is available
APAR status
Closed as program error.
Error description
ABEND04E 04E RC00E20033 00E20033 occurred when SPRMRSMX limit was exceeded. DB2 abends as expected. A possible logrec entry prior to the 00E20033 error with ABENDDC2 RC4F001E21 for buffer manager detach error IARV64 DETACH from DSNB1DVP may be present. Orphaned memory objects were observed with scattered fixed pages in them were not successfully detached. Buffer pool information merged with RSM high virtual information will show RSM entries with no corresponding BM entry. DB2STGLK/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: DB2 users. * **************************************************************** * PROBLEM DESCRIPTION: ABENDDC2 RC4F001E21 on IARV64 DETACH * * request by DSNB1DVP, when deleting * * buffer pool storage. This shows up * * only as a logrec entry since DB2 will * * suppress the dump. * * * * This abend is caused by DB2 freeing * * buffer storage which is partially page- * * fixed. This may eventually result in * * ABEND04E RC00E20033 if the storage leak * * causes the SPRMRSMX limit to be hit. * **************************************************************** * RECOMMENDATION: * **************************************************************** For DB2 V9 and V10, the prefetch logic may leave buffer pool pages fixed when prefetching a compressed index, when all of the requested pages are obtained from the group buffer pool. For DB2 V8, V9, and V10, there are other scenarios which may result in pages being left fixed (such as cancel windows, storage overlays, or improperly retried abends). For whatever the reason, when DB2 attempts to free buffer pool storage containing fixed pages, an ABENDDC2 results and the storage does not get freed, resulting in an above-the-bar memory leak.
Problem conclusion
For DB2 V9 and V10, the prefetch logic has been modified to ensure that buffer pool storage is unfixed when a set of pages for a compressed index are all retrieved from the group buffer pool. For DB2 V8, V9, and V10, the allocation of buffer pool storage has been modified to specify that it should be allowed to be freed even if it contains fixed pages.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM35062
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-17
Closed date
2011-05-05
Last modified date
2011-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK67467 UK67468 UK67469
Modules/Macros
DSNB1ABS DSNB1BVP DSNB1DVP DSNB1PMI DSNB5RAP
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK67467
UP11/05/21 P F105
R810 PSY UK67468
UP11/05/21 P F105
R910 PSY UK67469
UP11/05/21 P F105
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 June 2011