DB2 Server for VSE & VM: Data Restore Guide

Organization

This book is organized as follows:

• Summary of Changes lists changes to the product since Version 6 Release 1.
• Chapter 1, How to Recover from Failures describes some of the errors you can encounter and how to recover.
• Chapter 2, Recovery Strategies gives you recommendations and scenarios to choose from to define your own archive and recovery strategy.
• Chapter 3, Archive and Recovery describes the options provided to back up a complete DB2 database and restore its data.
• Chapter 4, Installing Data Restore provides the necessary steps for installing Data Restore in any of the following environments: VM/ESA, VSE/ESA, or VSE Guest Sharing.
• Chapter 5, Migration provides the necessary steps for migrating Data Restore in any of the following environments: VM/ESA, VSE/ESA, or VSE Guest Sharing.
• Chapter 6, How to Apply Service describes the steps required to apply service to Data Restore.
• Chapter 7, Data Unload and Reload describes the unload and load procedures.
• Chapter 8, Backing Up an Entire Database describes how to use Data Restore to back up DB2 Server for VSE & VM databases.
• Chapter 9, Restoring an Entire Database or an Entire Storage Pool describes how to use Data Restore to restore an entire DB2 Server for VSE & VM database or an entire storage pool from either a user or a DB2 Server for VSE & VM archive.
• Chapter 10, Backing Up Parts of a Database describes how to use Data Restore to unload dbspaces because you want to backup only a single dbspace and not the entire database.
• Chapter 11, Restoring Logical Elements describes how to use Data Restore to reload a single table or a group of tables with its full environment: indexes, referential integrity, views, grants, comments, and labels.
• Chapter 12, Accessing Data Whether the Server is Up or Down describes how to select data from a table while the application server is up or down.
• Chapter 13, Displaying the Contents of an Archive File describes how to use Data Restore to display the list of all tables in an archive or an unload file.
• Chapter 14, Displaying Dbspace Information describes how to produce a report from the application server (which can either be online or offline) to show the number of used pages (header, data, or index) in the database.
• Chapter 15, Displaying Pool Organization describes how the user can produce a report from the application server to show the dbextent and storage pool organization.
• Chapter 16, Command Syntax contains all the command syntax diagrams and examples.
• Appendix A, Messages and Codes provides messages and codes.
• Appendix B, Command Examples provides procedures to illustrate the usage of Data Restore functions.
• Appendix C, Problem Determination provides problem determination information.
• Index