Using DB2 V8 for z/OS RESTORE SYSTEM utility and SET LOG SUSPEND with Online and Offline copies for PITR
Document Author:
Mary Siart
Document ID:
TD103910
Doc. Organization:
e-business Solutions Technical Support
Document Revised:
06/19/2007
Product(s) covered:
DB2 for z/OS and OS/390
Abstract: System point-in-time-recovery (PITR) can be a very complex and long running process. With the DB2 V8 for z/OS Restore System utility, along with the right volume level copy strategy, a system PITR can be accomplished in a couple of hours instead of days. It is not necessary to use the Backup System utility in obtaining the system level copy to leverage the benefits of a total system level recovery using the Restore System utility. The system level copy can be obtained using the volume level copy technology of your DASD along with a SET LOG SUSPEND. Please reference Automated Online System Copy Process: DB2 Suspended Log using FlashCopy; Techdocs: http://w3-1.ibm.com/support/techdocs/atsmastr.nsf/PubAllNum/TD101860 for help on creating an online system copy process. Either online or offline copies can be used in a PITR process using the DB2 Restore System Utility. This document describes the timeline for using an online copy or an offline copy for performing a PITR.
Classification:
Software; Solutions
Category:
Backup and Recovery
Solution(s):
ISV Applications
ISV(s):
SAP
Platform(s):
IBM System z Family
S/W Pillar(s):
Information Management
O/S:
z/OS
Keywords:
Point in time recovery, PITR, system level recovery
The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?
