Prayer

C:\>db2 get snapshot for locks on js

            數(shù)據(jù)庫(kù)鎖定快照

數(shù)據(jù)庫(kù)名稱                               = JS
數(shù)據(jù)庫(kù)路徑                          = D:\DB2\NODE0000\SQL00001\
輸入數(shù)據(jù)庫(kù)別名                      = JS
掛起的鎖定                      = 5
當(dāng)前已連接的應(yīng)用程序            = 1
當(dāng)前正等待鎖定的代理程序數(shù)      = 0
快照時(shí)間戳記                    = 2007-09-04 12:54:33.121513

應(yīng)用程序句柄                               = 10
應(yīng)用程序標(biāo)識(shí)                        = *LOCAL.DB2.070904045330
序號(hào)                                = 00001
應(yīng)用程序名                          = db2taskd
CONNECT 授權(quán)標(biāo)識(shí)                           = ADMINISTRATOR
應(yīng)用程序狀態(tài)                        = 連接已完成
狀態(tài)更改時(shí)間                        = 未收集
應(yīng)用程序代碼頁(yè)                             = 1208
掛起的鎖定                      = 0
總計(jì)等待時(shí)間（毫秒）            = 未收集


應(yīng)用程序句柄                               = 9
應(yīng)用程序標(biāo)識(shí)                        = *LOCAL.DB2.070904045329
序號(hào)                                = 00001
應(yīng)用程序名                          = db2stmm
CONNECT 授權(quán)標(biāo)識(shí)                           = ADMINISTRATOR
應(yīng)用程序狀態(tài)                        = 連接已完成
狀態(tài)更改時(shí)間                        = 未收集
應(yīng)用程序代碼頁(yè)                             = 1208
掛起的鎖定                      = 0
總計(jì)等待時(shí)間（毫秒）            = 未收集


應(yīng)用程序句柄                               = 8
應(yīng)用程序標(biāo)識(shí)                        = *LOCAL.DB2.070904045327
序號(hào)                                = 00011
應(yīng)用程序名                          = javaw.exe
CONNECT 授權(quán)標(biāo)識(shí)                           = ADMINISTRATOR
應(yīng)用程序狀態(tài)                        = UOW 正在等待
狀態(tài)更改時(shí)間                        = 未收集
應(yīng)用程序代碼頁(yè)                             = 1208
掛起的鎖定                      = 5
總計(jì)等待時(shí)間（毫秒）            = 未收集

鎖定列表
鎖定名稱                       = 0x020010000D0080080000000052
鎖定屬性                       = 0x00000000
發(fā)行版標(biāo)志                     = 0x40000000
鎖定計(jì)數(shù)                       = 1
掛起計(jì)數(shù)                       = 0
鎖定對(duì)象名                     = 142606349
對(duì)象類(lèi)型                       = 行
表空間名                       = USERSPACE1
表模式               = JS
表名                 = US_CATALOG
方式                           = X

鎖定名稱                       = 0x02001000090080080000000052
鎖定屬性                       = 0x00000000
發(fā)行版標(biāo)志                     = 0x40000000
鎖定計(jì)數(shù)                       = 1
掛起計(jì)數(shù)                       = 0
鎖定對(duì)象名                     = 142606345
對(duì)象類(lèi)型                       = 行
表空間名                       = USERSPACE1
表模式               = JS
表名                 = US_CATALOG
方式                           = X

鎖定名稱                       = 0x01000000010000000100EA0056
鎖定屬性                       = 0x00000000
發(fā)行版標(biāo)志                     = 0x40000000
鎖定計(jì)數(shù)                       = 1
掛起計(jì)數(shù)                       = 0
鎖定對(duì)象名                     = 0
對(duì)象類(lèi)型                       = 內(nèi)部變化鎖定
方式                           = S

鎖定名稱                       = 0x5359535348323030DDECEF2841
鎖定屬性                       = 0x00000000
發(fā)行版標(biāo)志                     = 0x40000000
鎖定計(jì)數(shù)                       = 1
掛起計(jì)數(shù)                       = 0
鎖定對(duì)象名                     = 0
對(duì)象類(lèi)型                       = 內(nèi)部方案鎖定
方式                           = S

鎖定名稱                       = 0x02001000000000000000000054
鎖定屬性                       = 0x00000000
發(fā)行版標(biāo)志                     = 0x40000000
鎖定計(jì)數(shù)                       = 2
掛起計(jì)數(shù)                       = 0
鎖定對(duì)象名                     = 16
對(duì)象類(lèi)型                       = 表
表空間名                       = USERSPACE1
表模式               = JS
表名                 = US_CATALOG
方式                           = IX



C:\>db2 list applications

授權(quán)標(biāo)識(shí)程序  應(yīng)用程序名    應(yīng)用程序句柄    應(yīng)用程序標(biāo)識(shí)            數(shù)據(jù)庫(kù)名稱    代理序號(hào)
------------ -------------- -------------- ------------------------ ------------- ----------
ADMINIST     db2taskd       10             *LOCAL.DB2.070904045330  JS              1
ADMINIST     db2stmm        9              *LOCAL.DB2.070904045329  JS              1
ADMINIST    javaw.exe       8              *LOCAL.DB2.070904045327  JS              1


在snapshot的第四段顯示應(yīng)用程序句柄為8的應(yīng)用有鎖存在，在其相應(yīng)的鎖定列表中顯示鎖定的表是US_CATALOG。
如果您確定是US_CATALOG表上發(fā)生了死鎖，可以通過(guò)命令db2 "force application(8)"來(lái)殺掉該應(yīng)用在數(shù)據(jù)庫(kù)上
的連接。注意如果force命令導(dǎo)致該應(yīng)用的事務(wù)回滾得話，force命令不能馬上斷開(kāi)應(yīng)用在數(shù)據(jù)庫(kù)上的連接，而是
要等到回滾完成后才能斷開(kāi)該應(yīng)用的數(shù)據(jù)庫(kù)連接。

C:\>db2 list applications show detail
//list applications for database cmsbj3 show detail


如果DB2在Window上，則可以使用“控制中心”->實(shí)例->右鍵“應(yīng)用程序”，可以看到當(dāng)前的鎖定情況，并且可以強(qiáng)行關(guān)閉某個(gè)進(jìn)程，也可以顯示“鎖定鏈”。

1.DB2表鎖定怎么解鎖

http://www.chinaunix.net/jh/22/20020.html

2.DB2中怎么知道表的鎖定情況：

http://www.chinaunix.net/jh/22/16766.html