Using IBM DB2 UDB with IBM System Storage N series

Using IBM DB2 UDB with IBM System Storage N series

by Alex Osuna, Jawarhar Lal, Roger Sanders, Jeremy Brumer
Released December 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

Database cloning is the process by which you create an exact copy of a DB2 database, either by physically copying the data or by performing what is known as a redirected restore.

Database cloning is performed frequently by database administrators to provide near-production data for various business needs such as application development, QA testing, and report generation. Traditional methods of cloning a database pose various challenges, including system downtime and degraded system performance during the cloning process. Additionally, a large amount of storage space is required to store each clone. Furthermore, the maintenance overhead can be enormous if each cloned database requires a frequent data refresh.

This IBM Redbooks publication describes the process used to create a clone of an IBM DB2 UDB database using FlexClone technology. This book also covers creating a database clone on a disaster recovery site that has replicated data using Data ONTAP SnapMirror technology.

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 FlexClone
    1. Purpose and Scope
    2. Overview of FlexClone technology
    3. Overview of the SnapMirror technology
    4. Ensuring consistency for DB2 UDB database (suspended I/O)
    5. The db2inidb command
    6. The db2relocatedb command
    7. Advantages of cloning a database using N series FlexClone technology
    8. Configuration used for this publication
  4. Chapter 2: Preparation
    1. General assumptions
    2. Environment assumptions
    3. Security and access issues
    4. Network and storage infrastructure
  5. Chapter 3: Creating a DB2 UDB Database on an IBM N series
    1. Create containers
    2. Create an instance
    3. Create the database
    4. Change location of transaction logs
    5. Switch from circular logging to archive logging
    6. Create offline copy
  6. Chapter 4: Cloning a DB2 UDB database in the N series environment
    1. Select a database server to access the cloned database
      1. Select the production database server and database
      2. Select a database server that has a different DB2 UDB version
      3. Select a non-production server without DB2 UDB installed
    2. Clone an offline database on the same storage system
      1. Bring the source database offline
      2. Create Snapshot copies of the database FlexVol volumes
      3. Start the source database
      4. Clone the FlexVol volumes
      5. Create an export entry for the clone volume
      6. Mount the clone volumes
      7. Configuring the cloned database
      8. Catalog the source database if necessary
      9. Verify the database
    3. Clone an online database on the same storage system
      1. Bring the database into a consistent state (suspend writes)
      2. Create Snapshot copies of the database FlexVol volumes
      3. Resume normal database operations (resume writes)
      4. Clone the FlexVol volumes.
      5. Create NFS export entries for the cloned volumes
      6. Mount the cloned volumes
      7. Configuring the cloned database
      8. Verify the database
    4. Clone an offline database to a remote storage system
      1. Configure SnapMirror
      2. Initialize SnapMirror
      3. Create clones of the FlexVol volumes
      4. Create NFS export entries for the cloned volumes
      5. Mount the clone volumes
      6. Configure the cloned database
      7. Catalog the source database
      8. Verify the cloned database
    5. Clone an online database to a remote storage system
      1. Configure and initialize SnapMirror
      2. Bring the source database into a consistent state (suspend writes)
      3. Create Snapshot copies of the FlexVol volumes
      4. Resume normal database operations (resume writes)
      5. Update the SnapMirror destination
      6. Create clone volumes using Snapshot copies
      7. Create NFS export entries for the cloned volumes
      8. Mount the cloned volumes
      9. Configure the cloned database
      10. Verify the cloned database
  7. Chapter 5: Cloning a DB2 UDB database in the SAN environment
    1. Clone an offline database on the same storage system
      1. Bring the source database offline
      2. Create Snapshot copies of the FlexVol volumes
      3. Start the source database
      4. Create clone volumes using Snapshot copies
      5. Create new mapping for the LUNs.
      6. Mount the FlexClone volume LUNs
      7. Configure the cloned database
    2. Clone an online database on the same storage system
      1. Bring the source database into a consistent state (suspend writes)
      2. Create Snapshot copies of the FlexVol volumes
      3. Resume normal database operation (resume writes)
      4. Clone the FlexVol volumes using Snapshot copies
      5. Create new mapping for the LUNs
      6. Mount the LUNs that reside on the FlexClone volumes
      7. Configure the cloned database
    3. Clone an offline database to a remote storage system
      1. Configure and initialize SnapMirror
      2. Bring the database offline
      3. Create Snapshot copies of the FlexVol volumes
      4. Update the SnapMirror destination volumes
      5. Create FlexClone volumes using Snapshot copies
      6. Create new mapping for LUNs that reside on the clone volumes
      7. Mount the FlexClone volume LUNs
      8. Renaming the cloned database
    4. Clone an online database to a remote storage system
      1. Set up and initialize SnapMirror
      2. Bring the database into a consistent state (suspend writes)
      3. Create Snapshot copies
      4. Resume normal operations for the database (resume writes)
      5. Update the SnapMirror destination volumes
      6. Create clone volumes using Snapshot copies
      7. Create new mapping for LUNs that reside on the clone volumes
      8. Mount the LUN devices
      9. Configure the cloned database
    5. Conclusions
  8. Appendix A: Configuring UNIX to access cloned and source databases in an NAS environment
    1. Create a mount point for each clone volume
    2. Define mount options
    3. Change ownership
    4. Rename the clone database
    5. Check whether the database is cataloged
    6. The db2relocatedb command
  9. Appendix B: Configuring UNIX to access cloned and source databases in an SAN environment
    1. List the LUN mappings
    2. Remove the old mappings
    3. Create new mappings
    4. Bring the clone online
    5. Create Mount point
    6. Refresh the driver
    7. Obtain LUN device names
    8. Mount the LUN devices
    9. Change ownership
    10. Rename a cloned database
    11. Checking whether database is cataloged
    12. Recatalog the database
  10. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  11. Index (1/2)
  12. Index (2/2)
  13. Back cover

Product information

  • Title: Using IBM DB2 UDB with IBM System Storage N series
  • Author(s): Alex Osuna, Jawarhar Lal, Roger Sanders, Jeremy Brumer
  • Release date: December 2006
  • Publisher(s): IBM Redbooks
  • ISBN: None