Hi,
I am having only 2 days online backup image. I have no log files with me. I am able to restore the Database with the backup image. How to bring the database up from rollforward pending state since I am not having any log file?
To be more precise, is ity possible to bring the database up from online backup image without log file,If so How?
Thanks

What DB2 version and OS are you using?

Andy

Version is 8.1.0.136 Fixpack 15
o/s Unix

Do you use the INCLUDE LOGS clause in the backup command?

Andy

Use the WITHOUT ROLLING FORWARD option (see manual) to prevent the rollforward-pending state.

Stolze,

This is an ONLINE backup you cannot use WITHOUT ROLLING FORWARD clause in this case. From the manual:

WITHOUT ROLLING FORWARD
Specifies that the database is not to be put in rollforward pending state after it has been successfully restored.

If, following a successful restore operation, the database is in rollforward pending state, the ROLLFORWARD command must be invoked before the database can be used again.

1 If this option is specified when restoring from an online backup image, error 1 SQL2537N will be returned.


Andy

Right. I skimmed too fast over the post and didn't notice that it was an online backup.

There are two options:

1. Call IBM support and beg them to help you (they "can" overrirde the rollforward pending flag if you convince them that data integrity issues will not be a problem and you will not sue them if you database is out of synch with uncommited data), or

2. Update your resume.