WEB开发网
开发学院数据库DB2 DB2 锁升级示例 阅读

DB2 锁升级示例

 2012-08-20 17:01:56 来源:WEB开发网   
核心提示: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" )。锁升级后,系统很快就恢复正常了。我现在不清楚这里面的前因后果,猜测可能是升级锁后,该应用便可以独占的持有表,确保其顺利的将业务做完,最后释放所锁。

上一页  1 2 

Tags:DB 升级

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接