Q and A

Asked and Answered

How do I inquire about crash recovery status? I'm in the middle of crash recovery (DB2 UDB v. 6.1). It has completed the forward stage of the recovery according to the db2diag.log. But after that, there are no updates in the log stating any kind of completion or state change in crash recovery.

IBM offers this advice:

Use db2spec to find the status of the recovery: db2spec gfdb - recstatus

The nextlsn should be increasing over time. If you don't have db2spec, try looking at the timestamps of the log files. If they're changing, crash recovery is busy in the undo phase.

See a complete archive of reader/author Q&As .

CAREER CENTER
Ready to take that job and shove it?
SEARCH JOBS
RECENT JOB POSTINGS
CAREER NEWS
10 Search Engines You Don't Know About
Go beyond Google and get vertical. These specialized search sites will help you find the business information you need -- fast.

Subscribe to the new digital version of IBM Database Magazine
New Digital Version

Sponsored links:


Subscribe to the IBM Database Magazine Newsletter
Email Address *
First Name
Last Name
HTML Preference
HTML Text
 

Fields with * are required.

 



Visit these other IBM and TechWeb Partner Sites: :
Maximizing ROI Through Business Process Management (BPM) and Service-Oriented Architecture (SOA)
Internet Evolution – The Macrosite for News, Analysis, & Opinion About the Future of the Internet
Business Innovation – Technology Strategies and Solutions for Driving Business Success


:: IBM Database Magazine ::