Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1230
  • Last Modified:

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
0
adamsmw
Asked:
adamsmw
1 Solution
 
Gary PattersonVP 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:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/books/sc415304.pdf

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

Gary Patterson
http://www.experts-exchange.com/M_4382324.html

0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now