IBM DB2 V8, DB2 9 manual Recommended initial backup procedure

15. Establish and test DB2 Backup/Recovery Procedures. These procedures should include a combination of DB2 and non-DB2 utilities in order to handle various recovery scenarios. In addition, DB2 V8 provides two new utilities for providing DB2 controlled system wide backup and a point in time recovery. These are the BACKUP SYSTEM and RESTORE SYSTEM (See OSS note 83000).

In addition, with DB2 V8 and DB2 9 you can leverage the RESTORE SYSTEM utility for point-in-time recovery processes. It is not necessary to use the BACKUP SYSTEM utility in obtaining the system level copy in order 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. With the RESTORE SYSTEM utility the complexity of point-in-time recovery is greatly reduced, providing a process that can be accomplished in a couple of hours.

Recommended initial backup procedure:

Weekly ------> 1. Full DB2 Image Copy Of All R/3 Tablespaces

(SHRLEVEL=CHANGE or REFERENCE) (2 copies - one for offsite)

(Perform a dynamic build of COPY utility JCL and Control statements)

Daily ---------> 2. Full Image Copy of DB2 Catalog/Directory

(SHRLEVEL=REFERENCE) (2 copies - one for offsite)

3.Issue DB2 command ARCHIVE LOG MODE(QUIESCE) to establish point of consistency RBA

Daily ------> 1. FlashCopies of DB2 Volumes using DB2

SUSPEND LOG command or DB2 V8 BACKUP

SYSTEM

Note: DB2 SUSPEND LOG command performs the following actions:

-suspends log writes

-flushes log records to DASD

-records high log RBA in BSDS

-queues updates

-creates a point of consistency identified by a LOG RBA

-bufferpools are not flushed (it is not a checkpoint)

-allows a normal DB2 restart to obtain a consistent database (transactions in flight are rolled back)

Copyright 2006 IBM Solutions Technical Sales (STS)	12/18/2007Page 21 of 51
12/18/2007