我的DB2在意外断电重启后,连接时报:
SQL1042C An unexpected system error occurred. SQLSTATE=58004
察看诊断日志文件中有
2012-05-02-19.26.52.175115+480 I378779E415 LEVEL: Error
PID : 11730 TID : 47014607841600PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 673 EDUNAME: db2lfr (RAYCHN) 0
FUNCTION: DB2 UDB, recovery manager, sqlpLsoToLogFile, probe:390
MESSAGE : iLso:
DATA #1 : Hexdump, 8 bytes
0x00002AC270FFCF38 : AE40 DC6F 0000 0000
2012-05-02-19.26.52.384006+480 I383406E526 LEVEL: Error
PID : 11730 TID : 47014486206784PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RAYCHN
APPHDL : 0-66 APPID: 192.168.8.227.56544.12050211265
AUTHID : RAYCHN
EDUID : 56 EDUNAME: db2agent (RAYCHN) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:16
DATA #2 : Hexdump, 4 bytes
0x00002AC269BF6C74 : 1F00 1082 ....
2012-05-02-19.26.52.384198+480 E383933E498 LEVEL: Error
PID : 11730 TID : 47014486206784PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RAYCHN
APPHDL : 0-66 APPID: 192.168.8.227.56544.12050211265
AUTHID : RAYCHN
EDUID : 56 EDUNAME: db2agent (RAYCHN) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".
2012-05-02-19.26.52.384963+480 E384432E977 LEVEL: Critical
PID : 11730 TID : 47014486206784PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : RAYCHN
APPHDL : 0-66 APPID: 192.168.8.227.56544.12050211265
AUTHID : RAYCHN
EDUID : 56 EDUNAME: db2agent (RAYCHN) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred:
"DBMarkedBad". The instance may have been shutdown as a result.
"Automatic" FODC (First Occurrence Data Capture) has been invoked and
diagnostic information has been recorded in directory
"/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2012-05-02-19.26.52.3
84807_0000/". Please look in this directory for detailed evidence
about what happened and contact IBM support if necessary to diagnose
the problem.
诊断文件:11730.56.000.stack.txt
DB2 build information: DB2 v9.7.0.4 s110330 SQL09074
timestamp: 2012-05-02-19.26.52.386513
instance name: db2inst1.000
EDU name : db2agent (RAYCHN) 0
EDU ID : 56
Signal #12
uname: S:Linux R:2.6.18-194.el5 V:#1 SMP Fri Apr 2 14:58:14 EDT 2010 M:x86_64 N:CMSDB
process id: 11730
thread id : 47014486206784 (0x2AC269BFE940)
0C000000 00000000 FAFFFFFF FFFFFFFF
D22D0000 21030000 704B347E 0281FFFF
00D8F37C 0181FFFF 00D8F37C 0181FFFF
00000000 00000000 8C870B80 FFFFFFFF
08000000 00000000 0C000000 00000000
252E0000 00000000 D22D0000 00000000
EA000000 3E0000C0 00000000 00000000
E080CE00 02000000 00000000 00000000
Signal #12 (SIGUSR2); si_code: -6
Data seg top [sbrk(0)] = 0x0000000016DD8000
Cur cpu time limit (seconds) = 0xFFFFFFFF
Cur file limit (bytes) = 0xFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFF
Cur stack size (bytes) = 0x00A00000
Cur core size (bytes) = 0xFFFFFFFF
Cur nofiles (descriptors) = 0x0000FFFE
Cur memory size (bytes) = 0xFFFFFFFF
rax 0x0000000000000000 rbx 0x0000000000000000
rcx 0xffffffffffffffff rdx 0x000000000000000c
rbp 0x0000000200ce80e0 rsp 0x00002ac269bf6cc8
rsi 0x0000000000002e25 rdi 0x0000000000002dd2
rflags 0x0000000000000286 rip 0x000000340460bd02
r8 0x0000000000000000 r9 0x0000000001200000
r10 0x0000000000000008 r11 0x0000000000000286
r12 0x0000000000000000 r13 0x0000000000000000
r14 0x0000000201000080 r15 0x0000000000000038
pthread_kill + 0x0032 (/lib64/libpthread.so.0)
0x000000340460BD02 : 89C231FFF7DA3D00
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AC25F39AE2F ossDumpStackTraceEx + 0x01ef
(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AC25F395BEE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc
(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AC25C4A1CAB sqlo_trce + 0x03fb
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25C4E6FD6 sqloDumpDiagInfoHandler + 0x00e0
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000000340460EB10 address: 0x000000340460EB10 ; dladdress: 0x0000003404600000 ; offset in lib: 0x000000000000EB10 ;
(/lib64/libpthread.so.0)
0x000000340460BD02 pthread_kill + 0x0032
(/lib64/libpthread.so.0)
0x00002AC25C4E63CB sqloDumpEDU + 0x0031
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25B900BCD _ZN16sqeLocalDatabase9MarkDBBadEi + 0x01fd
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25B9006F4 _ZN16sqeLocalDatabase15RestartDatabaseEP14sqeApplicationP8sqeAgentP8SQLE_BWAP22SQLESRSU_STATUS_VECTORP5sqlca + 0x04dc
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB3C83C _ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP5sqlcaP22SQLESRSU_STATUS_VECTORc + 0x13e8
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB3A2E5 _ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlcaPc + 0x04fd
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB361F8 address: 0x00002AC25AB361F8 ; dladdress: 0x00002AC259CB7000 ; offset in lib: 0x0000000000E7F1F8 ;
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB3502A _ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x01b8
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB91AE3 _Z11sqlelostWrpP14db2UCinterface + 0x001d
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB930E2 _Z14sqleUCengnInitP14db2UCinterfacet + 0x051c
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB920EF sqleUCagentConnect + 0x0297
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AC288A6 _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x0086
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AC05140 _Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + 0x0084
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25ABFC302 _Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x0068
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25ABFC823 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x035b
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25ABF1413 address: 0x00002AC25ABF1413 ; dladdress: 0x00002AC259CB7000 ; offset in lib: 0x0000000000F3A413 ;
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25ABF86D9 address: 0x00002AC25ABF86D9 ; dladdress: 0x00002AC259CB7000 ; offset in lib: 0x0000000000F416D9 ;
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25ABF6062 address: 0x00002AC25ABF6062 ; dladdress: 0x00002AC259CB7000 ; offset in lib: 0x0000000000F3F062 ;
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25ABF5DD0 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x0102
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AB2B6EF _ZN8sqeAgent6RunEDUEv + 0x09e5
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25B1FA91C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25B1FA873 _Z10sqlzRunEDUPcj + 0x0009
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AC25AF69E3A sqloEDUEntry + 0x02f4
(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000000340460673D address: 0x000000340460673D ; dladdress: 0x0000003404600000 ; offset in lib: 0x000000000000673D ;
(/lib64/libpthread.so.0)
0x0000003403AD3D1D clone + 0x006d
(/lib64/libc.so.6)
Process Objects were dumped in 11730.000.processObj.txt
SIGABRT : 0x2ac25c4e712c
SIGBUS : 0x2ac25c4e712c
SIGCHLD : ignored
SIGILL : 0x2ac25c4e712c
SIGXCPU : ignored
SIGINT : 0x2ac25af69852
SIGSEGV : 0x2ac25c4e712c
SIGSYS : 0x2ac25c4e712c
SIGTRAP : 0x2ac25c4e712c
SIGALRM : 0x2ac25af20c06
SIGURG : 0x2ac25c4e6dd4
SIGPROF : 0x2ac25c4e5fe6
SIGPIPE : 0x2ac25c4e7e9c
SIGHUP : ignored
SIGFPE : 0x2ac25c4e712c
SIGUSR1 : 0x2ac25c4e6ef6
SIGUSR2 : 0x2ac25c4e6ef6
DBM_DBMS [ type 0 ]:
Address = 0000000200000000
Option = 0x42D02000
Token = 0x61
Hdl::pAddress = 0000000200000000
Hdl::pMemSet = 0000000200000000
Hdl::size(max) = 51773440
Hdl::id = 3276806
Hdl::type = 0
Hdl::node = 0
DBM_DB [ type 1 ]:
Address = 0000000000000000
Option = 0x1390A000
Token = 0x00
Hdl::pAddress = 00002AC3DFC08000
Hdl::pMemSet = 00002AC3DFC08000
Hdl::size(max) = 5801312256
Hdl::id = 5570571
Hdl::type = 1
Hdl::node = 0
FMP_RESOURCES [ type 2 ]:
Address = 0000000000000000
Option = 0x40082000
Token = 0x00
Hdl::pAddress = 0000000210000000
Hdl::pMemSet = 0000000210000000
Hdl::size(max) = 23068672
Hdl::id = 3309575
Hdl::type = 2
Hdl::node = 0
PRIVATE [ type 9 ]:
Address = 0000000000000000
Option = 0x30305000
Token = 0x00
Hdl::pAddress = 00002AC275346000
Hdl::pMemSet = 00002AC275346000
Hdl::size(max) = 1099511627776
Hdl::id = 0
Hdl::type = 9
Hdl::node = 0
APL_CTL [ type 12 ]:
Address = 0000000000000000
Option = 0x1390A000
Token = 0x00
Hdl::pAddress = 00002AC285751000
Hdl::pMemSet = 00002AC285751000
Hdl::size(max) = 163840000
Hdl::id = 5537802
Hdl::type = 12
Hdl::node = 0
current wait state (sqlo_waitlist) = 0x000000020001BC80: {
postcode = 2
nextAgent = 0x0000000000000000
index = 56
semSetId = 4784181
status = 0x0001
what = 0
IPC_address = 0x0000000000000000
taskId = 47014486206784
}
No latches held.
No information stored.
Event stack is empty
No records in event recorder
收起