Troubleshooting
Problem
PRIVATE memory could leak in case a database manager (db2syscs.exe) is running in Db2 V11.1m4fp4 or V11.5fp0 on Windows.
As a result of this memory leak, the following symptoms might be reported:
As a result of this memory leak, the following symptoms might be reported:
- Application performance degrades since it cannot allocate memory for DATABASE MEMORY.
- Database activation fails due to memory shortage.
- Connections to a database fail or take long time due to memory shortage.
- SQLs might return various memory shortage-related errors, such as SQL0973N, SQL0101N, SQL0954N are returned.
Symptom
In db2pd -dbptnmem command output, we can see increase in PRIVATE memory set.
Then, if we run "db2pd -memblock private sort", we can see that most part of the PRIVATE set are consumed by LOC or FILE memory blocks.
Then, if we run "db2pd -memblock private sort", we can see that most part of the PRIVATE set are consumed by LOC or FILE memory blocks.
All memory consumers in Private memory set: PoolAddr PoolID PoolName SecondID TotalSize(Bytes) %Bytes TotalCount %Count LOC File 0x000001504C280498 86 persist 0 7663597408 99.87 216388 99.43 476 4284367586
NOTE: A heavy use of db2pd -memblock command puts a high system load, and could cause another memory leak.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m0z000000GozAAAS","label":"Memory"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.1.0;11.5.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
ibm16462549