最近小型机有时会出现内存不足(在终端不能使用任何命令,老是报内存不足),但机子上只装了db2。
查看了下db2dialog.log,发现大量的S锁升级,日志如下,日志中对应的表只有查询操作
2010-03-19-18.52.27.600322+540 E491687190A540 LEVEL: Warning
PID : 229464 TID : 11959 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : XYDB
APPHDL : 0-27848 APPID: 192.168.166.81.35323.1003190920
AUTHID : DB2INST1
EDUID : 11959 EDUNAME: db2agent (XYDB) 0
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502W The escalation of "815" locks on table
"DB2INST1.T_QUERY_BASEINFONEW" to lock intent "S" was successful.
2010-03-19-18.52.27.627175+540 E491687731A582 LEVEL: Warning
PID : 229464 TID : 11959 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : XYDB
APPHDL : 0-27848 APPID: 192.168.166.81.35323.1003190920
AUTHID : DB2INST1
EDUID : 11959 EDUNAME: db2agent (XYDB) 0
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:2
MESSAGE : ADM5500W DB2 is performing lock escalation. The total number of
locks currently held is "809", and the target number of locks to hold
is "404".
快照如下:
Locks held currently = 9
Lock waits = 85
Time database waited on locks (ms) = Not Collected
Lock list memory in use (Bytes) = 41984
Deadlocks detected = 0
Lock escalations = 2978
Exclusive lock escalations = 0
Agents currently waiting on locks = 0
Lock Timeouts = 0
Block IOs = Not Collected
Pages from block IOs = Not Collected
Internal rollbacks due to deadlock = 0
Number of MDC table blocks pending cleanup = 0
Memory Pool Type = Lock Manager Heap
这样的情况正常吗??麻烦帮忙看看
收起