求救
asianux linux系统,db2 9.7 ,load本地文件报错,原来都用得很稳定的,后来会经常出现这个错误,不知什么原因。中间加过内存,改过设置update dbm cfg using Federated YES。日志如下:
load client from /tmp/tmpdata/ODS/CORE_BGFMFDTL_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,30,31,32,33,34,35,36,37,38,39,40) REPLACE INTO TMP_CORE.BGFMFDTL(FDCAAC20,FDCADATE,FDCARETY,FDCAIBAL,FDCATXSN,FDCBTXSN,FDCANO11,FDCASN10,FDCASN02,FDCABLTP,FDCABLNO,FDCBAC20,FDCBDATE,FDCCDATE,FDCAINVT,FDCARDBL,FDCACDFG,FDCACCYC,FDCAAMT,FDCBCDFG,FDCABAL,FDCABRNO,FDCBBRNO,FDCCBRNO,FDCAEXRT,FDCATIME,FDCARMRK,FDCASTAF,FDCBSTAF,FDCCSTAF,FDCAMAGN,FDCACN15,FDCZDATE,FDCBRMRK,FDCARS1B,FDCDDATE,FDCDSTAF,FDCESTAF,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.
SQL3109N The utility is beginning to load data from file
"/tmp/tmpdata/ODS/CORE_BGFMFDTL_20130508_ALL_853.del".
SQL3500W The utility is beginning the "LOAD" phase at time "07/05/2013
16:04:16.606568".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL6555N The load utility encountered an unexpected communications error.
db2diag.log如下
2013-07-05-16.01.46.901276+480 I2E472 LEVEL: Warning
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38446 APPID: *LOCAL.db2inst1.130705130441
AUTHID : SJFF
EDUID : 2246 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-16.01.47.494128+480 I475E500 LEVEL: Warning
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38446 APPID: *LOCAL.db2inst1.130705130441
AUTHID : SJFF
EDUID : 2407 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 2246.2013-07-05-16.01.46.901257.0 (5;1603)
Load CPU parallelism is: 7, 0
2013-07-05-16.01.47.501138+480 I976E559 LEVEL: Warning
PID : 5764 TID : 47423812528448PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38446 APPID: *LOCAL.db2inst1.130705130441
AUTHID : SJFF
EDUID : 2399 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 127 bytes
LOADID: 2246.2013-07-05-16.01.46.901257.0 (5;1603)
Starting LOAD phase at 07/05/2013 16:01:47.500983. Table TMP_CORE.BQFMARII
2013-07-05-16.01.55.054823+480 I1536E535 LEVEL: Warning
PID : 5764 TID : 47423724448064PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38446 APPID: *LOCAL.db2inst1.130705130441
AUTHID : SJFF
EDUID : 2407 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 104 bytes
LOADID: 2246.2013-07-05-16.01.46.901257.0 (5;1603)
Completed LOAD phase at 07/05/2013 16:01:55.054759.
2013-07-05-16.02.56.985698+480 I2072E472 LEVEL: Warning
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38576 APPID: *LOCAL.db2inst1.130705130651
AUTHID : SJFF
EDUID : 2246 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-16.02.58.203368+480 I2545E500 LEVEL: Warning
PID : 5764 TID : 47423732836672PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38576 APPID: *LOCAL.db2inst1.130705130651
AUTHID : SJFF
EDUID : 2417 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 2246.2013-07-05-16.02.56.985681.0 (7;1221)
Load CPU parallelism is: 7, 0
2013-07-05-16.02.58.209294+480 I3046E559 LEVEL: Warning
PID : 5764 TID : 47423812528448PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38576 APPID: *LOCAL.db2inst1.130705130651
AUTHID : SJFF
EDUID : 2409 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 127 bytes
LOADID: 2246.2013-07-05-16.02.56.985681.0 (7;1221)
Starting LOAD phase at 07/05/2013 16:02:58.209151. Table TMP_CORE.BGFMTBLE
2013-07-05-16.02.59.152342+480 I3606E442 LEVEL: Severe
PID : 5764 TID : 47400857102656PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 14 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:50
RETCODE : ZRC=0x850F0081=-2062614399=SQLO_SSEM_EXCEED_MAX
"Requesting too many semaphores"
DIA8336C Requested too many semaphores.
2013-07-05-16.02.59.158365+480 I4049E525 LEVEL: Severe
PID : 5764 TID : 47400857102656PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 14 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : IPC Semaphore Set ID
DATA #1 : Hexdump, 24 bytes
0x00002B1C5F3FDD6C : 0000 0000 0000 0000 FFFF FFFF FFFF FFFF ................
0x00002B1C5F3FDD7C : 0000 0000 0000 0000 ........
2013-07-05-16.02.59.165665+480 I4575E1268 LEVEL: Severe
PID : 31189 TID : 47794841162928PROC : MClmAgt
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 11 bytes
CCI Error:
DATA #2 : unsigned integer, 8 bytes
81
CALLSTCK:
[0] 0x00002B781766C93C pdLog + 0x144
[1] 0x00002B7817D7217D _Z16sqljcLogCCIErrorP10sqljCmnMgrPKcP12SQLCC_COND_Thllll + 0x161
[2] 0x00002B7817D6E88B _Z16sqljcCommConnectP10sqljCmnMgr + 0x175
[3] 0x00002B78176D9862 _Z15sqljcCmnMgrInitP10sqljCmnMgrP17SQLCC_COMHANDLE_TPhmP14db2UCconHandleh + 0x4C8
[4] 0x00002B7817D9945D _Z20sqljrCreateTransportP14db2UCconHandle + 0xBD
[5] 0x00002B78176DBDB2 _Z23sqljrAssociateTransportP14db2UCconHandlePlbP19SQLE_SRVLST_DBENTRYPi + 0x74
[6] 0x00002B7817D99865 _Z20sqljrInternalConnectP14db2UCconHandlePbPib + 0x3CD
[7] 0x00002B7817D9B4C2 _Z30sqljrFindBestAddressAndConnectP14db2UCconHandle + 0x5C
[8] 0x00002B7817D972A6 _Z23sqljrDrdaArAuthenticateP14db2UCinterfacelPj + 0x6A2
[9] 0x00002B7817C75D48 _Z20sqlexAppAuthenticateP14db2UCinterface + 0x598
2013-07-05-16.03.01.001563+480 I5844E535 LEVEL: Warning
PID : 5764 TID : 47423732836672PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38576 APPID: *LOCAL.db2inst1.130705130651
AUTHID : SJFF
EDUID : 2417 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 104 bytes
LOADID: 2246.2013-07-05-16.02.56.985681.0 (7;1221)
Completed LOAD phase at 07/05/2013 16:03:01.001493.
2013-07-05-16.03.35.578500+480 I6380E472 LEVEL: Warning
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38655 APPID: *LOCAL.db2inst1.130705130810
AUTHID : SJFF
EDUID : 2246 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-16.03.36.531520+480 I6853E500 LEVEL: Warning
PID : 5764 TID : 47423820917056PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38655 APPID: *LOCAL.db2inst1.130705130810
AUTHID : SJFF
EDUID : 2429 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 2246.2013-07-05-16.03.35.578483.0 (7;1215)
Load CPU parallelism is: 7, 0
2013-07-05-16.03.36.537580+480 I7354E559 LEVEL: Warning
PID : 5764 TID : 47423791556928PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38655 APPID: *LOCAL.db2inst1.130705130810
AUTHID : SJFF
EDUID : 2421 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 127 bytes
LOADID: 2246.2013-07-05-16.03.35.578483.0 (7;1215)
Starting LOAD phase at 07/05/2013 16:03:36.537420. Table TMP_CORE.BGFMKMT1
2013-07-05-16.03.39.276411+480 I7914E535 LEVEL: Warning
PID : 5764 TID : 47423820917056PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38655 APPID: *LOCAL.db2inst1.130705130810
AUTHID : SJFF
EDUID : 2429 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 104 bytes
LOADID: 2246.2013-07-05-16.03.35.578483.0 (7;1215)
Completed LOAD phase at 07/05/2013 16:03:39.276340.
2013-07-05-16.04.15.567129+480 I8450E472 LEVEL: Warning
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 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-16.04.16.600349+480 I8923E500 LEVEL: Warning
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2441 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Load CPU parallelism is: 7, 0
2013-07-05-16.04.16.606717+480 I9424E559 LEVEL: Warning
PID : 5764 TID : 47423720253760PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2433 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 127 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Starting LOAD phase at 07/05/2013 16:04:16.606568. Table TMP_CORE.BGFMFDTL
2013-07-05-16.04.17.428414+480 E9984E786 LEVEL: Error (OS)
PID : 5764 TID : 47423766391104PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2436 EDUNAME: db2lfrm3 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b21b4bfce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.428430+480 E10771E786 LEVEL: Error (OS)
PID : 5764 TID : 47423720253760PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2433 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b21b1ffce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.428469+480 E11558E786 LEVEL: Error (OS)
PID : 5764 TID : 47400806771008PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2435 EDUNAME: db2lfrm2 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b1c5c3fce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.428455+480 E12345E786 LEVEL: Error (OS)
PID : 5764 TID : 47423791556928PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2437 EDUNAME: db2lfrm4 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b21b63fce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.428429+480 E13132E786 LEVEL: Error (OS)
PID : 5764 TID : 47423820917056PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2438 EDUNAME: db2lfrm5 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b21b7ffce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.428416+480 E13919E786 LEVEL: Error (OS)
PID : 5764 TID : 47423699282240PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2434 EDUNAME: db2lfrm1 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b21b0bfce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.428415+480 E14706E786 LEVEL: Error (OS)
PID : 5764 TID : 47423749613888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2439 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40
MESSAGE : ZRC=0x870F0041=-2029060031=SQLO_QUE_NOT_SENT "Message Not Sent"
DIA8557C No message was sent using the message queue.
CALLED : OS, -, write OSERR: EAGAIN (11)
DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes
0x0F99804A
DATA #2 : Pointer, 8 bytes
0x00002b21b3bfce78
DATA #3 : unsigned integer, 8 bytes
48
2013-07-05-16.04.17.611992+480 I15493E536 LEVEL: Error
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2441 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 116 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Unexpect msg! , 46, (nil), Detected in file:sqlulrid.C, Line:1672
2013-07-05-16.04.17.612240+480 I16030E536 LEVEL: Error
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2441 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 116 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Msg details , 2441, 0x6b0, Detected in file:sqlulrid.C, Line:1675
2013-07-05-16.04.17.612392+480 I16567E175 LEVEL: Severe
PID:5764 TID:47423816722752 NODE:000 Title: msg
Dump File:/home/db2inst1/sqllib/db2dump/5764.2441.000.dump.bin
2013-07-05-16.04.17.612580+480 I16743E527 LEVEL: Warning
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2441 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 106 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Sender of unexpected msg was EDU with ID/TYPE: 2441, 12
2013-07-05-16.04.17.612725+480 I17271E531 LEVEL: Error
PID : 5764 TID : 47423816722752PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2441 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 111 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
, -2129330063, (nil), Detected in file:sqlulrid.C, Line:923
2013-07-05-16.04.17.612988+480 I17803E455 LEVEL: Warning
PID : 5764 TID : 47423791556928PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2437 EDUNAME: db2lfrm4 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 4.
2013-07-05-16.04.17.613000+480 I18259E455 LEVEL: Warning
PID : 5764 TID : 47423820917056PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2438 EDUNAME: db2lfrm5 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 5.
2013-07-05-16.04.17.613000+480 I18715E455 LEVEL: Warning
PID : 5764 TID : 47423749613888PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2439 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 6.
2013-07-05-16.04.17.612988+480 I19171E455 LEVEL: Warning
PID : 5764 TID : 47423699282240PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2434 EDUNAME: db2lfrm1 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 1.
2013-07-05-16.04.17.612988+480 I19627E455 LEVEL: Warning
PID : 5764 TID : 47400806771008PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2435 EDUNAME: db2lfrm2 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 2.
2013-07-05-16.04.17.613000+480 I20083E455 LEVEL: Warning
PID : 5764 TID : 47423766391104PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2436 EDUNAME: db2lfrm3 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 3.
2013-07-05-16.04.17.613000+480 I20539E455 LEVEL: Warning
PID : 5764 TID : 47423720253760PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2433 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords, probe:3285
MESSAGE : Interrupt received in formatter 0.
2013-07-05-16.04.19.145994+480 I20995E486 LEVEL: Severe
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, call_sqluvload, probe:1634
MESSAGE : Load Error: Load failed for table TMP_CORE.BGFMFDTL in tablespace 7.
2013-07-05-16.04.19.146174+480 I21482E564 LEVEL: Error
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 136 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Error loading partition. , -2146107283, (nil), Detected in file:sqluvtld.C, Line:4061
2013-07-05-16.04.19.146308+480 I22047E457 LEVEL: Severe
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:4056
MESSAGE : Load Error: Error loading partition.
2013-07-05-16.04.19.146421+480 I22505E564 LEVEL: Error
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 136 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
Error loading partition. , -2146107283, (nil), Detected in file:sqluvtld.C, Line:1127
2013-07-05-16.04.19.146558+480 I23070E456 LEVEL: Warning
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:100
MESSAGE : SQLEU_FLAG1_FORCE_RBK is set, doing rollback
2013-07-05-16.04.19.169555+480 I23527E541 LEVEL: Error
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 113 bytes
LOADID: 2246.2013-07-05-16.04.15.567113.0 (7;1212)
sqluv_rollback , 0, 0x3, Detected in file:sqluvutl.C, Line:937
2013-07-05-16.04.19.169705+480 I24069E464 LEVEL: Severe
PID : 5764 TID : 47423770585408PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DCDB
APPHDL : 0-38730 APPID: *LOCAL.db2inst1.130705130925
AUTHID : SJFF
EDUID : 2246 EDUNAME: db2agent (DCDB) 0
FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, probe:1123
MESSAGE : Load Error: Error loading partition.
收起