How to restore DB with rollforward (DB2 on iSeries)

We have a iSeries V5R4 and need to restore a DB2 database from backup then roll forward to a point in time after the backup was taken.

Anyone have instructions and example commands?

Thanks and Best Regards
Who is Participating?
Gary PattersonConnect With a Mentor VP Technology / Senior Consultant Commented:
Basic process:

1) Restore individual database objects (RSTOBJ command)  or entire libraries (RSTLIB command) from your backup.
2) Restore, if necessary, any journal receivers (database transaction logs) that were backed off of the system containing transactions that need to be reapplied. (RSTOBJ command - Journal receivers are of type *JRNRCV)
3) Apply journaled changed from the journal receivers to the database tables using the APYJRNCHG command.

The Backup and Recovery Guide explains the process in detail.  See Chapter 10, in particular:

If you've never done this before, consider engaging the services of an expert, or contact your local IBM Business Partner.

Gary Patterson

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.