凌晨有个脚本没执行成功INSERT INTO tab1 (...) (SELECT ... FROM ...)DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL...
显示全部凌晨有个脚本没执行成功INSERT INTO tab1 (...) (SELECT ... FROM ...)
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
INSERT INTO tab2 (...) (SELECT ... FROM ...)
DB20000I The SQL command completed successfully.
Fri Nov 30 01:01:51 BEIST 2012
锁超时日志....2012-11-30-01.01.34.668847+480 I1082562A463 LEVEL: Warning
PID : 2499052 TID : 1 PROC : db2agent (dbName) 0
INSTANCE: db2instt NODE : 000 DB :dbName
APPHDL : 0-2136 APPID: *LOCAL.db2instt.130125121148
AUTHID : DB2INSTT
FUNCTION: DB2 UDB, access plan manager, sqlra_find_pkg, probe:99
RETCODE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT
"LockTimeOut - tran rollback Reason code 68"
该时间点正在执行下面两条语句db2rbind dbName -l db2rbind.log all
Succeeded to rebind = 372
Failed to rebind = 4
Ending time .... Fri Nov 30 01:01:49 2012
FLUSH PACKAGE CACHE DYNAMIC
DB20000I The SQL command completed successfully.
Fri Nov 30 01:01:49 BEIST 2012
db2rbind 会占用锁,影响所有SQL吗?收起