Our Db2 transaction log was getting full and some of the transaction logs are zipped, This made DB2 to create new logs with the same name and DB2 restarted as part of maintenance and it is not coming up. I see these messages in the diag log file.
I want to recover the database to a point before zipping the transaction logs Can someone help me if there is a way to recover db to point before zipping the logs. This is a 6 node multi partition environment. Thanks in advance.
2017-11-07-09.10.53.582757 Instance:db2inst Node:000
PID:1274064(db2agent (Database name) 0) TID:4371 Appid:*N0.db2inst.171107151047
base sys utilities sqeLocalDatabase::MarkDBBad Probe:10 Database:dbname
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
/". Please look in this directory for detailed evidence about what happened and
contact IBM support if necessary to diagnose the problem.
2017-11-07-09.10.53.583105 Instance:db2inst Node:000
PID:1274064(db2agent (Dbname) 0) TID:4371 Appid:*N0.db2inst.171107151047
base sys utilities sqeLocalDatabase::MarkDBBad Probe:10 Database:Dbname
ADM7518C "dbname" marked bad.
Since this a multi terabyte database I want to avoid restore of the database. Any help is appreciated.
Nageswara Pedas[Organization Members] @ Nov 07, 2017 - 11:00 AM (America/Eastern)