Solved

restore db2 online backup without the log file ?

Posted on 2004-08-07
3
1,104 Views
Last Modified: 2009-12-16
Hi,
   Is there any possible way to restore db2 online backup image without the
log file ? In fact, the database seems to restore successfully but stays in
"roll-forward pending" state. After cancel the rollforward, and it moved to
"restore pending" state.
Thanks !

regards,
kuahkg

0
Comment
Question by:kuahkg
3 Comments
 
LVL 13

Accepted Solution

by:
ghp7000 earned 250 total points
ID: 11752235
if you are missing or dont have the active log file, then I think you need to contact IBM support to be able to restore the database. I don't think the database manager will allow access since it cannot guarantee the consistency of the database.
I have not encountered this problem, but I would try to restore the database with the 'WITHOUT ROLLING FORWARD' clause.
I would also try to rollforward the database the the last known point in time. To find this out, issue
db2 rollforward database <name> query status, but I suspect you will need IBM support.

0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now