重启服务器后,连接数据库,数据库自动停止如何解决
2015-01-10-18.21.14.265000+480 I144818H160 LEVEL: Error
PID:2208 TID:2304 NODE:000 Title: SQLP_LECB
Dump File:E:PROGRA~1IBMSQLLIBDB222082304.000
2015-01-10-18.21.14.265000+480 I144980H492 LEVEL: Error
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, data protection services, sqlptudo, probe:1710
RETCODE : ZRC=0x87040001=-2029780991=SQLD_BADPAGE "Bad Data Page"
DIA8500C A data file error has occurred, record id is "".
2015-01-10-18.21.14.281000+480 I145474H482 LEVEL: Warning
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, data protection services, sqlptudo, probe:4350
MESSAGE : LSN being undone:
DATA #1 : Hexdump, 8 bytes
0x03162558 : 0000 00F1 D90F BE19 ........
2015-01-10-18.21.14.281000+480 I145958H162 LEVEL: Error
PID:2208 TID:2776 NODE:000 Title: SQLP_TENTRY
Dump File:E:PROGRA~1IBMSQLLIBDB222082776.000
2015-01-10-18.21.14.281000+480 I146122H171 LEVEL: Error
PID:2208 TID:2776 NODE:000 Title: SQLE_AGENT_PRIVATECB
Dump File:E:PROGRA~1IBMSQLLIBDB222082776.000
2015-01-10-18.21.14.281000+480 I146295H160 LEVEL: Error
PID:2208 TID:2776 NODE:000 Title: SQLP_DBCB
Dump File:E:PROGRA~1IBMSQLLIBDB222082776.000
2015-01-10-18.21.14.281000+480 I146457H159 LEVEL: Error
PID:2208 TID:2776 NODE:000 Title: SQLP_ACB
Dump File:E:PROGRA~1IBMSQLLIBDB222082776.000
2015-01-10-18.21.14.281000+480 I146618H482 LEVEL: Error
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprudm, probe:40
RETCODE : ZRC=0x87040001=-2029780991=SQLD_BADPAGE "Bad Data Page"
DIA8500C A data file error has occurred, record id is "".
2015-01-10-18.21.14.281000+480 I147102H520 LEVEL: Error
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 142 bytes
Crash recovery failed with rc -2029780991
LowtranLSN 000000F1D5F1FE1C MinbuffLSN 000000F1BABDF7A1
Recovery started on log file S0000016.LOG.
2015-01-10-18.21.14.281000+480 I147624H438 LEVEL: Severe
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #1 : Hexdump, 4 bytes
0x02CF970C : 0100 0487 ....
2015-01-10-18.21.14.281000+480 I148064H437 LEVEL: Error
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #2 : Hexdump, 4 bytes
0x02CF970C : 0100 0487 ....
2015-01-10-18.21.14.281000+480 E148503H416 LEVEL: Error
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".
2015-01-10-18.21.14.281000+480 I148921H382 LEVEL: Severe
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqlesrsu, probe:140
RETCODE : ZRC=0xFFFFFBEE=-1042
2015-01-10-18.21.14.281000+480 I149305H433 LEVEL: Warning
PID : 2208 TID : 2776 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JX_TAIP
APPHDL : 0-7 APPID: *LOCAL.DB2.150110102038
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbTerminateAgent, probe:826
DATA #1 : String, 40 bytes
Recovery failed, dirty pages not flushed
2015-01-10-18.21.14.281000+480 I149740H382 LEVEL: Error
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgild, probe:310
RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2015-01-10-18.21.14.281000+480 I150124H160 LEVEL: Error
PID:2208 TID:2704 NODE:000 Title: SQLP_DBCB
Dump File:E:PROGRA~1IBMSQLLIBDB222082704.000
2015-01-10-18.21.14.281000+480 I150286H298 LEVEL: Error
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpflog, probe:480
MESSAGE : Error -2045771763, reqlsn 000000F1D90FC030
2015-01-10-18.21.14.281000+480 I150586H392 LEVEL: Error
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteSetup, probe:80
MESSAGE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2015-01-10-18.21.14.281000+480 I150980H2523 LEVEL: Severe
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteSetup, probe:300
DATA #1 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:3;obj:227;type:0} PPNum:117584
objectPageNum: 0
bucketGroupHashIndex: 286
hashnext: 0x00000000
hashprev: 0x00000000
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 11b
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x09830000
pinCount:
0x08123100 : 0000 0000 ....
dirtyprev: 0x08100240
dirtynext: 0x08136610
blockDesc: 0x00000000
pminlsn: 000000F1D8514226
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #2 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:3;obj:227;type:0} PPNum:117584 OPNum:0
begoff: 48
datlen: 16336
pagebinx: 1454
revnum: 1024
pagelsn: 00F1D8504988 flag: 2
signature: 1397626934
cbits1to31: 15202818
cbits32to63: 0
DATA #3 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 68 bytes
Obj: {pool:3;obj:227;type:0} Parent={0;0}
lifeLSN: 000000000000
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 102
objectState: 0
lastSMP: 0
pageSize: 16384
extentSize: 16
bufferPoolID: 1
partialHash: 14876675
bufferPool: 0x031dda50
DATA #4 : String, 15 bytes
poolPageNumber:
DATA #5 : unsigned integer, 4 bytes
117584
2015-01-10-18.21.14.281000+480 I153505H368 LEVEL: Severe
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01830174 : 0000 0000 ....
2015-01-10-18.21.14.281000+480 I153875H339 LEVEL: Severe
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x0B74F494 : 0000 0000 ....
2015-01-10-18.21.14.281000+480 I154216H405 LEVEL: Warning
PID : 2208 TID : 2704 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0B74F368 : 0000 0000 ....
2015-01-10-18.37.06.718000+480 I154623H1536 LEVEL: Event
PID : 2916 TID : 2892 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
E:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 453A 5C50 524F 4752 417E 315C 4942 4D5C E:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 534E OP2.EXE.NOMSG.SN
0x0012AD54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2015-01-10-18.37.09.171000+480 I156161H1537 LEVEL: Event
PID : 2888 TID : 2876 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
E:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 453A 5C50 524F 4752 417E 315C 4942 4D5C E:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2015-01-10-18.37.10.265000+480 E157700H863 LEVEL: Event
PID : 2104 TID : 2996 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT 2003SERVER Service Pack 2 5.2 x86 Family 6, model 30, stepping 5
CPU: total:4 online:4 Cores per socket:8 Threading degree per core:1
Physical Memory(MB): total:16373 free:15777 available:1882
Virtual Memory(MB): total:18158 free:33522
Swap Memory(MB): total:1785 free:17745