Filter
Top Products
DB2 Version 8 Enhancements
DB2 Version 8 enhances the SAP backup and recovery process by providing two new
system utilities for system level backup and a point in time recovery for the entire SAP
system. These are the BACKUP SYSTEM and RESTORE SYSTEM. They provide an
efficient and non-dusruptive method for backing up the entire SAP database. DFSMS
has new entities that provide support for these utilities, these are the Copy Pool
construct and the Copy Poolbackup Storage Group type. Reference the redbook DB2
UDB for z/OS V8: Through the Looking Glass and What SAP Found There (IBM
SG24-7088) for additional information.
The requirements for implementing these utilities are:
- DB2 V8 in New Function Mode
- DASD that supports the FlashCopy API
- z/OS 1.5 or higher
- DFSMS Managed DB2 DataSets
- Copy Pools for data and logs
- Backup Storage Groups for each Storage Group in a Copy Pool
The high level steps for performing a backup/recovery are:
- Use the DFSMS ISPF Panels to define the Copy Pool, Source Storage Group, and
Backup Storage Group structures
- Execute the BACKUP SYSTEM Utility
- Use the DB2 Quiesce Utility on a dummy object to establish and document a
recovery point (RBA for non-Data Sharing, LRSN for Data Sharing)
- Execute DSNJU003 Utility to create a conditional restart control record for system
point in time recovery (for Data Sharing execute for each member)
- Restart DB2 (system is in System Recover Pending Mode, if Data Sharing restart all
members))
- Execute the RESTORE SYSTEM Utility
- DB2 recovers the system to the specified point in time
- Recover or rebuild objects DB2 placed in a recover pending state
- Restart DB2 (if Data Sharing all members) to reset the system recovery pending
status
Copyright 2006
IBM Solutions Technical Sales (STS) 12/18/2007Page 46 of 51
12/18/2007
Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation