DB2 Recovery Expert for Multiplatforms

DB2 Recovery Expert for Multiplatforms

by Bart Steegmans, Mark Samson, Manish Shah
Released December 2002
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

DB2 Recovery Expert is one of the most recent IBM Data Management Tools for Multiplatforms. It provides an easy-to-use environment that even less experienced DBAs can successfully use, to complete highly sophisticated and efficient recovery techniques in minimal time. Built-in SMART (Self-Managing and Resource Tuning) features provide intelligent analysis of altered, incorrect or missing database assets - including tables, indexes, or data - and automate the process of rebuilding those assets to a correct point in time, often without taking the database or business operations offline.

This IBM Redbooks publication describes how to recover database objects safely, precisely, and quickly by using DB2 Recovery Expert for Multiplatforms, without having to resort to full disaster recovery processes.

This book gives assistance for expert recovery, describes summary and detail reports from log analysis, and provides point-in-time recovery scenarios, via roll forward or back out, and also shows how to recover objects that were dropped by accident.

Table of contents

  1. Figures
  2. Tables
  3. Examples
  4. Notices
    1. Trademarks
  5. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  6. Chapter 1: Introduction to DB2 Tools for Multiplatforms
    1. The DB2 Tools for Multiplatforms
      1. Database administration tools
      2. Performance management tools
      3. Recovery and replication tools
      4. Application management tools
    2. DB2 Web Query Tool
    3. DB2 Table Editor
    4. DB2 Recovery Expert
    5. DB2 High Performance Unload
    6. DB2 Performance Expert
    7. DM Tools for Multiplatforms ordering information
  7. Chapter 2: Introduction to DB2 Recovery Expert
    1. Overview
    2. Key features
      1. Simple, easy to use interface
      2. Dropped object restore
      3. Greater granularity in recovery operations
      4. Point-in-time recovery of objects
      5. Enhanced recovery performance
      6. SQL report generation
      7. Selective SQL undo/redo
    3. Key concepts
      1. Versioning Repository
      2. Minilogs
      3. Log analysis
      4. Object translation
      5. Our environment
  8. Chapter 3: Installation and configuration
    1. Installation requirements
      1. Hardware requirements
      2. Software requirements
    2. Installation instructions
      1. Starting InstallShield
      2. The InstallShield process
    3. Post-installation configuration
      1. Environment variables
    4. Getting started
      1. Launching DB2 Recovery Expert
      2. Connecting to a database
    5. DB2 configuration changes
      1. LOGRETAIN
      2. Performance
      3. USEREXIT (optional)
      4. DROPPED TABLE RECOVERY (optional)
    6. DB2 Recovery Expert tasks
      1. Create Versioning Repository
      2. Create minilogs
    7. Troubleshooting
      1. Tracing the install process
      2. The DB2 Recovery Expert log file
      3. Changing the amount of information logged
      4. Common problems
  9. Chapter 4: Managing recovery assets
    1. Backups
      1. The importance of backups
      2. Backup types
      3. Storage managers
      4. Scheduling backups
    2. Versioning Repository
      1. The importance of the Versioning Repository
      2. How to create and update the Versioning Repository
      3. When to update the Versioning Repository
      4. Backing up the Versioning Repository
    3. Minilogs
      1. The importance of minilogs
      2. How to create and update minilogs
      3. For which objects should I create minilogs?
      4. How often to update minilogs
      5. When are minilogs used?
    4. DB2 Recovery Expert metadata
  10. Chapter 5: Log analysis
    1. Introduction to log analysis
      1. What is log analysis?
      2. Prerequisites for log analysis
      3. Accessing log analysis
    2. Scenario A: Recovery using log analysis
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Recovery options without DB2 Recovery Expert
    3. The DB2 log analysis tool
      1. Getting started with the DB2 log analysis tool
      2. Analyzing changes to a single table
      3. Analyzing changes to all tables
      4. Problem resolved
    4. The command line interface: db2la
      1. Analyzing changes to the EMPLOYEE table
      2. Analyzing changes to all tables
    5. Considerations
      1. Recovery Expert quiesces the table space
      2. Recovery Expert works one row at a time
      3. Redo SQL will not necessarily be the same as the original SQL
      4. Masked update reconstruction
      5. It only shows committed transactions
      6. DATA CAPTURE CHANGES
      7. Referential Integrity
      8. GENERATED ALWAYS columns
      9. Triggers
    6. FAQ
      1. Which interface should I use?
      2. Can you find all changes made by one application?
      3. Can you find all changes made by one user (authid)?
      4. Does log analysis work with LOB data?
      5. What if the table has changed?
      6. What if other SQL is run while Undo/Redo SQL is running?
  11. Chapter 6: Point-in-time recovery
    1. Scenario B: PIT recovery if SQL has been run
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Recovery without DB2 Recovery Expert
    2. PIT recovery of a table
    3. PIT recovery of a table space
      1. UNDO SQL using the DB2 logs
      2. Restore from a backup image and roll forward
    4. PIT recovery of a database
      1. UNDO SQL using the DB2 logs
      2. Restore from a backup image and roll forward
    5. Scenario C: PIT recovery if DDL has been run
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Recovery options without DB2 Recovery Expert
    6. Recovery from Scenario C
    7. PIT recovery of DEPARTMENT table
    8. PIT recovery of ORG table
    9. PIT recovery of a table space
    10. PIT recovery of database
    11. Scenario D: PIT recovery with Referential Integrity
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Recovery without DB2 Recovery Expert
    12. Recovery from Scenario D
      1. Recovery using the DB2 RE GUI
      2. Recovery using db2la
      3. Further discussion of the effects of Referential Integrity
    13. Scenario E: PIT recovery using command line
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Recovery without DB2 Recovery Expert
    14. Recovery from Scenario E
      1. Determine table and table space IDs
      2. Recover the table image from a backup using db2ox
      3. Determine the table space directory
      4. Backup the original table data file
      5. Lock the table
      6. Copy the table data file into the table space directory
      7. Backup the table space
      8. Obtain Redo SQL
      9. Run Redo SQL
    15. Command line versus GUI
    16. Summary of DB2 vs. DB2 RE PIT recovery methods
      1. Scenario B: SQL run since PIT
      2. Scenario C: SQL and DDL run since PIT
      3. Scenario D: PIT recovery with Referential Integrity
      4. Scenario E: PIT recovery using command line
  12. Chapter 7: Dropped object recovery
    1. Scenario F: Recovery of a dropped table
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Recovery without DB2 Recovery Expert
      5. Situation before the table is dropped
      6. Recovering a dropped table using DB2 Recovery Expert (1/2)
      7. Recovering a dropped table using DB2 Recovery Expert (2/2)
    2. Scenario G: Recover a dropped table using minilogs
      1. Scenario description
      2. Prerequisites for the scenario
      3. Scenario time line
      4. Before the table is dropped
      5. Creating a minilog for the DEPARTMENT table
      6. Recovering the dropped table using minilogs (1/2)
      7. Recovering the dropped table using minilogs (2/2)
    3. Scenario H: Recovery of a dropped table space
      1. Scenario description
      2. Scenario time line
      3. Prerequisites for the scenario
      4. Without DB2 Recovery Expert
      5. Situation before the table space is dropped
      6. Recovering a dropped table space using DB2 Recovery Expert (1/2)
      7. Recovering a dropped table space using DB2 Recovery Expert (2/2)
    4. Scenario I: Recovery of a dropped database
      1. Prerequisites for the scenario
      2. Recover a dropped database using DB2 commands
    5. Using DB2 RE to undrop a database (1/2)
    6. Using DB2 RE to undrop a database (2/2)
  13. Chapter 8: Cloning a database or a table
    1. Scenario J: Cloning a database
      1. Scenario description
      2. Prerequisites for the scenario
    2. Steps to clone the database
      1. Before we start
      2. Cloning a database using the DB2 Recovery Expert GUI (1/2)
      3. Cloning a database using the DB2 Recovery Expert GUI (2/2)
    3. Scenario K: Clone a specific table
      1. Scenario description
      2. Prerequisites for the scenario
      3. Without DB2 Recovery Expert
    4. Steps to clone the table using DB2 Recovery Expert
      1. Obtain DDL for the table from the source database
      2. Create the table at the target database
      3. Obtain IDs for the table at the source and target database
      4. Get the table data file image from the backup
      5. Change the database signature in the data file
      6. Place the new data file in the target database
  14. Appendix A: Sample applications
    1. The DEMOAPP application
  15. Appendix B: Full log analysis reports
    1. Reports for the EMPLOYEE table (1/2)
    2. Reports for the EMPLOYEE table (2/2)
    3. Reports for all tables (1/7)
    4. Reports for all tables (2/7)
    5. Reports for all tables (3/7)
    6. Reports for all tables (4/7)
    7. Reports for all tables (5/7)
    8. Reports for all tables (6/7)
    9. Reports for all tables (7/7)
    10. Reports for a table with a BLOB column
  16. Abbreviations and acronyms
  17. Related publications
    1. IBM Redbooks
      1. Other resources
    2. Referenced Web sites
    3. How to get IBM Redbooks
      1. IBM Redbooks collections
  18. Index (1/2)
  19. Index (2/2)
  20. Back cover

Product information

  • Title: DB2 Recovery Expert for Multiplatforms
  • Author(s): Bart Steegmans, Mark Samson, Manish Shah
  • Release date: December 2002
  • Publisher(s): IBM Redbooks
  • ISBN: None