- 论坛徽章:
- 1
|
db2 load是写在脚本中,删批量删除,然后批量导入,每日执行。之前一直没问题,昨天突然出现
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.
SQL2043N Unable to start a child process or thread.
数据库日志文件db2diag.log中的错误为
2015-03-17-01.04.35.998541+480 E139922890E475 LEVEL: Event
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START : DATABASE: APSDBBKE : ACTIVATED: NO
2015-03-17-01.04.40.181235+480 I139923366E480 LEVEL: Warning
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
DATA #1 : <preformatted>
Starting LOAD operation (S) (1) (I).
2015-03-17-01.04.40.626703+480 I139923847E504 LEVEL: Warning
PID : 10545 TID : 47865044920640PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20862 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 80 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
Load CPU parallelism is: 23, 0
2015-03-17-01.04.40.648628+480 I139924352E390 LEVEL: Severe
PID : 10545 TID : 47857574865216PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlo_waitlist::initialize, probe:10
MESSAGE : SysV semget failed with errno:
DATA #1 : Hexdump, 4 bytes
0x00002B86B5BFDD50 : 1C00 0000 ....
2015-03-17-01.04.40.648756+480 I139924743E392 LEVEL: Severe
PID : 10545 TID : 47857574865216PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloGetShrEDUWaitElem, probe:70
MESSAGE : waitlist initialization failed, zrc=
DATA #1 : Hexdump, 4 bytes
0x00002B86B5BFDE14 : 8100 0F85 ....
2015-03-17-01.04.40.656014+480 I139925136E336 LEVEL: Severe
PID : 10545 TID : 47857574865216PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUEntry, probe:10
DATA #1 : Hexdump, 4 bytes
0x00002B86B5BFE0F0 : 8100 0F85 ....
2015-03-17-01.04.40.656134+480 I139925473E547 LEVEL: Error
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 111 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
, -2029059854, (nil), Detected in file:sqluvld.C, Line:10608
2015-03-17-01.04.40.656319+480 I139926021E1020 LEVEL: Error
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, database utilities, sqlulInitOneEDU, probe:10613
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
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) ( (9) (10) (11)
sqlstate:
2015-03-17-01.04.40.656509+480 I139927042E547 LEVEL: Error
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 111 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
, -2146107283, (nil), Detected in file:sqluvld.C, Line:10841
2015-03-17-01.04.40.656664+480 I139927590E547 LEVEL: Error
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 111 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
, -2146107283, (nil), Detected in file:sqluvld.C, Line:10320
2015-03-17-01.04.40.656794+480 I139928138E546 LEVEL: Error
PID : 10545 TID : 47857717471552PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 19006 EDUNAME: db2agent (APSDBBKE) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 110 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
, -2146107283, (nil), Detected in file:sqluvld.C, Line:2575
2015-03-17-01.04.40.657079+480 I139928685E637 LEVEL: Error
PID : 10545 TID : 47865044920640PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20862 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.657382+480 I139929323E639 LEVEL: Error
PID : 10545 TID : 47865053309248PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20855 EDUNAME: db2lfrm17 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.657450+480 I139929963E638 LEVEL: Error
PID : 10545 TID : 47857587448128PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20846 EDUNAME: db2lfrm8 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.657805+480 I139930602E639 LEVEL: Error
PID : 10545 TID : 47865002977600PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20859 EDUNAME: db2lfrm21 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.657532+480 I139931242E639 LEVEL: Error
PID : 10545 TID : 47857524533568PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20857 EDUNAME: db2lfrm19 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.658534+480 I139931882E693 LEVEL: Error
PID : 10545 TID : 47857524533568PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20857 EDUNAME: db2lfrm19 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1895
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.658764+480 I139932576E576 LEVEL: Error
PID : 10545 TID : 47857524533568PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20857 EDUNAME: db2lfrm19 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1914
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.657341+480 I139933153E639 LEVEL: Error
PID : 10545 TID : 47865074280768PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20850 EDUNAME: db2lfrm12 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.659219+480 I139933793E693 LEVEL: Error
PID : 10545 TID : 47865074280768PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20850 EDUNAME: db2lfrm12 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1895
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.659466+480 I139934487E576 LEVEL: Error
PID : 10545 TID : 47865074280768PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20850 EDUNAME: db2lfrm12 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1914
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.659628+480 I139935064E582 LEVEL: Error
PID : 10545 TID : 47865074280768PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20850 EDUNAME: db2lfrm12 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1917
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.659775+480 I139935647E575 LEVEL: Error
PID : 10545 TID : 47865074280768PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20850 EDUNAME: db2lfrm12 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2666
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.657728+480 I139936223E639 LEVEL: Error
PID : 10545 TID : 47857679722816PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20852 EDUNAME: db2lfrm14 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.660163+480 I139936863E693 LEVEL: Error
PID : 10545 TID : 47857679722816PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20852 EDUNAME: db2lfrm14 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1895
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.660384+480 I139937557E576 LEVEL: Error
PID : 10545 TID : 47857679722816PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20852 EDUNAME: db2lfrm14 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1914
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.660539+480 I139938134E582 LEVEL: Error
PID : 10545 TID : 47857679722816PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20852 EDUNAME: db2lfrm14 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1917
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.660685+480 I139938717E575 LEVEL: Error
PID : 10545 TID : 47857679722816PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20852 EDUNAME: db2lfrm14 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2666
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.658826+480 I139939293E639 LEVEL: Error
PID : 10545 TID : 47865078475072PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20856 EDUNAME: db2lfrm18 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.657467+480 I139939933E639 LEVEL: Error
PID : 10545 TID : 47857566476608PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20849 EDUNAME: db2lfrm11 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.661275+480 I139940573E693 LEVEL: Error
PID : 10545 TID : 47857566476608PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20849 EDUNAME: db2lfrm11 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1895
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.661510+480 I139941267E576 LEVEL: Error
PID : 10545 TID : 47857566476608PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20849 EDUNAME: db2lfrm11 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1914
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.661683+480 I139941844E582 LEVEL: Error
PID : 10545 TID : 47857566476608PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20849 EDUNAME: db2lfrm11 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1917
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.657095+480 I139942427E638 LEVEL: Error
PID : 10545 TID : 47865040726336PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20844 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2659
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
2015-03-17-01.04.40.662125+480 I139943066E692 LEVEL: Error
PID : 10545 TID : 47865040726336PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20844 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1895
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.662357+480 I139943759E575 LEVEL: Error
PID : 10545 TID : 47865040726336PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20844 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1914
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.662533+480 I139944335E581 LEVEL: Error
PID : 10545 TID : 47865040726336PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20844 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1917
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.662681+480 I139944917E574 LEVEL: Error
PID : 10545 TID : 47865040726336PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000
EDUID : 20844 EDUNAME: db2lfrm6 0
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver, probe:2666
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluedus.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
2015-03-17-01.04.40.661092+480 I139945492E693 LEVEL: Error
PID : 10545 TID : 47865078475072PROC : db2sysc 0
INSTANCE: apsdbbke NODE : 000 DB : APSDBBKE
APPHDL : 0-15827 APPID: *LOCAL.apsdbbke.150316170431
AUTHID : APSDBBKE
EDUID : 20856 EDUNAME: db2lfrm18 0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp, probe:1895
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
LOADID: 19006.2015-03-17-01.04.40.181218.0 (6;14)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x82150056
数据版本为DB2/LINUXX8664 9.7.5,操作系统版本:rethat linux server 5.8 64位
还请大神们帮助找其出现问题的原因
数据库参数的UTIL_HEAP_SZ值为
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 195886 195886
|
|