When FCM_NUM_BUFFERS is set to AUTOMATIC, in some rare case it
may still hit SQL6040C, No FCM buffers are available. The
db2diag.log may show 5 successful "MESSAGE : FCM
Automatic/Dynamic Resource Adjustment (Buffer)" before "MESSAGE
: Ran out low priority buffers", e.g.
2014-10-28-20.03.53.161793+000 I538582A596 LEVEL:
Warning
PID : 9699398 TID : 40582 PROC :
db2sysc 2
INSTANCE: db2edwp1 NODE : 002 DB :
DBEDWP1
APPHDL : 30-16720 APPID:
*N25.db2edwp1.1410282003533
AUTHID : EDACMS1P HOSTNAME: sa73edwdsp01
EDUID : 40582 EDUNAME: db2agntp (DBEDWP1) 2
FUNCTION: DB2 UDB, fast comm manager,
sqkfDynamicResourceMgr::AdjustResources, probe:175
MESSAGE : FCM Automatic/Dynamic Resource Adjustment (Buffer):
22375
successfully allocated. New total is 110980
................
2014-10-28-20.04.00.798329+000 I541567A596 LEVEL:
Warning
PID : 9699398 TID : 23474 PROC :
db2sysc 2
INSTANCE: db2edwp1 NODE : 002 DB :
DBEDWP1
APPHDL : 70-16699 APPID:
*N71.db2edwp1.1410282003523
AUTHID : EDACMS1P HOSTNAME: sa73edwdsp01
EDUID : 23474 EDUNAME: db2agntp (DBEDWP1) 2
FUNCTION: DB2 UDB, fast comm manager,
sqkfDynamicResourceMgr::AdjustResources, probe:175
MESSAGE : FCM Automatic/Dynamic Resource Adjustment (Buffer):
68020
successfully allocated. New total is 340100
2014-10-28-20.04.00.799351+000 I542164A677 LEVEL: Error
PID : 9699398 TID : 23474 PROC :
db2sysc 2
INSTANCE: db2edwp1 NODE : 002 DB :
DBEDWP1
APPHDL : 70-16699 APPID:
*N71.db2edwp1.1410282003523
AUTHID : EDACMS1P HOSTNAME: sa73edwdsp01
EDUID : 23474 EDUNAME: db2agntp (DBEDWP1) 2
FUNCTION: DB2 UDB, fast comm manager,
sqkfBufferManager::AllocBuffer, probe:55
MESSAGE : Ran out low priority buffers. Total=340100; Num in
freelist=67809;
med thres=68020; hi thres=34010
DATA #1 : Hexdump, 4 bytes
0x0700000469FFAC64 : 0000 0005
.... |
