暴力重启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.