求救
asianux linux系统,db2 9.7 ,load本地文件报错,原来都用得很稳定的,后来会经常出现这个错误,不知什么原因。
中间加过内存,改过设置update dbm cfg using Federated YES。
第一次报SQL6555N The load utility encountered an unexpected communications error.
重试几次,变成了SQL2043N
日志如下:
load client from /tmp/tmpdata/ODS/CORE_BDFMHQCC_20130508_ALL_853.del OF DEL MODIFIED BY delprioritychar method p(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29) REPLACE INTO TMP_CORE.BDFMHQCC(CC01AC22,CC02CCYC,CC03CHSX,CC05CSNO,CC06ACID,CC07ACID,CC11DATE,CC12DATE,CC08ACST,CC10NO10,CC16BAL,CC25WBXZ,CC26CMBL,CC34BOOL,CC13DATE,CC33DATE,CC27DATE,CC28DATE,CC29BRNO,CC30BRNO,CC31BRNO,RCSTRS1B,BUOPDATE,BUDISTAM,BUTSSTAF,UPDTSTAM,UPTSSTAF,etl_dt,etl_flag)
SQL3501W The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.
SQL2043N Unable to start a child process or thread.
db2diag.log如下
2013-07-05-17.44.11.343582+480 I2E581 LEVEL: Warning
PID : 5764 TID : 47423766391104PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50093 APPID: *LOCAL.db2inst1.130705161848
AUTHID : SJFF
EDUID : 2834 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSortDbMonitorIfNecessary, probe:1583
MESSAGE : STMM Sort Memory Tuning cannot be activated because the Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.
2013-07-05-17.44.12.680860+480 I584E472 LEVEL: Warning
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50146 APPID: *LOCAL.db2inst1.130705161941
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:840
DATA #1 :
Starting LOAD operation (S) (1) (R).
2013-07-05-17.44.13.674466+480 I1057E500 LEVEL: Warning
PID : 5764 TID : 47400613833024PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50146 APPID: *LOCAL.db2inst1.130705161941
AUTHID : SJFF
EDUID : 3100 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 3091.2013-07-05-17.44.12.680845.0 (7;1199)
Load CPU parallelism is: 7, 0
2013-07-05-17.44.14.140279+480 I1558E559 LEVEL: Warning
PID : 5764 TID : 47423711865152PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50146 APPID: *LOCAL.db2inst1.130705161941
AUTHID : SJFF
EDUID : 3092 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 127 bytes
LOADID: 3091.2013-07-05-17.44.12.680845.0 (7;1199)
Starting LOAD phase at 07/05/2013 17:44:14.140124. Table TMP_CORE.BDFTHQTA
2013-07-05-17.44.18.441102+480 I2118E535 LEVEL: Warning
PID : 5764 TID : 47400613833024PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50146 APPID: *LOCAL.db2inst1.130705161941
AUTHID : SJFF
EDUID : 3100 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 104 bytes
LOADID: 3091.2013-07-05-17.44.12.680845.0 (7;1199)
Completed LOAD phase at 07/05/2013 17:44:18.441036.
2013-07-05-17.44.43.404079+480 I2654E472 LEVEL: Warning
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:840
DATA #1 :
Starting LOAD operation (S) (1) (R).
2013-07-05-17.44.44.508048+480 I3127E500 LEVEL: Warning
PID : 5764 TID : 47423812528448PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3116 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
Load CPU parallelism is: 7, 0
2013-07-05-17.44.44.508833+480 I3628E390 LEVEL: Severe
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlo_waitlist::initialize, probe:10
MESSAGE : SysV semget failed with errno:
DATA #1 : Hexdump, 4 bytes
0x00002B21B7BFDD50 : 1C00 0000 ....
2013-07-05-17.44.44.508940+480 I4019E392 LEVEL: Severe
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloGetShrEDUWaitElem, probe:70
MESSAGE : waitlist initialization failed, zrc=
DATA #1 : Hexdump, 4 bytes
0x00002B21B7BFDE14 : 8100 0F85 ....
2013-07-05-17.44.44.509044+480 I4412E336 LEVEL: Severe
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUEntry, probe:10
DATA #1 : Hexdump, 4 bytes
0x00002B21B7BFE0EC : 8100 0F85 ....
2013-07-05-17.44.44.509226+480 I4749E540 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 112 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
, -2029059854, (nil), Detected in file:sqluvld.C, Line:10558
2013-07-05-17.44.44.509373+480 I5290E1013 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqlulInitOneEDU, probe:10563
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 50 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2043 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLUVLD
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2013-07-05-17.44.44.509545+480 I6304E540 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 112 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
, -2146107283, (nil), Detected in file:sqluvld.C, Line:10803
2013-07-05-17.44.44.509678+480 I6845E540 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 112 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
, -2146107283, (nil), Detected in file:sqluvld.C, Line:10312
2013-07-05-17.44.44.509798+480 I7386E539 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 111 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
, -2146107283, (nil), Detected in file:sqluvld.C, Line:2567
2013-07-05-17.44.44.651471+480 I7926E564 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 136 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
Error loading partition. , -2146107283, (nil), Detected in file:sqluvtld.C, Line:4061
2013-07-05-17.44.44.651732+480 I8491E457 LEVEL: Severe
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4056
MESSAGE : Load Error: Error loading partition.
2013-07-05-17.44.44.651852+480 I8949E564 LEVEL: Error
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 136 bytes
LOADID: 3091.2013-07-05-17.44.43.404063.0 (7;1191)
Error loading partition. , -2146107283, (nil), Detected in file:sqluvtld.C, Line:1127
2013-07-05-17.44.44.738324+480 I9514E464 LEVEL: Severe
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-50202 APPID: *LOCAL.db2inst1.130705162037
AUTHID : SJFF
EDUID : 3091 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, probe:1123
MESSAGE : Load Error: Error loading partition.
收起