Skip to Content
Former Member
Nov 16, 2009 at 08:28 AM

DB2 Restore Procedure


Hi Gurus,

Due to some power problem one of our ABAP System got crashed now we have a backup but i am not familiar with db2 restore procedure.

Though we have an Online backup but not sure that log_archiving was on or not.

I have gone through the few guides available on SDN / IBM. Now i have doubts before going ahead with restore.

1. What would be the exact command to restore an Online backup ?

2. What would be the exact command for roll-forward recovery after restoring an online backup?

3. Though DB2 Ver. 9.5 includes the Archive log while taking an online backup how can i summarize that whether i need to apply logs after restoring an online database because i am not sure whether log_archive was on or off.

Please suggest ...!!!