Command: db2inst1@c01z0090:/db/dbdata01/R4_UAT/ARIW/R4/EXPORT_LOAD> db2 " Load from BHUSTG.BH_SEQUENCE_CONTROL of ixf INSERT into BHUSTG.BH_SEQUENCE_CONTROL
(GEO_CODE,FILE_NAME,LOAD_ID,IW_CURRENTDAY_PROCESS_START_TS,IW_CURRENTDAY_PROCESS_END_TS,IW_CURRENTDAY_PROCESS_DONE,IW_MONTHEND_PROCESS_START_TS,
IW_MONTHEND_PROCESS_END_TS,IW_MONTHEND_PROCESS_DONE,IW_DATAMART_LOAD_START_TS,IW_DATAMART_LOAD_END_TS,IW_DATAMART_LOAD_DONE,IW_MIDMONTH_PROCESS_START_TS,
IW_MIDMONTH_PROCESS_END_TS,IW_MIDMONTH_PROCESS_DONE,IW_ALL_DONE_TS,IW_ALL_DONE,SEQ_START_TS,SEQ_END_TS,SEQ_FLOW_REQD,STATUS) nonrecoverable"
运行一段时间后,db2diag.log 出现如下错误:
2012-12-28-11.23.54.413352+000 I7728421A475 LEVEL: Warning
PID : 28628 TID : 2204417124688PROC : db2sysc 0
INSTANCE: db9sr001 NODE : 000 DB : ARUATDB
APPHDL : 0-12109 APPID: *LOCAL.db9sr001.121228112158
AUTHID : DB2INST1
EDUID : 24940 EDUNAME: db2agent (ARUATDB) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:835
DATA #1 :
Starting LOAD operation (S) (3) (T).
2012-12-28-11.24.45.171994+000 I7728897A578 LEVEL: Error
PID : 28628 TID : 2204417124688PROC : db2sysc 0
INSTANCE: db9sr001 NODE : 000 DB : ARUATDB
APPHDL : 0-12109 APPID: *LOCAL.db9sr001.121228112158
AUTHID : DB2INST1
EDUID : 24940 EDUNAME: db2agent (ARUATDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 147 bytes
LOADID: 24940.2012-12-28-11.23.54.413334.0 (1486;4)
Failed to lock table and fix TCB , -2146435069, (nil), Detected in file:sqluTarget.C, Line:3025
2012-12-28-11.24.45.172264+000 I7729476A484 LEVEL: Severe
PID : 28628 TID : 2204417124688PROC : db2sysc 0
INSTANCE: db9sr001 NODE : 000 DB : ARUATDB
APPHDL : 0-12109 APPID: *LOCAL.db9sr001.121228112158
AUTHID : DB2INST1
EDUID : 24940 EDUNAME: db2agent (ARUATDB) 0
FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadRestart, probe:3644
MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
2012-12-28-11.24.45.172316+000 I7729961A456 LEVEL: Severe
PID : 28628 TID : 2204417124688PROC : db2sysc 0
INSTANCE: db9sr001 NODE : 000 DB : ARUATDB
APPHDL : 0-12109 APPID: *LOCAL.db9sr001.121228112158
AUTHID : DB2INST1
EDUID : 24940 EDUNAME: db2agent (ARUATDB) 0
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3568
MESSAGE : Load Error: Error loading table.
24940 2204417124688 31663 db2agent (ARUATDB)
0x0000000102F40080 12138 [000-12138] 1 24940 UOW-Waiting 0 0 0 0 9.78.206.193.32016.121228113735
db9sr001@c01z0090:/db/dbdata01/db9sr001/NODE0000/SQL00003/db2event/db2detaildeadlock> db2level
DB21085I Instance "db9sr001" uses "64" bits and DB2 code release "SQL09058"
with level identifier "06090107".
Informational tokens are "DB2 v9.5.0.8", "s110603", "IP23272", and Fix Pack
"8".
Product is installed at "/opt/IBM/db2/V9.5".
db9sr001@c01z0090:/db/dbdata01/db9sr001/NODE0000/SQL00003/db2event/db2detaildeadlock> db2pd -osinfo
Operating System Information:
OSName: Linux
NodeName: c01z0090
Version: 2
Release: 6
Machine: s390x
CPU Information:
TotalCPU OnlineCPU ConfigCPU Speed(MHz) HMTDegree Cores/Socket
10 10 10 0 1 n/a