Troubleshooting
Problem
The actual system memory usage by the CF is higher than what is reported from MON_GET_CF, and tends to grow over time, is this behavior as expected?
Symptom
Here is an example from AIX:
From svmon output, the CF memory usage is high, it stabilizes a bit above CF_MEM_SZ:
Memory size (4KB) (CF_MEM_SZ) = 20971520
But, from MON_GET_CF() output, CF does not really use such high memory:
$ db2 "SELECT HOST_NAME,ID,DB_NAME,CURRENT_CF_MEM_SIZE,CURRENT_CF_GBP_SIZE,CURRENT_CF_LOCK_SIZE,CURRENT_CF_SCA_SIZE FROM TABLE( MON_GET_CF( CAST(NULL AS INTEGER) ) ) AS CAMETRICS WITH UR"
Note: The unit of above output is 4KB. CURRENT_CF_MEM_SIZE is much lower than memory usage from svmon, sum of CURRENT_CF_GBP_SIZE, CURRENT_CF_LOCK_SIZE and CURRENT_CF_SCA_SIZE is also much lower than it.
On Linux, you may see the similar symptom, instead of svmon, you can refer to RSS/SHR in "top" output.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - PureScale","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
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
swg21989624