Chapter 8. Building a corporate backup and recovery strategy 291
8.1 Advanced features for backup and recovery
IBM InfoSphere Warehouse Advanced Edition contains a number of tools that
allow you to transform how you build and implement your backup and recovery
strategy and ultimately improve your ability to recover data quickly.
In an operational business intelligence (BI) environment, data is continuously
loaded into the database and offline or off-peak maintenance windows are not
always available. Using the tools described in this chapter enables you to:
???? Eliminate full database backups.
Reduce backup operations and traffic by building full database backups from
incremental and delta images without connecting to the production database.
???? Restore data at granular levels to avoid unnecessary outages.
Restore data at table space, table, and row level; target and undo individual
transactions within the log files.
???? Perform data unload and preparation for restore on another server.
Unload data from backup images to flat files outside of the production system
and then discretely restore that data to the production database, thereby
minimizing or eliminating any outage.
???? Generate targeted data extracts directly from your backup images.
Eliminate expensive resource usage and time-consuming workloads on the
production database by creating data extracts from merged full database
backup images.
???? Populate development and test systems automatically.
Migrate data from full database backup images or table space containers to
test or downstream environments, avoiding costly database operations and
manual tasks.
8.1.1 Advanced recovery solutions explained
There are a number of tools available in IBM InfoSphere Warehouse Advanced
Edition to complement the native DB2 backup, restore, and recover functions. By
incorporating these tools into your backup and recovery strategy, you can help
minimize potential outage caused by data loss.
DB2 Merge Backup
IBM DB2 Merge Backup for Linux, UNIX and Windows (DB2 Merge Backup)
creates a complete and current full database or table space backup by
combining an original full backup with subsequent incremental and delta
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.