DB2 Server for VSE & VM: Data Restore Guide

Table of Contents

  • About This Book
  • Who Should Use This Book
  • How to Use This Book
  • Organization
  • Prerequisites
  • Terminology
  • National Language Support
  • Co-existence
  • How to Send Your Comments

  • Summary of Changes
  • Summary of Changes for DB2 Version 7 Release 1
  • Enhancements, New Functions, and New Capabilities
  • TCP/IP Support for DB2 Server for VSE
  • DRDA RUOW Application Requester for VSE (Batch)
  • Stored Procedures Application Requester
  • Simplified DB2 Server for VSE Installation/Migration
  • New Code Page and Euro Symbol Code Page Support
  • Control Center for VM Enhancements
  • Control Center for VSE Enhancements
  • QMF for VSE & VM Optional Feature
  • QMF for Windows(R) Optional Feature
  • Reliability, Availability, and Serviceability Improvements
  • DBNAME Directory Restructuring
  • Migration Considerations
  • Library Enhancements

    • Getting Started

  • Chapter 1. How to Recover from Failures
  • Failures to be Considered
  • Power or Hardware Failure
  • DASD Failure
  • Log Disk Failure
  • Directory Disk Failure
  • Data Disk Failure
  • Operating System Abend
  • DB2 Failure
  • Application or User Logic Error

  • Chapter 2. Recovery Strategies
  • Recommendations
  • Evaluation
  • Archive Advantages
  • Archive Weaknesses
  • Comparison between Data Restore BACKUP and DB2 ARCHIVE
  • Considerations
  • Possible Strategies
  • User Archives and Unloads
  • Online DB2 Archive and Translation
  • Online DB2 Archive
  • Data Restore BACKUP
  • Data Restore BACKUP FULL/INCREMENTAL
  • Changing Your Recovery Strategies

  • Chapter 3. Archive and Recovery
  • Overview
  • Control Center
  • User Archives
  • Archiving with DB2
  • DB2 Archive
  • Log Archive
  • DB2 Restore
  • Log Recovery
  • Data Restore BACKUP
  • Data Restore BACKUP FULL/INCREMENTAL
  • Data Restore RESTORE
  • Summary
  • Compatibilities
  • Possibilities

  • Chapter 4. Installing Data Restore
  • Supported Environments
  • Complete the Preinstallation Checklist
  • Section 1. Installing Under VM
  • Step 1. Define the VM Resources
  • Step 2. Define the Database Manager Resources
  • Step 3. Complete the VM Installation Process
  • Step 3.1 Load Data Restore from Tape
  • Step 3.2 Create the Database Environment
  • Step 3.3 Load the Data Restore Packages
  • Step 3.4 Create the Data Restore Modules
  • Step 3.5 Install in Additional Application Servers
  • Step 3.6 Define Default Values for Data Restore Parameters
  • Starting Data Restore in a VM Environment
  • Section 2. Installing Under VSE
  • Placement of Data Restore Distribution Libraries
  • Machine-Readable Material
  • IBM-Supplied Installation Aids
  • Step 1. Define the Library to be Installed
  • Step 1.1 Define a Library in VSE/VSAM Space
  • Step 1.2 Prepare the Library DLBL Statements
  • Step 1.3 Define the Library and Sublibrary
  • Step 2. Restore the Data Restore Distribution Library
  • Step 3. Install Data Restore
  • Step 3.1 Acquire the Required Dbspaces
  • Step 3.2 Create the Required Tables
  • Step 3.3 Reload the Data Restore Packages
  • Step 3.4 Link-edit the Data Restore PRDI
  • Step 3.5 Define the VSAM Files for Data Restore
  • Step 3.6 Define Default Values for Data Restore Parameters
  • Starting Data Restore in a VSE Environment
  • Section 3. Installing Under VSE Guest Sharing
  • Step 1. Define the VM Resources
  • Step 2. Define the Database Manager Resources
  • Step 3. Complete the VM Installation Process
  • Step 3.1 Load Data Restore from Tape
  • Step 3.2 Create the Database Environment
  • Step 3.3 Load the Data Restore Packages
  • Step 3.4 Create the Data Restore Modules
  • Step 3.5 Define Default Values for Data Restore Parameters
  • Step 4. Define the VSE Resources
  • Step 4.1 Define the Library to be Installed
  • Step 4.2 Define a Library in VSE/VSAM Space
  • Step 4.3 Prepare the Library DLBL Statements
  • Step 4.4 Define the Library and Sublibrary
  • Step 4.5 Restore the Data Restore Distribution Library
  • Step 5. Complete the VSE Installation Process
  • Step 5.1 Link-edit the Data Restore PRDI
  • Step 5.2 Define the VSAM Files for Data Restore
  • Step 5.3 Define Default Values for Data Restore Parameters
  • Complex Environment Considerations
  • Installation Considerations
  • A Complex Environment Example
  • Security and Authorizing Access to the Server Minidisks (VM Only)

  • Chapter 5. Migration
  • Migration under VM
  • Migration under VSE
  • Migration under VSE Guest Sharing

  • Chapter 6. How to Apply Service
  • Applying Service for Data Restore for VM
  • Applying Service for Data Restore for VSE

    • Using Data Restore

  • Chapter 7. Data Unload and Reload
  • Overview
  • DBSU DATAUNLOAD and DATALOAD
  • Ease of Operation with Control Center
  • DBSU UNLOAD and RELOAD
  • Ease of Operation with Control Center
  • Data Restore SELECT
  • Data Restore UNLOAD and RELOAD
  • Data Restore UNLOAD
  • Data Restore RELOAD
  • Data Restore RELOAD with Forward Recovery
  • Data Restore RELOAD for Incremental Backup
  • Data Restore LISTLOG
  • Data Restore APPLYLOG
  • Summary
  • Compatibilities
  • Possibilities

  • Chapter 8. Backing Up an Entire Database
  • Deciding How to Backup Your Database
  • Choosing DB2 Server for VSE & VM Database Archives
  • Backup Procedures
  • Using Data Restore for Database Backups
  • Step 1. Stop the DB2 Server for VSE & VM Server Before Backing Up Your Database
  • Step 2. Processing a Data Restore Backup
  • Step 2.1 Backing Up Your Database (VM)
  • Step 2.2 Backing Up Your Database (VSE)
  • Step 3. Restarting the Database After Backing Up your Database

  • Chapter 9. Restoring an Entire Database or an Entire Storage Pool
  • Procedures to Recover from Failures
  • Recover from Directory Failure
  • Recover from Database Corruption
  • Data Recovery
  • From a Physical Error
  • Recover from System Failure
  • Step 1. Stop the Application Server
  • Step 2. Decide Whether to Restore from the Last Archive
  • Step 3. Determine If You Need to Reformat a DBEXTENT
  • Step 3A. Using the FORMAT Function (VSE Only)
  • Using the FORMAT Command
  • Step 4. Starting the RESTORE Function
  • Step 4A. Restoring an Entire Database Using the Last Archive
  • Step 4B. Restoring Specific Storage Pools Using the Last Archive
  • Step 4C. Restoring an Entire Database Using Any Archive
  • Step 4D. Restoring Specific Storage Pools Using Any Archive
  • Step 4E. Restoring Using INCREMENTAL Archive
  • Step 5. Deciding Whether to Use Log Recovery

  • Chapter 10. Backing Up Parts of a Database
  • Using the UNLOAD Command
  • Unloading All Dbspaces

  • Chapter 11. Restoring Logical Elements
  • Recovery From a Logical Error
  • Step 1. Process a Standard DB2 Archive with Data Restore
  • Procedures to Translate an Archive into a BACKUP File
  • Example of a Report from TRANSLATE
  • Step 2. Reload Procedures
  • Using the RELOAD Command
  • Reload a Table after Deleting Existing Rows
  • Reload a New Table
  • Reload Rows into an Existing Table
  • Reload a Table with Full Environment Recreation
  • Reload Tables With Forward Recovery From the Log
  • Step 3. List the Changes Extracted from the Log Files
  • When You Need to Execute the LISTLOG Function
  • Using the LISTLOG Command
  • Example of a Report from LISTLOG Execution
  • Step 4. Apply LUWs Referenced in the Log to the Reloaded Tables
  • Using the APPLYLOG Command
  • Execute the APPLYLOG Function
  • Example of a Report from APPLYLOG

  • Chapter 12. Accessing Data Whether the Server is Up or Down
  • Introduction
  • Description
  • Using the SELECT Function in a VSE Environment
  • Using the SELECT Function in a VM Environment
  • Displaying the Results of the SELECT Function

  • Chapter 13. Displaying the Contents of an Archive File
  • Introduction
  • Description
  • Using the DESCRIBE Command

  • Chapter 14. Displaying Dbspace Information
  • Introduction
  • Description
  • Using the SHOWDBS Command
  • Report for SHOWDBS Function
  • Report for SHOWDBS Function (Summary Report)
  • Interpreting the SHOWDBS Reports

  • Chapter 15. Displaying Pool Organization
  • Introduction
  • Description
  • Using the SHOWPOOL Command
  • Report for SHOWPOOL Function
  • Interpreting the Output From the SHOWPOOL Function
  • Using the SHOWPOOL report

    • Reference

  • Chapter 16. Command Syntax
  • OPTIONS and CONTROL Statements
  • OPTIONS Statement Parameters
  • CONTROL Statement Parameters
  • APPLYLOG
  • BACKUP
  • DESCRIBE
  • FORMAT
  • LISTLOG
  • RELOAD
  • RESTORE
  • SELECT
  • SHOWDBS
  • SHOWPOOL
  • SHOWPTFH
  • TRANSLATE
  • UNLOAD

    • Appendixes

  • Appendix A. Messages and Codes

  • Appendix B. Command Examples
  • Using the BACKUP Function
  • In VSE
  • In VM
  • Using the DESCRIBE Function
  • Using the FORMAT Function
  • Using the RELOAD Function
  • Example of a Report from RELOAD
  • RELOAD Examples using VM
  • RELOAD Examples using VSE
  • Using Control Center
  • Examples of Reloading Tables in a VSE Environment
  • Examples of Reloading Tables in a VM Environment
  • Using the RESTORE Function
  • In VSE
  • In VM
  • Using the SELECT Function
  • Using the SHOWDBS Function
  • Using the SHOWPOOL Function
  • Using the TRANSLATE Function
  • Using Control Center
  • DB2 Archives
  • Using the UNLOAD Function
  • Unloading Multiple Dbspaces
  • Unloading All Dbspaces Except Those Listed
  • Unloading Multiple Dbspaces with the Server Stopped (VSE)
  • Unloading All Dbspaces Except One With the Server Stopped (VM)
  • Unloading Dbspaces With the Server Up
  • Unloading Dbspaces With the Database Server Down
  • Output of an UNLOAD Function

  • Appendix C. Problem Determination
  • Introduction
  • Part 1. System Errors
  • VM Environment - Possible Problems:
  • VSE Environment
  • Part 2. DB2 Errors
  • Both VM and VSE Environments
  • Part 3. Data Restore Feature Errors
  • Recover from a DB2 Server for VM Error during Full Environment Recreation
  • Reload Tables With Forward Recovery From the Log
  • Problem Determination when Reloading Tables

  • Notices
  • Trademarks

  • Bibliography

  • Index

    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]