Filter
Top Products
XVI DB2 Backup/Recovery Notes (OSS Note 83000)
NOTE: The procedures described here are applicable to DB2 Version 8. Version 8
provides two new utilities for backup and point in time recovery that provides a more
robust solution that is less prone to errors, and reduces recovery time and labor time.
These new utilities are described later in this section.
DB2 Backup
- DB2 Image Copy
- Volume Level (hardware assisted such as FlashCopy or DSS DASD Dump/Restore)
Database Recovery
- to current end of log
- to prior point in time represented by a log RBA
- determined by business needs
DB2 Image Copy
- Offline - not useful with R/3 in general
- Online - used by almost all customers, used for recover to cu rrent
Volume Level
- DB2 Suspend Log
- FlashCopy/SnapShot/EMC TimeFinder
- DB2 Resume Log
- used as a base for prior point in time recovery
*Need to perform both types of backup, image copy:
- allows recovery of individual tablespaces
- allows management of the size of SYSLGRNX by deleting old image copies
Unit Of Recovery
- DB2 : does not span R/3 dialog steps, resolved at DB2 startup
- SAP: spans multiple dialog steps, uses VBLOG, resolved using transaction SM13 and
parameter rdisp/vbreorg
Recover to Current
- Standard DB2 Recovery
- Recover damaged objects
- RECOVER TABLESPACE/RECOVER INDEXSPACE
- Image Copy + Apply Logs
Copyright 2006
IBM Solutions Technical Sales (STS) 12/18/2007Page 43 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation