RHELAS4U4 + DB2 V8.1
服务器断电后,
重启,连接数据,等半个小时也连接不上
对数据库分区 fsck 后,
依旧如此 ....
====================LOG ===================
QUOTE:
--------------------------------------------------------------------------------
base sys utilities DB2main Probe:9
ADM0506I DB2 has automatically updated the "shmmax" kernel parameter from
"33554432" to the recommended value "268435456".
2008-01-12-10.47.59.220754 Instance:db2inst Node:000
PID:3967(db2star2) TID:3023316672 Appid:none
base sys utilities DB2StartMain Probe:911
ADM7513W Database manager has started.
2008-01-12-10.53.44.017764 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities sqledint Probe:30 Database:[DBName]
Crash Recovery is needed.
2008-01-12-10.53.44.614479 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
recovery manager sqlpresr Probe:410 Database:[DBName]
Crash recovery started. LowtranLSN 000006C7FF75B9CB MinbuffLSN 000006C7F956FB1E
2008-01-12-10.53.44.734727 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
recovery manager sqlprecm Probe:2000 Database:[DBName]
Using parallel recovery with 5 agents 4 QSets 16 queues and 16 chunks
2008-01-12-10.54.40.070520 Instance:db2inst Node:000
PID:4431(db2agnsc ([DBName])) TID:3023316672 Appid:none
data protection sqlpgrlgRedo Probe:1270
recLsn:
0x3776A198 : 0x3C123CFFC7060000 .....<.<
PID:4431 TID:3023316672 Node:000 Title: SQLP_DBCB
Dump File:/home/db2inst/sqllib/db2dump/44313023316672.000
2008-01-12-10.54.40.167815 Instance:db2inst Node:000
PID:4431(db2agnsc ([DBName])) TID:3023316672 Appid:none
data protection sqlpgrlgRedo Probe:0
Error -2045771763 when reading LSN 000006C7FF3C123C from log file S0000001.LOG, dpsAcbFlags 20, setSkipOutputBuf 0
2008-01-12-10.54.40.228172 Instance:db2inst Node:000
PID:4431(db2agnsc ([DBName])) TID:3023316672 Appid:none
recovery manager sqlpPRecReadLog Probe:1280
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2008-01-12-10.54.40.306473 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
recovery manager sqlpresr Probe:640 Database:[DBName]
Crash recovery failed with rc -2045771763
LowtranLSN 000006C7FF3B7CBE MinbuffLSN 000006C7F9BBCCE9
Recovery started on log file S0000000.LOG.
2008-01-12-10.54.40.360714 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities recover Probe:16 Database:[DBName]
DiagData
0xBFFF7954 : 0x8610000D ....
2008-01-12-10.54.40.445151 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities recover Probe:16 Database:[DBName]
0xBFFF7954 : 0x8610000D ....
2008-01-12-10.54.40.463275 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities recover Probe:60 Database:[DBName]
ADM1532E Crash recovery has failed with SQLCODE "-1042".
2008-01-12-10.54.40.499519 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities sqleMarkDBad Probe:10 Database:[DBName]
ADM7518C "[DBName] " marked bad.
2008-01-12-10.54.40.535749 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities sqleMarkDBad Probe:210 Database:[DBName]
Database logging stopped due to mark db bad.
2008-01-12-10.54.40.600814 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
DRDA Application Server sqljsSignalHandler Probe:10 Database:[DBName]
DIA0505I Execution of a component signal handling function has begun.
PID:4419 TID:3023316672 Node:000 Title: **** DRDA ASCB ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: **** SEND BUFFERS ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: **** CONNECTION HANDLE ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: **** AS UCINTERFACE ****
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
2008-01-12-10.54.40.797325 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
DRDA Application Server sqljsSignalHandler Probe:20 Database:[DBName]
DIA0506I Execution of a component signal handling function is complete.
PID:4419 TID:3023316672 Node:000 Title: SQLE_AGENTCB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_AGENT_PRIVATECB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_DBCB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_TRAN_CB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_MASTER_APP_CB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_APP_CB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_COORDINATOR_CB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
PID:4419 TID:3023316672 Node:000 Title: SQLE_APP_GROUP_CB
Dump File:/home/db2inst/sqllib/db2dump/44193023316672.000
2008-01-12-10.54.41.021771 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities sqleInitEngineComponents Probe:202 Database:[DBName]
If 'DATALINK: file server not registered' appears above and DATALINKS=NO, set DATALINKS=YES and try RESTART again
2008-01-12-10.54.41.076277 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
base sys utilities sqlesrsu Probe:140 Database:[DBName]
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".
2008-01-12-10.54.41.094547 Instance:db2inst Node:000
PID:4419(db2agent ([DBName])) TID:3023316672 Appid:*LOCAL.db2inst.06BDC2025343
buffer pool services sqlbTerminateAgent Probe:826 Database:[DBName]
Recovery failed, dirty pages not flushed
--------------------------------------------------------------------------------
5 个解决方案
看看你的instance是否设置成了自动启动.如果没有你启动一下看看.
不知道是不是这个原因.
不是我打击你,基本不用努力了。
1、Error -2045771763 when reading LSN 000006C7FF3C123C from log file S0000001.LOG, 说明数据库的食物日志损坏了,数据库无法recovery。
2、遇到ADM7518C "[DBName] " marked bad. 这样的话,你就准备备份景象恢复吧,基本没救了