注册 登录
编程论坛 DB2论坛

暴力重启 DB2 后,数据库连不上

雪碧透心凉 发布于 2014-04-25 16:38, 6765 次点击
暴力重启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.
0 回复
1