Using IBM DB2 UDB with IBM System Storage N series

An IBM Redbooks publication

Published 18 December 2006

cover image

ISBN-10: 0738496820
ISBN-13: 9780738496825
IBM Form #: SG24-7323-00
(130 pages)

Authors: Alex Osuna, Jawarhar Lal, Roger Sanders, Jeremy Brumer


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

Chapter 1. Introduction to FlexClone
Chapter 2. Preparation
Chapter 3. Creating a DB2 UDB Database on an IBM N series
Chapter 4. Cloning a DB2 UDB database in the N series environment
Chapter 5. Cloning a DB2 UDB database in the SAN environment
Appendix A. Configure a UNIX host to access both the clone and the source databases in a NAS environment
Appendix B. Configure a UNIX host to access both the clone and the source databases in a SAN environment

Follow IBM Redbooks

Follow IBM Redbooks