IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide

IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide

by Whei-Jen Chen, Hiromichi Shinozaki, Kevin Taylor, Marcia Miskimen, Yasir Warraich
Released February 2006
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

IBM DB2 Recovery Expert for Multiplatforms provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. DB2 Recovery Expert creates and maintains additional recovery assets that you can use for intelligent analysis of both DB2 and DB2 Recovery Expert assets to find the most efficient recovery path. DB2 Recovery Expert facilitates the process of rebuilding your database assets, such as tables, indexes, and data, to a specified point-in-time, often without taking the database or the business operations offline.

This IBM Redbooks publication shows you how to install and implement DB Recovery Expert and the Fast Backup and Grouper components. It also describes the DB2 Recovery Expert assets and how to manage these assets.

In addition, this book explains the summary and detail reports of Log Analysis, including the DPF environment. It shows, in detailed examples, point-in-time recovery and cloning of tables, table spaces, and databases.

Please note that the additional material referenced in the text is not available from IBM.

Table of contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  3. Chapter 1: Introduction to DB2 Recovery Expert V2
    1. Overview of DB2 Recovery Expert
    2. Key features and enhancements with DB2 Recovery Expert V2
      1. Base features
      2. New features in DB2 Recovery Expert V2
    3. Introduction to DB2 Recovery Expert assets
      1. Versioning Repository
      2. Minilogs
      3. Log analysis
      4. Object translation
      5. Fast backup
      6. DB2 Grouper component
    4. Introduction to the recovery path concept
  4. Chapter 2: Planning for recovery
    1. Introduction to database recovery planning
    2. Database recovery
      1. Database point-in-time recovery
      2. Dropped database recovery
    3. Table space recovery
      1. Table space point-in-time recovery
      2. Dropped table space recovery
    4. Table level recovery
      1. Table point-in-time recovery
      2. Dropped table recovery
    5. Row-level recovery
    6. Other object recovery
    7. Log mining
  5. Chapter 3: Installing and configuring DB2 Recovery Expert
    1. Installation requirements for DB2 Recovery Expert
    2. Before you begin the installation process
      1. DB2 configuration requirements
      2. Space planning for DB2 Recovery Expert
    3. Installing DB2 Recovery Expert
      1. Installing DB2 Recovery Expert on AIX in GUI mode
      2. Installing DB2 Recovery Expert using the command line
      3. Reinstalling DB2 Recovery Expert
      4. Uninstalling DB2 Recovery Expert
    4. Configuration tasks
      1. Customizing the recex.properties file (1/2)
      2. Customizing the recex.properties file (2/2)
      3. Creating the Versioning Repository
      4. Creating the Archive Log Inventory Data
      5. Space planning for DB2 Recovery Expert and recovery assets
    5. Troubleshooting
      1. Troubleshooting the installation
      2. Troubleshooting DB2 Recovery Expert
      3. Using online help and finding error messages
  6. Chapter 4: Creating and managing recovery assets
    1. Backups
      1. The importance of backups
      2. Backup types
      3. Tivoli Storage Manager and other vendor libraries
      4. Scheduling backups
    2. Versioning Repository
      1. The importance of the Versioning Repository
      2. Creating the Versioning Repository
      3. Updating the Versioning Repository
      4. When to update the Versioning Repository
      5. Backing up the Versioning Repository
      6. Pruning the Versioning Repository
      7. Rebuilding the Versioning Repository
      8. Extracting DDL from the Versioning Repository
      9. Versioning Repository usage checklist
    3. Minilogs
      1. The importance of minilogs
      2. Creating and updating minilogs
      3. For which objects should I create minilogs
      4. When to update minilogs
      5. When to use minilogs
      6. Creating minilogs for a single table
      7. Creating minilogs for all the tables in a table space
      8. Directory path for minilogs
    4. Archive Log Inventory Data (DB2 RE metadata)
      1. Overview of ALID or metadata
      2. Creating and updating the ALID
      3. Rebuilding the ALID
  7. Chapter 5: Log analysis
    1. Log analysis for auditing
      1. Prerequisites for log analysis for auditing
      2. Analyzing changes to a table, a sample scenario (1/2)
      3. Analyzing changes to a table, a sample scenario (2/2)
    2. Log analysis for undoing or backing out table changes
      1. Scenario description
      2. Prerequisite for undoing or backing out SQL
      3. Undoing or backing out INSERTs or DELETEs
      4. Undoing or backing out updates
    3. Log analysis using the command line
      1. Which interface is better
    4. Performing remote log analysis
      1. Prerequisites for remote log analysis
      2. Cataloging a remote node and database
      3. Remote Analysis using DB2 Recovery Expert GUI
      4. Remote log analysis using db2la
    5. Report types and interaction of time and log options
      1. General report and detailed report
      2. Time specifications and Log file options and precedence
    6. Log analysis in a DPF environment
      1. Analyzing changes to the table
      2. Switching between nodes
    7. Considerations and recommendations
      1. Recovery scenarios without DB2 Recovery Expert
      2. Data capture changes
      3. Only shows committed transactions
      4. Masked update reconstruction
      5. Generated always columns
      6. DB2 Recovery Expert can quiesce the table space
      7. DB2 Recovery Expert works one row at a time
      8. Log analysis for tables with LOBs
      9. Triggers and referential integrity
      10. What if data has changed
  8. Chapter 6: Backing out insert, update, and delete operations
    1. Point-in-time recovery of a table after running DDL
      1. Prerequisites for this scenario
      2. The time line for this scenario
      3. Details of activity against table
      4. Recovering the table to a point-in-time
      5. Recovery options without DB2 Recovery Expert
    2. Recovering table space to point-in-time when DDL has been run
      1. Prerequisites for Scenario
      2. Scenario time line
      3. Details of activity against table space
      4. Recovering table space to a point-in-time
      5. Recovery options without DB2 Recovery Expert
    3. Point-in-time recovery of table in a DPF environment
      1. Scenario, time line, and details of activity against the table
      2. Recovering a table to point-in-time in a DPF environment (1/2)
      3. Recovering a table to point-in-time in a DPF environment (2/2)
      4. Recovery options without DB2 Recovery Expert
    4. Recovering a database to point-in-time when DDL has been run
      1. Scenario time line
      2. Details of activity against the database
      3. Recovering a database to a point-in-time
    5. Redirected restore using DB2 Recovery Expert
      1. Prerequisites for the scenario
      2. Scenario time line
    6. Point-in-time recovery with referential integrity and DB2 Grouper
      1. Scenario description
      2. Prerequisites and environment for the scenario
      3. Time line for scenario
      4. Recovery steps (1/4)
      5. Recovery steps (2/4)
      6. Recovery steps (3/4)
      7. Recovery steps (4/4)
  9. Chapter 7: Recovering dropped objects
    1. Prerequisites for recovering dropped objects
      1. Updating the Versioning Repository and taking full, offline table space or database backup
      2. Updating the ALID or metadata
    2. Recovering a dropped table
      1. Scenario description
      2. Recovering a dropped table using DB2 Recovery Expert (1/2)
      3. Recovering a dropped table using DB2 Recovery Expert (2/2)
      4. LOB and long field considerations
      5. Dropped table recovery options without DB2 Recovery Expert
    3. Recovering a dropped table space
      1. Scenario description
      2. Recovering a dropped table space with DB2 Recovery Expert (1/2)
      3. Recovering a dropped table space with DB2 Recovery Expert (2/2)
      4. Recovering dropped table space without DB2 Recovery Expert
      5. Restrictions with table space recovery
    4. Recovering a dropped database
      1. Prerequisites for recovering a dropped database
      2. Recovering a database using DB2 commands
      3. Recovering a database using DB2 Recovery Expert (1/2)
      4. Recovering a database using DB2 Recovery Expert (2/2)
  10. Chapter 8: Cloning a database, table space, or table
    1. Cloning a database
      1. Details of this scenario
      2. Prerequisites for the scenario
      3. Creating a clone of a database (1/2)
      4. Creating a clone of a database (2/2)
    2. Introducing the Object Translation tool db2ox
      1. Object Translation Tool constraints
      2. Cloning using the object translation tool
    3. Object translation help text
    4. Cloning a table space or table using db2ox
      1. Cloning a table space
      2. Scenario to clone a table space that contains three tables
      3. Error scenarios with db2ox in table space recovery mode
      4. Cloning a table
      5. Scenario to clone a table
      6. Extracting data for several tables at once using db2ox
      7. Restriction using the IXF file generated from db2ox
      8. Using sample program EasyOX to automate cloning tables
  11. Chapter 9: Fast Backup
    1. About DB2 Recovery Expert Fast Backup
      1. Fast Backup module structure
      2. Backup process
      3. Restore process
    2. Planning SAN network storage configuration
      1. Planning SAN volume configuration
      2. Assigning SAN volume to the system
    3. Fast Backup environment preparation
      1. Description of the lab environment
      2. Configuring network storage, IBM ESS
      3. Configuring volumes on the system -AIX
      4. Installing Fast Backup Server and Client (1/2)
      5. Installing Fast Backup Server and Client (2/2)
      6. Preparing Fast Backup, Fast Backup Administration (1/2)
      7. Preparing Fast Backup, Fast Backup Administration (2/2)
    4. Scenario A: Recovering a table space
      1. Scenario description
      2. Prerequisites for the scenario
      3. Backing up a table space through the Fast Backup client GUI
      4. Recovering a table space to recover deleted data from a table
    5. Scenario B: Recovering a database on the multiple network storage volumes
      1. Scenario description
      2. Managing Fast Backup Administration
      3. Using the Fast Backup command line interface
      4. Recovering a database
    6. Considerations about Fast Backup use
      1. Point-in-time of Fast Backup
      2. Recovery paths of DB2 Recovery Expert
      3. DB2 Recovery Expert Fast Backup troubleshooting
  12. Chapter 10: Installing and using the DB2 Grouper component
    1. Overview of DB2 Grouper
      1. How DB2 Grouper works with DB2 Recovery Expert
      2. Making DB2 Recovery Expert aware of DB2 Grouper sets
    2. Installing the DB2 Grouper component
      1. Installing the DB2 Grouper server
      2. Installing the DB2 Grouper client
    3. Using the DB2 Grouper component
      1. Binding the DB2 Grouper packages
      2. Using the DB2 Grouper launchpad (1/5)
      3. Using the DB2 Grouper launchpad (2/5)
      4. Using the DB2 Grouper launchpad (3/5)
      5. Using the DB2 Grouper launchpad (4/5)
      6. Using the DB2 Grouper launchpad (5/5)
      7. Creating DB2 Grouper sets for DB2-enforced referential integrity (1/2)
      8. Creating DB2 Grouper sets for DB2-enforced referential integrity (2/2)
  13. Appendix A: Sample applications
    1. Fast Backup sample applications
      1. The DEMOSPACE application
  14. Appendix B: Log Analysis reports
    1. Excerpt from general report created by db2la
    2. Excerpt of detailed report created by db2la
    3. Excerpt of the undo SQL
    4. DDL of VPS.CAR table
  15. Appendix C: Additional material
    1. Locating the Web material
    2. Using the Web material
      1. System requirements for downloading the Web material
      2. How to use the Web material
  16. Abbreviations and acronyms
  17. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  18. Index (1/2)
  19. Index (2/2)
  20. Back cover

Product information

  • Title: IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
  • Author(s): Whei-Jen Chen, Hiromichi Shinozaki, Kevin Taylor, Marcia Miskimen, Yasir Warraich
  • Release date: February 2006
  • Publisher(s): IBM Redbooks
  • ISBN: None