DB2 锁升级示例

核心提示：ISSYSTEM126_0_, caseinfo0_.SYSTEMPARTYNAME as SYSTEMP32_126_0_, caseinfo0_.MARKVALUE as MARKVALUE126_0_, caseinfo0_.ISCOMPLETE as ISCOMPLETE126_0_, caseinfo0_.I

ISSYSTEM126_0_, caseinfo0_.SYSTEMPARTYNAME as SYSTEMP32_126_0_,
caseinfo0_.MARKVALUE as MARKVALUE126_0_, caseinfo0_.ISCOMPLETE as
ISCOMPLETE126_0_, caseinfo0_.ISWSCOMPLETE as ISWSCOM35_126_0_,
caseinfo0_.COMPLETEDATE as COMPLET36_126_0_,
caseinfo0_.DISCUSSCONTENT as DISCUSS37_126_0_,
caseinfo0_.LAWSUITCONTENT as LAWSUIT38_126_0_,
caseinfo0_.CORRECTCONTENT as CORRECT39_126_0_,
caseinfo0_.DEPORTATIONCODE as DEPORTA40_126_0_, caseinfo0_.ISBIGCASE
as ISBIGCASE126_0_, caseinfo0_.CITYAPPROVE as CITYAPP42_126_0_,
caseinfo0_.CITYMAN as CITYMAN126_0_, caseinfo0_.CITYDATE as
CITYDATE126_0_, caseinfo0_.PROVINCEAPPROVE as PROVINC45_126_0_,
caseinfo0_.PROVINCEMAN as PROVINC46_126_0_, caseinfo0_.PROVINCEDATE
as PROVINC47_126_0_, caseinfo0_.REPORTEMPLOYEEID as REPORTE48_126_0_,
caseinfo0_.DISPOSEEMPLOYEEID as DISPOSE49_126_0_,
caseinfo0_.SAVEDEPTNAME as SAVEDEP50_126_0_, caseinfo0_.SAVEDEPTID as
SAVEDEPTID126_0_, caseinfo0_.WSCLASS as WSCLASS126_0_,
caseinfo0_.PARTY_LICECODE as PARTY53_126_0_, caseinfo0_.LABH as
LABH126_0_, caseinfo0_.CASE_REGTIME as CASE55_126_0_,
caseinfo0_.JBTSLIST_ID as JBTSLIST56_126_0_ from T_ZMC_CASEINFO
caseinfo0_ where caseinfo0_.LIST_ID=?".

2012-08-20-13.11.16.457790+480 I5919A438 LEVEL: Warning
PID : 8913288 TID : 170780 PROC : db2sysc 1
INSTANCE: db2sdin1 NODE : 001
APPHDL : 0-20855
EDUID : 170780 EDUNAME: db2agntp 1
FUNCTION: DB2 UDB, database monitor, sqm_snap_appl_locks, probe:10
MESSAGE : Snapshot cannot obtain lock information for application with app
handle 7138. Application in rollback.

2012-08-20-13.11.16.497087+480 I6358A438 LEVEL: Warning
PID : 8913288 TID : 170780 PROC : db2sysc 1
INSTANCE: db2sdin1 NODE : 001
APPHDL : 0-20855
EDUID : 170780 EDUNAME: db2agntp 1
FUNCTION: DB2 UDB, database monitor, sqm_snap_appl_locks, probe:10
MESSAGE : Snapshot cannot obtain lock information for application with app
handle 7105. Application in rollback.

2012-08-20-13.11.16.514391+480 I6797A438 LEVEL: Warning
PID : 8913288 TID : 170780 PROC : db2sysc 1
INSTANCE: db2sdin1 NODE : 001
APPHDL : 0-20855
EDUID : 170780 EDUNAME: db2agntp 1
FUNCTION: DB2 UDB, database monitor, sqm_snap_appl_locks, probe:10
MESSAGE : Snapshot cannot obtain lock information for application with app
handle 6460. Application in rollback.

发生锁升级后，数据库中锁的数量变少了，但是锁的级别却变高了，影响更大，这个例子中，锁升级成对表的排他锁（ lock intent "X" ）。锁升级后，系统很快就恢复正常了。我现在不清楚这里面的前因后果，猜测可能是升级锁后，该应用便可以独占的持有表，确保其顺利的将业务做完，最后释放所锁。