IBM DB2 9, DB2 V8 manual DB2 Version 8 Enhancements

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