| 发表于：2008-01-12 11:34:35 楼主 |
rhelas4u4 + ｄｂ２ ｖ８.１
服务器断电后,
重启,连接数据,等半个小时也连接不上
对数据库分区 fsck 后,
依旧如此 ．．．．
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ｌｏｇ ＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
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 ＥＸＥＣution 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 ＥＸＥＣution 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
--------------------------------------------------------------------------------
|
|
|
|
|
