Chapter 8. Building a corporate backup and recovery strategy 295
In a disaster recovery environment, DB2 Merge Backup images can be used to
restore from a merged database backup; the recovery can be completed by
using ETL processes to complete the recovery through reprocessing ETL data.
An alternate option is to use Optim High Performance Unload to unload data
from table space containers where the database layer is not available.
8.2.3 Backup infrastructure
Understand the capabilities of your backup infrastructure. Include the following
capabilities:
Have enough local disk space.
Where local disk backup is your chosen strategy, have enough storage
capacity on each data node for two full database backup images plus regular
backups of hot table spaces per database partition. Use backup compression
to minimize the actual storage required. An amount of storage capacity is also
required to stage DB2 Merge Backup and DB2 Recovery Expert data where
used; the amount of storage required is dependent on the features used.
Integrate Tivoli Storage Manager (TSM) with DB2 and recovery tools.
Integration means that the database software can communicate with the
storage manager to retrieve backup images and archived logs as required to
perform a recovery.
Have enough tape drives to support your chosen strategy.
A natural limit in how many database partition backup operations can write to
tape in parallel is determined by the number of physical tape drives. If you
have only one tape drive then you can only backup and restore one database
partition at a time from tape. Carefully assess your need for both disk and
tape capacity based on your recovery objectives.
Use LAN-free.
Storage-to-storage communication of backup traffic takes place outside of the
internal application network and is recommended for full and incremental
backup and restore traffic to and from tape.
Set up merge backup infrastructure.
Merge backup can integrate with TSM when creating new backup images
from existing full and incremental backup images. Alternatively, backup
images can be merged and recreated on disk. Merge backup supports full,
incremental, and delta database, in addition to table space backups.
Get Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
