使用 "db2 connect 数据库名" 连接数据库时,出现以下问题:
----------------------------------------------------------------
SQL1042C 发生了意外的系统错误。 SQLSTATE=58004
请大家帮忙看看。
具体环境:hp-unix双机热备,db2 9.1数据库
下面是报错的日志:
2010-02-24-08.57.23.647043+480 I1598969710A1633 LEVEL: Event
PID : 4761 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x9FFFFFFFFFFFBBB0 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x9FFFFFFFFFFFBBC0 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x9FFFFFFFFFFFBBD0 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x9FFFFFFFFFFFBBE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBBF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBC90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x9FFFFFFFFFFFBCA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2010-02-24-08.59.05.861647+480 I1598971344A438 LEVEL: Error
PID : 4901 TID : 1 PROC : db2agent (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: 10.10.133.10.1159.100224005904
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateAndLockParent, probe:920
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"
2010-02-24-08.59.05.862464+480 I1598971783A440 LEVEL: Error
PID : 4901 TID : 1 PROC : db2agent (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: 10.10.133.10.1159.100224005904
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateAndLockParent, probe:920
DATA #1 : String, 66 bytes
Failed at directory /db2/xadata/db2inst1/NODE0000/XAEBIS/T0000001.
2010-02-24-08.59.05.980251+480 I1598972224A1006 LEVEL: Severe
PID : 4901 TID : 1 PROC : db2agent (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: 10.10.133.10.1159.100224005904
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbASSetPoolContsForSMS, probe:50
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"
DATA #1 : String, 10 bytes
TEMPSPACE1
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
1
DATA #3 : unsigned integer, 8 bytes
1
DATA #4 : Hex integer, 8 bytes
0x0000000000000000
DATA #5 : Pool container specifications, PD_TYPE_SQLB_CONTAINER_SPEC, 276 bytes
Container #: 0
name: /db2/xadata/db2inst1/NODE0000/XAEBIS/T0000001/C0000000.TMP
type: SQLB_CONT_PATH
size: 0
alterOperation: 0
stripeSetToAlter: 0
nodeNum: 0
2010-02-24-08.59.05.980647+480 I1598973231A640 LEVEL: Error
PID : 4901 TID : 1 PROC : db2agent (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: 10.10.133.10.1159.100224005904
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbASDefineContainersForSMS, probe:60
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"
DATA #1 : String, 10 bytes
TEMPSPACE1
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
1
DATA #3 : unsigned integer, 8 bytes
1
DATA #4 : unsigned integer, 8 bytes
1
DATA #5 : Boolean, 1 bytes
false
2010-02-24-08.59.05.980788+480 E1598973872A604 LEVEL: Severe
PID : 4901 TID : 1 PROC : db2agent (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: 10.10.133.10.1159.100224005904
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSStartPool, probe:107
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"
DATA #1 : String, 143 bytes
Unable to redefine containers for temporary automatic storage table space "TEMPSPACE1" (ID = "1"). Placing table space into the OFFLINE state.
2010-02-24-08.59.06.037945+480 E1598974477A466 LEVEL: Error
PID : 4903 TID : 1 PROC : db2logmgr (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832E DB2 was unable to find the user exit program when archiving
log file "S0000000.LOG" from "/db2log/xalog/NODE0000/" for database
"XAEBIS". The error code was "24".
2010-02-24-08.59.06.038454+480 I1598974944A376 LEVEL: Error
PID : 4903 TID : 1 PROC : db2logmgr (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from
/db2log/xalog/NODE0000/ with rc = 24.
2010-02-24-08.59.06.038573+480 I1598975321A322 LEVEL: Error
PID : 4903 TID : 1 PROC : db2logmgr (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc 24 for LOGARCHMETH1.
2010-02-24-08.59.07.146337+480 E1598975644A466 LEVEL: Error
PID : 4903 TID : 1 PROC : db2logmgr (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832E DB2 was unable to find the user exit program when archiving
log file "S0000001.LOG" from "/db2log/xalog/NODE0000/" for database
"XAEBIS". The error code was "24".
2010-02-24-08.59.07.146606+480 I1598976111A376 LEVEL: Error
PID : 4903 TID : 1 PROC : db2logmgr (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000001.LOG to USEREXIT from
/db2log/xalog/NODE0000/ with rc = 24.
2010-02-24-08.59.07.146729+480 I1598976488A322 LEVEL: Error
PID : 4903 TID : 1 PROC : db2logmgr (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc 24 for LOGARCHMETH1.
2010-02-24-08.59.07.146770+480 E1598976811A423 LEVEL: Event
PID : 4915 TID : 1 PROC : db2stmm (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000 DB : XAEBIS
APPHDL : 0-8 APPID: 10.10.133.10.1159.100224005904
AUTHID : DB2INST1
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1009
DATA #1 :
Starting STMM log from file number 768
2010-02-24-08.59.09.076814+480 I1598977235A438 LEVEL: Error
PID : 4919 TID : 1 PROC : db2agent (XAEBIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: 10.10.133.10.1160.100224005910
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateAndLockParent, probe:920
MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
"Bad container path"