增加字段,提示
db2 => ALTER TABLE SD_TERM_KEY ADD COLUMN LMK_TDK VARCHAR(64) DEFAULT NULL
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
锁信息如下:
select * from SYSIBMADM.LOCKS_HELD lh where lh.tabname='SD_TERM_KEY';
2014-12-26 14:25:02.702434 PAYMENT 53046 db2jcc_application DB2INST1 USERSPACE1 DB2INST1 SD_TERM_KEY 786 TABLE_LOCK 0x02001203000000000000000054 IX GRNT 0 0
2014-12-26 14:25:02.702434 PAYMENT 53059 db2jcc_application DB2INST1 USERSPACE1 DB2INST1 SD_TERM_KEY 786 TABLE_LOCK 0x02001203000000000000000054 IX GRNT 0 0
2014-12-26 14:25:02.702434 PAYMENT 53105 db2jcc_application DB2INST1 USERSPACE1 DB2INST1 SD_TERM_KEY 786 TABLE_LOCK 0x02001203000000000000000054 IX GRNT 0 0
不能force 进程,一旦force,会导致应用连接不上库,只能重新启动应用才行。
[db2inst1@DBserverA ~]$ db2pd -d payment -wlocks
Database Partition 4294967295 -- Database PAYMENT -- Active -- Up 106 days 11:12:31 -- Date 2014-12-26-13.13.02.170270
Locks being waited on :
AppHandl [nod-index] TranHdl Lockname Type Mode Conv Sts CoorEDU AppName AuthID AppID
53098 [000-53098] 79 02001203000000000000000054 Table .IX G 5096 db2jcc_a DB2INST1 10.2.2.30.44701.141217122644
53104 [000-53104] 91 02001203000000000000000054 Table .IX G 4926 db2jcc_a DB2INST1 10.2.2.30.44709.141217122652
53055 [000-53055] 83 02001203000000000000000054 Table .IX G 4932 db2jcc_a DB2INST1 10.2.2.40.37455.141217121247
53105 [000-53105] 78 02001203000000000000000054 Table .IX G 5016 db2jcc_a DB2INST1 10.2.2.30.44707.141217122650
53054 [000-53054] 87 02001203000000000000000054 Table .IX G 4924 db2jcc_a DB2INST1 10.2.2.40.37452.141217121244
53052 [000-53052] 99 02001203000000000000000054 Table .IX G 4933 db2jcc_a DB2INST1 10.2.2.40.37453.141217121245
53049 [000-53049] 93 02001203000000000000000054 Table .IX G 4922 db2jcc_a DB2INST1 10.2.2.40.37448.141217121240
53103 [000-53103] 97 02001203000000000000000054 Table .IX G 5000 db2jcc_a DB2INST1 10.2.2.30.44708.141217122651
53101 [000-53101] 103 02001203000000000000000054 Table .IX G 4998 db2jcc_a DB2INST1 10.2.2.30.44705.141217122648
53100 [000-53100] 80 02001203000000000000000054 Table .IX G 4931 db2jcc_a DB2INST1 10.2.2.30.44703.141217122646
53046 [000-53046] 98 02001203000000000000000054 Table .IX G 4948 db2jcc_a DB2INST1 10.2.2.40.37449.141217121241
53059 [000-53059] 77 02001203000000000000000054 Table .IX G 4910 db2jcc_a DB2INST1 10.2.2.40.37457.141217121249
53099 [000-53099] 101 02001203000000000000000054 Table .IX G 4699 db2jcc_a DB2INST1 10.2.2.30.44702.141217122645
53050 [000-53050] 96 02001203000000000000000054 Table .IX G 4934 db2jcc_a DB2INST1 10.2.2.40.37450.141217121242
53097 [000-53097] 92 02001203000000000000000054 Table .IX G 4942 db2jcc_a DB2INST1 10.2.2.30.44704.141217122647
53093 [000-53093] 106 02001203000000000000000054 Table .IX G 5122 db2jcc_a DB2INST1 10.2.2.30.44700.141217122643
10896 [000-10896] 108 02001203000000000000000054 Table .IN ..Z C 5194 db2bp DB2INST1 *LOCAL.db2inst1.141226030422
如何处理,才能增加字段……本人基础知识较差,见谅。
收起