load加载数据失败
load insert表中数据时报如下错误:
Client destination file name: /interdata/newboss/07/P0706920120503000000.AVL
Action : INSERT INTO schema.USER_CHARG_HIS
Client message file name : /interdata/newmsg/0706920120504USER_HIS.msg
sqlcode:-902
db2diag日志信息如下:
2012-05-04-01.58.29.080802+480 I1007804861A577 LEVEL: Error
PID : 7334 TID : 51091410 PROC : db2sysc 3
INSTANCE: db2inst NODE : 003 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 51091410 EDUNAME: db2linit 3
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 161 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Failed to lock table and fix TCB , -2146434951, 0000000000000000, Detected in file:sqluTarget.C, Line:2966
2012-05-04-01.58.29.080739+480 I1007805439A532 LEVEL: Warning
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 115 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Init SA is running, (status = 1) (action = 5) (op = I). 0, 0
2012-05-04-01.58.29.081193+480 I1007805972A577 LEVEL: Error
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 161 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Failed to lock table and fix TCB , -2146434951, 0000000000000000, Detected in file:sqluTarget.C, Line:2966
2012-05-04-01.58.29.081318+480 I1007806550A467 LEVEL: Severe
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadStart, probe:2405
MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
2012-05-04-01.58.29.081405+480 I1007807018A441 LEVEL: Severe
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3550
MESSAGE : Load Error: Error loading table.
2012-05-04-01.58.29.081493+480 I1007807460A580 LEVEL: Error
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 164 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Failed to acquire loading resources , -2146434951, 0000000000000000, Detected in file:sqlusInitSA.C, Line:889
2012-05-04-01.58.29.081588+480 I1007808041A480 LEVEL: Severe
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, global services, sqlzerdm, probe:40
DATA #2 : Hexdump, 4 bytes
0x9FFFFFFF76BFE92C : 8010 0079 ...y
2012-05-04-01.58.29.083866+480 I1007808522A532 LEVEL: Warning
PID : 7332 TID : 9397073 PROC : db2sysc 1
INSTANCE: db2inst NODE : 001 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9397073 EDUNAME: db2linit 1
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 115 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Init SA is running, (status = 1) (action = 5) (op = I). 0, 0
2012-05-04-01.58.29.084196+480 I1007809055A577 LEVEL: Error
PID : 7332 TID : 9397073 PROC : db2sysc 1
INSTANCE: db2inst NODE : 001 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9397073 EDUNAME: db2linit 1
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 161 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Failed to lock table and fix TCB , -2146434951, 0000000000000000, Detected in file:sqluTarget.C, Line:2966
2012-05-04-01.58.29.084469+480 I1007809633A467 LEVEL: Severe
PID : 7332 TID : 9397073 PROC : db2sysc 1
INSTANCE: db2inst NODE : 001 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9397073 EDUNAME: db2linit 1
FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadStart, probe:2405
MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
2012-05-04-01.58.29.084560+480 I1007810101A441 LEVEL: Severe
PID : 7332 TID : 9397073 PROC : db2sysc 1
INSTANCE: db2inst NODE : 001 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9397073 EDUNAME: db2linit 1
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3550
MESSAGE : Load Error: Error loading table.
2012-05-04-01.58.29.084646+480 I1007810543A580 LEVEL: Error
PID : 7332 TID : 9397073 PROC : db2sysc 1
INSTANCE: db2inst NODE : 001 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9397073 EDUNAME: db2linit 1
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 164 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Failed to acquire loading resources , -2146434951, 0000000000000000, Detected in file:sqlusInitSA.C, Line:889
2012-05-04-01.58.29.084740+480 I1007811124A480 LEVEL: Severe
PID : 7332 TID : 9397073 PROC : db2sysc 1
INSTANCE: db2inst NODE : 001 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9397073 EDUNAME: db2linit 1
FUNCTION: DB2 UDB, global services, sqlzerdm, probe:40
DATA #2 : Hexdump, 4 bytes
0x9FFFFFFF5C3FE92C : 8010 0079 ...y
2012-05-04-01.58.29.080944+480 I1007811605A467 LEVEL: Severe
PID : 7334 TID : 51091410 PROC : db2sysc 3
INSTANCE: db2inst NODE : 003 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 51091410 EDUNAME: db2linit 3
FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadStart, probe:2405
MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
2012-05-04-01.58.29.425816+480 I1007812073A441 LEVEL: Severe
PID : 7334 TID : 51091410 PROC : db2sysc 3
INSTANCE: db2inst NODE : 003 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 51091410 EDUNAME: db2linit 3
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3550
MESSAGE : Load Error: Error loading table.
2012-05-04-01.58.29.425936+480 I1007812515A580 LEVEL: Error
PID : 7334 TID : 51091410 PROC : db2sysc 3
INSTANCE: db2inst NODE : 003 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 51091410 EDUNAME: db2linit 3
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 164 bytes
LOADID: 40269550.2012-05-04-01.58.29.044674.0 (42;599)
Failed to acquire loading resources , -2146434951, 0000000000000000, Detected in file:sqlusInitSA.C, Line:889
2012-05-04-01.58.29.426095+480 I1007813096A480 LEVEL: Severe
PID : 7334 TID : 51091410 PROC : db2sysc 3
INSTANCE: db2inst NODE : 003 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 51091410 EDUNAME: db2linit 3
FUNCTION: DB2 UDB, global services, sqlzerdm, probe:40
DATA #2 : Hexdump, 4 bytes
0x9FFFFFFEF7FFE92C : 8010 0079 ...y
2012-05-04-01.58.31.282390+480 I1007813577A474 LEVEL: Severe
PID : 7333 TID : 9468216 PROC : db2sysc 2
INSTANCE: db2inst NODE : 002 DB : db2inst1
APPHDL : 0-55478 APPID: *N0.db2inst.120508114853
AUTHID : IPD
EDUID : 9468216 EDUNAME: db2linit 2
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-05-04-01.58.31.282820+480 I1007814052A166 LEVEL: Severe
PID:7333 TID:9468216 NODE:002 Title: QG SQLCA
Dump File:/db2diaglog/db2dump/7333.9468216.002.dump.bin
2012-05-04-01.58.31.284249+480 I1007814219A167 LEVEL: Severe
PID:7333 TID:9468216 NODE:002 Title: QG DJDBCB
Dump File:/db2diaglog/db2dump/7333.9468216.002.dump.bin
2012-05-04-01.58.31.284382+480 I1007814387A166 LEVEL: Severe
PID:7333 TID:9468216 NODE:002 Title: QG DJACB
Dump File:/db2diaglog/db2dump/7333.9468216.002.dump.bin
2012-05-04-01.58.31.284487+480 I1007814554A169 LEVEL: Severe
PID:7333 TID:9468216 NODE:002 Title: QG TRANDJCB
Dump File:/db2diaglog/db2dump/7333.9468216.002.dump.bin
这个是什么问题呢