db2 load 加载数据报错
昨天通过db2 load 加载数据报错,错误如下,后数据传输到数据库断加载正常,今天也正常了,不知道啥问题?
db2 load client FROM /etl_data/load/fail/error/20101102/A01013720101101001001.DAT OF DEL modified by coldel, insert into pods.t_ods_fin_custoweday7
Database Connection Information
Database server = DB2/AIX64 9.1.5
SQL authorization ID = ETL
Local database alias = BSSDB
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The TERMINATE command completed successfully.
Database Connection Information
Database server = DB2/AIX64 9.1.5
SQL authorization ID = ETL
Local database alias = BSSDB
Agent Type Node SQL Code Result
______________________________________________________________________________
LOAD 001 -00006555 Error. RESTART required.
______________________________________________________________________________
LOAD 002 -00006555 Error. RESTART required.
______________________________________________________________________________
LOAD 003 -00003005 Error. RESTART required.
______________________________________________________________________________
LOAD 004 -00003005 Error. RESTART required.
______________________________________________________________________________
LOAD 005 -00003005 Error. RESTART required.
______________________________________________________________________________
LOAD 006 -00003005 Error. RESTART required.
______________________________________________________________________________
LOAD 007 -00003005 Error. RESTART required.
______________________________________________________________________________
PARTITION 000 -00006555 Error.
______________________________________________________________________________
PRE_PARTITION 000 -00000980 Error.
______________________________________________________________________________
RESULTS: 0 of 7 LOADs completed successfully.
______________________________________________________________________________
Summary of Partitioning Agents:
Rows Read = 0
Rows Rejected = 0
Rows Partitioned = 0
Summary of LOAD Agents:
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
SQL0980C A disk error occurred. Subsequent SQL statements cannot be
processed. SQLSTATE=58005
db2diag日志较多,附件不让传了?
2010-11-02-09.07.29.642025+480 I458692273A446 LEVEL: Warning
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 96 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Pre-Partitioning Sub-agent is running. 0, 0
2010-11-02-09.07.29.643323+480 I458692720A494 LEVEL: Error
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 144 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
IO error in Pre-partitioning , -2045837307, 0, Detected in file:sqlusPrePartSA.C, Line:1222
2010-11-02-09.07.29.643505+480 I458693215A447 LEVEL: Warning
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 97 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Pre-Partitioning Sub-agent is finished. 0, 0
2010-11-02-09.07.29.643689+480 I458693663A414 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, global services, sqlzerdm, probe:40
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFF4638 : 860F 0005 ....
2010-11-02-09.07.29.672352+480 I458694078A408 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2010-11-02-09.07.29.674214+480 I458694487A163 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: QG SQLCA
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.674946+480 I458694651A164 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: QG DJDBCB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.675149+480 I458694816A163 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: QG DJACB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.675321+480 I458694980A165 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: QG APPDJCB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.675488+480 I458695146A166 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: QG TRANDJCB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.675656+480 I458695313A421 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2010-11-02-09.07.29.675933+480 I458695735A413 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:50
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2010-11-02-09.07.29.676245+480 I458696149A167 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: RDS AGENT CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.676509+480 I458696317A160 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLCA
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.676683+480 I458696478A166 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: RDS UCINTFC
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.676910+480 I458696645A170 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: APM COMMON INFO
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.677078+480 I458696816A166 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: CONTEXT MCB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.677250+480 I458696983A169 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: CONTEXT MEM CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.677420+480 I458697153A470 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
MESSAGE : * NOTE: NULL pentptr ... no pkgentry data
DATA #1 : Hexdump, 1 bytes
0x0900000003720B38 : 2A *
2010-11-02-09.07.29.677693+480 I458697624A381 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:450
DATA #1 : String, 19 bytes
XML components dump
2010-11-02-09.07.29.678210+480 I458698006A162 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: XMLC CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.678379+480 I458698169A169 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: XMLC POOL INFO
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.29.679851+480 I458698339A448 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:25
MESSAGE : Context info dumped! Check
/db2home/db2inst1/sqllib/db2dump/a1892924.000 for additional data.
2010-11-02-09.07.29.680354+480 I458698788A458 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:25
MESSAGE : Private workspace info dumped! Check
/db2home/db2inst1/sqllib/db2dump/a1892924.000 for additional data.
2010-11-02-09.07.29.680973+480 I458699247A457 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:25
MESSAGE : Shared workspace info dumped! Check
/db2home/db2inst1/sqllib/db2dump/a1892924.000 for additional data.
2010-11-02-09.07.30.081621+480 I458699705A456 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_full_dump, probe:25
MESSAGE : Package Cache info dumped! Check
/db2home/db2inst1/sqllib/db2dump/a1892924.000 for additional data.
2010-11-02-09.07.30.082310+480 I458700162A427 LEVEL: Severe
PID : 1892924 TID : 1 PROC : db2lpprt 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:300
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2010-11-02-09.07.30.082661+480 I458700590A167 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_AGENTCB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.082862+480 I458700758A175 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_AGENT_PRIVATECB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.083031+480 I458700934A164 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_DBCB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.083323+480 I458701099A167 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_TRAN_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.083492+480 I458701267A173 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_MASTER_APP_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.083661+480 I458701441A166 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_APP_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.083870+480 I458701608A174 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_COORDINATOR_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.084039+480 I458701783A169 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_APP_SA_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.084231+480 I458701953A171 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_TRAN_PDB_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.084399+480 I458702125A169 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: REPLY_NODE_MAP
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.084566+480 I458702295A172 LEVEL: Severe
PID:1892924 TID:1 NODE:000 Title: SQLE_APP_GROUP_CB
Dump File:/db2home/db2inst1/sqllib/db2dump/18929241.000
2010-11-02-09.07.30.087426+480 I458702468A488 LEVEL: Error
PID : 1663232 TID : 1 PROC : db2lpart 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 138 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Failed to read data , -2129330063, 0, Detected in file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.087701+480 I458702957A503 LEVEL: Error
PID : 1663232 TID : 1 PROC : db2lpart 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 153 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error detected when filling buffer , -2129330063, 0, Detected in file:sqlusBufferFormat.C, Line:3594
2010-11-02-09.07.30.096020+480 I458703461A337 LEVEL: Error
PID : 869158 TID : 1 PROC : db2lmr 1
INSTANCE: db2inst1 NODE : 001
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.098182+480 I458703799A310 LEVEL: Warning
PID : 869158 TID : 1 PROC : db2lmr 1
INSTANCE: db2inst1 NODE : 001
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.30.099888+480 I458704110A949 LEVEL: Error
PID : 2769888 TID : 1 PROC : db2lload 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqlulMRResponse, probe:6116
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 44 bytes
1126582.2010-11-02-09.07.27.939978.0 (4;183)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6555 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLUVLD
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000001
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2010-11-02-09.07.30.099422+480 I458705060A337 LEVEL: Error
PID : 1298446 TID : 1 PROC : db2lmr 2
INSTANCE: db2inst1 NODE : 002
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.116278+480 I458705398A310 LEVEL: Warning
PID : 1298446 TID : 1 PROC : db2lmr 2
INSTANCE: db2inst1 NODE : 002
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.30.123860+480 I458705709A949 LEVEL: Error
PID : 578166 TID : 1 PROC : db2lload 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqlulMRResponse, probe:6116
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 44 bytes
1126582.2010-11-02-09.07.27.939978.0 (4;183)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6555 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLUVLD
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000002
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2010-11-02-09.07.30.131279+480 I458706659A481 LEVEL: Error
PID : 1032332 TID : 1 PROC : db2lfrm0 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulpcr.C, Line:1047
2010-11-02-09.07.30.135637+480 I458707141A480 LEVEL: Error
PID : 1032332 TID : 1 PROC : db2lfrm0 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 109 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulpcr.C, Line:551
2010-11-02-09.07.30.138431+480 I458707622A481 LEVEL: Error
PID : 1032332 TID : 1 PROC : db2lfrm0 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3529
2010-11-02-09.07.30.142176+480 I458708104A481 LEVEL: Error
PID : 1032332 TID : 1 PROC : db2lfrm0 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.30.159646+480 I458708586A453 LEVEL: Severe
PID : 578166 TID : 1 PROC : db2lload 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.30.162799+480 I458709040A505 LEVEL: Error
PID : 578166 TID : 1 PROC : db2lload 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.30.165679+480 I458709546A400 LEVEL: Severe
PID : 578166 TID : 1 PROC : db2lload 2
INSTANCE: db2inst1 NODE : 002 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.30.240442+480 I458709947A457 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 78 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Interrupting all SAs 0, 0
2010-11-02-09.07.30.242346+480 I458710405A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 0, 0
2010-11-02-09.07.30.242590+480 I458710868A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 1, 0
2010-11-02-09.07.30.242854+480 I458711331A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 2, 0
2010-11-02-09.07.30.243093+480 I458711794A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 3, 0
2010-11-02-09.07.30.243327+480 I458712257A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 4, 0
2010-11-02-09.07.30.243561+480 I458712720A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 5, 0
2010-11-02-09.07.30.243798+480 I458713183A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 6, 0
2010-11-02-09.07.30.244033+480 I458713646A462 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Sending interrupt to node 7, 0
2010-11-02-09.07.30.106601+480 I458714109A503 LEVEL: Error
PID : 1913744 TID : 1 PROC : db2lfrm0 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 132 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluFlushBMData failed , -2112552874, 0, Detected in file:sqlulpcr.C, Line:2382
2010-11-02-09.07.30.465396+480 I458714613A481 LEVEL: Error
PID : 1913744 TID : 1 PROC : db2lfrm0 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3497
2010-11-02-09.07.30.466559+480 I458715095A481 LEVEL: Error
PID : 1913744 TID : 1 PROC : db2lfrm0 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.30.485679+480 I458715577A453 LEVEL: Severe
PID : 2769888 TID : 1 PROC : db2lload 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.30.486032+480 I458716031A505 LEVEL: Error
PID : 2769888 TID : 1 PROC : db2lload 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.30.486274+480 I458716537A400 LEVEL: Severe
PID : 2769888 TID : 1 PROC : db2lload 1
INSTANCE: db2inst1 NODE : 001 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.30.097735+480 I458716938A337 LEVEL: Error
PID : 1962470 TID : 1 PROC : db2lmr 7
INSTANCE: db2inst1 NODE : 007
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.524115+480 I458717276A310 LEVEL: Warning
PID : 1962470 TID : 1 PROC : db2lmr 7
INSTANCE: db2inst1 NODE : 007
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.30.527090+480 I458717587A454 LEVEL: Warning
PID : 1053316 TID : 1 PROC : db2lload 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
User interrupt. -2146107389, 0
2010-11-02-09.07.30.530366+480 I458718042A480 LEVEL: Error
PID : 1053316 TID : 1 PROC : db2lload 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 109 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2146107389, 0, Detected in file:sqluvld.C, Line:3897
2010-11-02-09.07.30.099422+480 I458718523A337 LEVEL: Error
PID : 188564 TID : 1 PROC : db2lmr 3
INSTANCE: db2inst1 NODE : 003
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.538685+480 I458718861A310 LEVEL: Warning
PID : 188564 TID : 1 PROC : db2lmr 3
INSTANCE: db2inst1 NODE : 003
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.30.541966+480 I458719172A454 LEVEL: Warning
PID : 832468 TID : 1 PROC : db2lload 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
User interrupt. -2146107389, 0
2010-11-02-09.07.30.546145+480 I458719627A480 LEVEL: Error
PID : 832468 TID : 1 PROC : db2lload 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 109 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2146107389, 0, Detected in file:sqluvld.C, Line:3897
2010-11-02-09.07.30.546026+480 I458720108A503 LEVEL: Error
PID : 1638716 TID : 1 PROC : db2lfrm0 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 132 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluFlushBMData failed , -2112552874, 0, Detected in file:sqlulpcr.C, Line:2382
2010-11-02-09.07.30.552672+480 I458720612A481 LEVEL: Error
PID : 1638716 TID : 1 PROC : db2lfrm0 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3497
2010-11-02-09.07.30.556595+480 I458721094A481 LEVEL: Error
PID : 1638716 TID : 1 PROC : db2lfrm0 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.30.100057+480 I458721576A337 LEVEL: Error
PID : 889324 TID : 1 PROC : db2lmr 5
INSTANCE: db2inst1 NODE : 005
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.567711+480 I458721914A310 LEVEL: Warning
PID : 889324 TID : 1 PROC : db2lmr 5
INSTANCE: db2inst1 NODE : 005
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.30.570980+480 I458722225A454 LEVEL: Warning
PID : 1753092 TID : 1 PROC : db2lload 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
User interrupt. -2146107389, 0
2010-11-02-09.07.30.574270+480 I458722680A480 LEVEL: Error
PID : 1753092 TID : 1 PROC : db2lload 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 109 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2146107389, 0, Detected in file:sqluvld.C, Line:3897
2010-11-02-09.07.30.573547+480 I458723161A453 LEVEL: Severe
PID : 1053316 TID : 1 PROC : db2lload 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.30.097643+480 I458723615A337 LEVEL: Error
PID : 368828 TID : 1 PROC : db2lmr 6
INSTANCE: db2inst1 NODE : 006
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.30.586211+480 I458723953A310 LEVEL: Warning
PID : 368828 TID : 1 PROC : db2lmr 6
INSTANCE: db2inst1 NODE : 006
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.30.588539+480 I458724264A503 LEVEL: Error
PID : 1929412 TID : 1 PROC : db2lfrm0 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 132 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluFlushBMData failed , -2112552874, 0, Detected in file:sqlulpcr.C, Line:2382
2010-11-02-09.07.30.594783+480 I458724768A481 LEVEL: Error
PID : 1929412 TID : 1 PROC : db2lfrm0 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3497
2010-11-02-09.07.30.598811+480 I458725250A481 LEVEL: Error
PID : 1929412 TID : 1 PROC : db2lfrm0 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.30.622251+480 I458725732A453 LEVEL: Severe
PID : 1753092 TID : 1 PROC : db2lload 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.30.625404+480 I458726186A505 LEVEL: Error
PID : 1753092 TID : 1 PROC : db2lload 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.30.628187+480 I458726692A400 LEVEL: Severe
PID : 1753092 TID : 1 PROC : db2lload 5
INSTANCE: db2inst1 NODE : 005 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.30.561389+480 I458727093A503 LEVEL: Error
PID : 910200 TID : 1 PROC : db2lfrm0 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 132 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluFlushBMData failed , -2112552874, 0, Detected in file:sqlulpcr.C, Line:2382
2010-11-02-09.07.30.968008+480 I458727597A481 LEVEL: Error
PID : 910200 TID : 1 PROC : db2lfrm0 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3497
2010-11-02-09.07.30.971535+480 I458728079A481 LEVEL: Error
PID : 910200 TID : 1 PROC : db2lfrm0 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.30.989887+480 I458728561A453 LEVEL: Severe
PID : 832468 TID : 1 PROC : db2lload 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.30.992742+480 I458729015A505 LEVEL: Error
PID : 832468 TID : 1 PROC : db2lload 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.30.995318+480 I458729521A400 LEVEL: Severe
PID : 832468 TID : 1 PROC : db2lload 3
INSTANCE: db2inst1 NODE : 003 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.30.100057+480 I458729922A337 LEVEL: Error
PID : 3977538 TID : 1 PROC : db2lmr 4
INSTANCE: db2inst1 NODE : 004
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Failed to read data , -2129330063, 0, Detected in
file:sqlusBufferFormat.C, Line:1499
2010-11-02-09.07.31.004788+480 I458730260A310 LEVEL: Warning
PID : 3977538 TID : 1 PROC : db2lmr 4
INSTANCE: db2inst1 NODE : 004
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1503
MESSAGE : Media controller -- problem reading from vendor device
2010-11-02-09.07.31.008153+480 I458730571A454 LEVEL: Warning
PID : 835952 TID : 1 PROC : db2lload 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
User interrupt. -2146107389, 0
2010-11-02-09.07.31.011541+480 I458731026A480 LEVEL: Error
PID : 835952 TID : 1 PROC : db2lload 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 109 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2146107389, 0, Detected in file:sqluvld.C, Line:3897
2010-11-02-09.07.30.588874+480 I458731507A454 LEVEL: Warning
PID : 1225292 TID : 1 PROC : db2lload 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 83 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
User interrupt. -2146107389, 0
2010-11-02-09.07.31.027347+480 I458731962A480 LEVEL: Error
PID : 1225292 TID : 1 PROC : db2lload 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 109 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2146107389, 0, Detected in file:sqluvld.C, Line:3897
2010-11-02-09.07.31.044374+480 I458732443A503 LEVEL: Error
PID : 1544942 TID : 1 PROC : db2lfrm0 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 132 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluFlushBMData failed , -2112552874, 0, Detected in file:sqlulpcr.C, Line:2382
2010-11-02-09.07.31.047867+480 I458732947A481 LEVEL: Error
PID : 1544942 TID : 1 PROC : db2lfrm0 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3497
2010-11-02-09.07.31.051426+480 I458733429A481 LEVEL: Error
PID : 1544942 TID : 1 PROC : db2lfrm0 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.30.582346+480 I458733911A505 LEVEL: Error
PID : 1053316 TID : 1 PROC : db2lload 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.31.060024+480 I458734417A400 LEVEL: Severe
PID : 1053316 TID : 1 PROC : db2lload 7
INSTANCE: db2inst1 NODE : 007 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.31.069577+480 I458734818A453 LEVEL: Severe
PID : 1225292 TID : 1 PROC : db2lload 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.31.072311+480 I458735272A505 LEVEL: Error
PID : 1225292 TID : 1 PROC : db2lload 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.31.075691+480 I458735778A400 LEVEL: Severe
PID : 1225292 TID : 1 PROC : db2lload 6
INSTANCE: db2inst1 NODE : 006 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.31.027137+480 I458736179A503 LEVEL: Error
PID : 2617362 TID : 1 PROC : db2lfrm0 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 132 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluFlushBMData failed , -2112552874, 0, Detected in file:sqlulpcr.C, Line:2382
2010-11-02-09.07.31.434376+480 I458736683A481 LEVEL: Error
PID : 2617362 TID : 1 PROC : db2lfrm0 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqlulini.C, Line:3497
2010-11-02-09.07.31.438031+480 I458737165A481 LEVEL: Error
PID : 2617362 TID : 1 PROC : db2lfrm0 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
, -2112552874, 0, Detected in file:sqluldat.C, Line:1257
2010-11-02-09.07.31.460277+480 I458737647A453 LEVEL: Severe
PID : 835952 TID : 1 PROC : db2lload 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1571
MESSAGE : Load Error: Load failed for table PODS .T_ODS_FIN_CUSTOWEDAY7 in
tablespace 4.
2010-11-02-09.07.31.463329+480 I458738101A505 LEVEL: Error
PID : 835952 TID : 1 PROC : db2lload 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 134 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Error loading partition. , -2146107283, 0, Detected in file:sqluvtld.C, Line:4353
2010-11-02-09.07.31.466212+480 I458738607A400 LEVEL: Severe
PID : 835952 TID : 1 PROC : db2lload 4
INSTANCE: db2inst1 NODE : 004 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4348
MESSAGE : Load Error: Error loading partition.
2010-11-02-09.07.31.766913+480 I458739008A531 LEVEL: Error
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 152 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
Failure reported by iFinalSyncUp , -2145779603, 0, Detected in file:sqlusMPPCoordinator.C, Line:991
2010-11-02-09.07.31.767383+480 I458739540A406 LEVEL: Warning
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:23
MESSAGE : SQLEU_FLAG1_FORCE_RBK is set, doing rollback
2010-11-02-09.07.31.783476+480 I458739947A492 LEVEL: Error
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 113 bytes
LOADID: 1126582.2010-11-02-09.07.27.939978.0 (4;183)
sqluv_rollback , 0, 3, Detected in file:sqluvutl.C, Line:925
2010-11-02-09.07.31.783770+480 I458740440A416 LEVEL: Severe
PID : 1126582 TID : 1 PROC : db2agent (BSSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : BSSDB
APPHDL : 0-546 APPID: 130.30.15.150.64407.10110201072
AUTHID : ETL
FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, probe:1053
MESSAGE : Load Error: Error loading partitions.