Troubleshooting
Problem
If a large number of fenced routines are being executed on a given instance, it is possible that the limit of db2fmp processes may be reached. This article outlines how to calculate how many db2fmp processes are allowed based on the current DB2_FMP_COMM_HEAPSZ variable setting.
Symptom
If you are reaching the FMP communication heap limit, you may see messages similar to the following in the db2diag.log
EDUID : 51965 EDUNAME: db2agent (DATABASE) 0
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 : <preformatted>
Out of memory failure for Undefined Heap on node 0.
Requested block size : 122900 bytes.
Physical heap size : 268304384 bytes.
Configured heap size : 23003136 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
LEVEL: Error
EDUID : 57514 EDUNAME: db2agent (DATABASE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:50
MESSAGE : Insufficient memory available for IPC communication with the db2fmp
process. Use the DB2_FMP_COMM_HEAPSZ registry variable to adjust the
amount of memory available for fenced routines.
DATA #1 : Hexdump, 4 bytes
0x0700000047FF6540 : 8B0F 003B ...;
[{"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":"a8m500000008PmhAAE","label":"Routines - Stored Procedures and UDF-\u003Edb2fmp"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
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:
23 January 2025
UID
swg21432522