标题:暴力重启 DB2 后,数据库连不上
取消只看楼主
雪碧透心凉
Rank: 3Rank: 3
等 级:论坛游侠
威 望:2
帖 子:40
专家分:131
注 册:2014-2-26
结帖率:100%
 问题点数:0 回复次数:0 
暴力重启 DB2 后,数据库连不上
暴力重启DB2后,db2 connect to databasename,db2 restart都提示如下:
DB21016E  The Command Line Processor encountered a system error while sending
the command to the backend process.
DB21018E  A system error occurred. The command line processor could not
continue processing.
执行db2stop force、db2start 后,db2diag.log日志如下,数据库始终连不上:
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: LSDATADB : ACTIVATED: NO
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000002852728010 MinbuffLSN
          0000002852728010
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E  Crash recovery has been initiated.
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 : <preformatted>
Using parallel recovery with 3 agents 19 QSets 57 queues and 16 chunks
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:25
DATA #2 : Hexdump, 4 bytes
0x00002AB9F27FD7C0 : 0A00 0F86               
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:3969
DATA #1 : String, 168 bytes
Did not reach previous RFWD lsn, so do not create a new file.
prcb->rfwdInput.startlsn 0000002852728010
rfwd_ReadLso             0
frec_readlso             172336853042
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:3969
RETCODE : ZRC=0x801000BB=-2146434885=SQLPR_MISSING_LOGFILES
          "rollforward missing log files"
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 140 bytes
Crash recovery failed with rc -2146434885
LowtranLSN 0000002852728010 MinbuffLSN 0000002852728010
Recovery started on log file S0000000.LOG.
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:16
DATA #1 : Hexdump, 4 bytes
0x00002AB9F37F6C74 : BB00 1080         
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:60
MESSAGE : ADM1532E  Crash recovery has failed with SQLCODE "-1042".
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/app/odsuser/sqllib/db2dump/FODC_DBMarkedBad_2014-04-25-16.09.3
          6.892466_0000/". Please look in this directory for detailed evidence
          about what happened and contact IBM support if necessary to diagnose
          the problem.
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
MESSAGE : ADM7518C  "LSDATADB" marked bad.
搜索更多相关主题的帖子: command occurred continue processor system 
2014-04-25 16:38



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-430643-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.141019 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved