Chapter 33. Backup and Recovery Utilities

In This Chapter

• The COPY Utility

• The COPYTOCOPY Utility

• The MERGECOPY Utility

• The QUIESCE Utility

• The RECOVER Utility

• The REBUILD INDEX Utility

• The REPAIR Utility

• The REPORT RECOVERY Utility

• Backing Up and Restoring the System

The backup and recovery utilities supplied with DB2 are wonderfully complex. They remove much of the burden of database recovery from the DBA or analyst and place it where it belongs: squarely on the shoulders of the DBMS.

Ten forms of backup and recovery are provided by nine DB2 utilities. The following list describes each form of backup and recovery along with the associated DB2 utility for each:

• Backup of all data in a table space, partition, or index  ( ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth 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.

Start your free trial