锁升级相关日志:
INSTANCE.nfy:2013-01-29-09.08.17.207270 Instance:INSTANCE Node:007
PID:3204480(db2agntp (DBNAME) 7) TID:1 Appid:GA4624A4.CAAA.1E34F9010105
data management sqldEscalateLocks Probe:2 Database:DBNAME
ADM5500W DB2 is performing lock escalation. The total number of locks
currently held is "547441", and the target number of locks to hold is "273720".
^^
2013-01-29-09.08.17.210979 Instance:INSTANCE Node:007
PID:3204480(db2agntp (DBNAME) 7) TID:1 Appid:GA4624A4.CAAA.1E34F9010105
data management sqldEscalateLocks Probe:3 Database:DBNAME
ADM5502W The escalation of "547437" locks on table "SCHEMA.TB" to lock intent "X" was successful.
db2diag.log:2013-01-29-09.08.17.211128+480 E76526448A476 LEVEL: Warning
PID : 3204480 TID : 1 PROC : db2agntp (DBNAME) 7
INSTANCE: INSTANCE NODE : 007 DB : DBNAME
APPHDL : 17-1304 APPID: GA4624A4.CAAA.1E34F9010105
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502W The escalation of "547437" locks on table "SCHEMA.TB" to lock intent "X" was successful.
--locklist是85536,maxlocks是10,系统是AIX 64位,DPF 32nodes
85536*4K*10/100=34,214.4K
--数据仓库系统,我有没有必要修改参数locklist的大小。下面的273720是怎么计算出来的
currently held is "547441", and the target number of locks to hold is "273720".
收起