窗口1[db2inst1@p78005lpar1/home/db2inst1]db2 "select * from daolin"COL1 ----------- 1 2 2 record(s) selected.[db2inst1@p78005lpar1/home...
显示全部窗口1
[db2inst1@p78005lpar1/home/db2inst1]db2 "select * from daolin"
COL1
-----------
1
2
2 record(s) selected.
[db2inst1@p78005lpar1/home/db2inst1]
[db2inst1@p78005lpar1/home/db2inst1]
[db2inst1@p78005lpar1/home/db2inst1]
[db2inst1@p78005lpar1/home/db2inst1]db2 +c "delete from daolin where col1=2"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]
窗口2
[db2inst1@p78005lpar1/home/db2inst1/work]
[db2inst1@p78005lpar1/home/db2inst1/work]db2 "update daolin set col1=200 where col1=2"
窗口3
[db2inst1@p78005lpar1/home/db2inst1]db2pd -d cbodp20 -locks show details
Invalid suboption details
Invalid suboption details
Database Member 0 -- Database CBODP20 -- Active -- Up 11 days 15:07:57 -- Date 2015-08-10-20.22.17.551672
Locks:
Address TranHdl Lockname Type Mode Sts Owner Dur HoldCount Att ReleaseFlg rrIID TableNm SchemaNm
0x0A00030002CA6700 226 00041219000000000000000552 RowLock ..X G 226 1 0 0x00200020 0x40000000 0 DAOLIN DB2INST1 00041219000000000000000552 SQLP_RECORD (obj={4;4633}, rid=d(0;0;5), x0000000000000005)
0x0A00030001FC6E00 190 00041219000000000000000552 RowLock ..U W 226 0 0 0x00000000 0x00000000 0 DAOLIN DB2INST1 00041219000000000000000552 SQLP_RECORD (obj={4;4633}, rid=d(0;0;5), x0000000000000005)
0x0A00030001FCF980 190 000000040000000100012BC0D6 VarLock ..S G 190 1 0 0x00000000 0x40000000 0 N/A N/A 000000040000000100012BC0D6 SQLP_VARIATION (anchor,stmt,env,var={350,4,1,1}, loading = 0, )
0x0A00030002CA4A80 226 414141414166416415C78BFEC1 PlanLock ..S G 226 1 0 0x00000000 0x40000000 0 N/A N/A 414141414166416415C78BFEC1 SQLP_PLAN ({41414141 41664164 15C78BFE}, loading=0)
0x0A00030001FC7680 190 414141414166416415C78BFEC1 PlanLock ..S G 190 1 0 0x00000000 0x40000000 0 N/A N/A 414141414166416415C78BFEC1 SQLP_PLAN ({41414141 41664164 15C78BFE}, loading=0)
0x0A00030002C93E00 226 00041219000000000000000054 TableLock .IX G 226 1 0 0x00203000 0x40000000 0 DAOLIN DB2INST1 00041219000000000000000054 SQLP_TABLE (obj={4;4633})
0x0A00030001FBDF00 190 00041219000000000000000054 TableLock .IX G 190 1 0 0x00202000 0x40000000 0 DAOLIN DB2INST1 00041219000000000000000054 SQLP_TABLE (obj={4;4633})
[db2inst1@p78005lpar1/home/db2inst1]
[db2inst1@p78005lpar1/home/db2inst1]
[db2inst1@p78005lpar1/home/db2inst1]db2 "select rid() ,col1 from daolin"
1 COL1
-------------------- -----------
4 1
5 2
可以用db2pd 来看锁的相关信息。更便捷。
建议楼主买本徐明伟老师的书先看看。《DB2数据库最佳管理实践》
收起