Using IBM DB2 UDB with IBM System Storage N series

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 Redbook 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.

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

• Integrating IBM DB2 with the IBM System Storage N series, SG24-7329-00
• DB2 9 for z/OS Performance Topics, SG24-7473-00
• IBM Enterprise Content Management and System Storage Solutions: Working Together, SG24-7558-00

Publish Date
18 December 2006

Rating: Not yet rated

Rate this book

Author(s)

Alex Osuna is a Project Leader at the International Technical Support Organization, Tucson Arizona. Poughkeepsie. He writes extensively and teaches IBM classes worldwide on all areas of storage. Before joining the ITSO, he was a Systems Engineer with Tivoli. He has been involved with storage for over 26 years and the IT industry for over 28 years, in areas of service, planning, early ship programs, Advanced Technical Support, and Systems Engineering. He holds over 10 certifications from IBM, Microsoft, and Redhat.

• Alex Osuna

Jawarhar Lal is an Alliance engineer for IBM DB2 at Network Appliance Inc, RTP, North Carolina. He holds a Masters degree in Computer Science from University of Rajasthan,Jaipur (India). Currently he is working on his MBA degree from Kenan Flagler Business School UNC Chapel Hill, North Carolina. He has been involved in storage and IT industry over 11 years, in areas of database programming, modeling, designing, administration, performance tuning and storage integration. He writes extensively on storage and databases integration. He is an IBM DB2 UDB Certified DBA and holds four other certifications from IBM and Oracle.

• Jawarhar Lal

Roger Sanders is a Senior Manager - IBM Alliance Engineering with Network Appliance, Inc. He has been designing and developing databases and database applications for more than 20 years and has been working with DB2 Universal Database and its predecessors since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition). He has written articles for IDUG Solutions Journal and Certification Magazine, authored DB2 tutorials for the IBM developerWorks Web site, presented at several International DB2 User's Group (IDUG) and regional DB2 User's Group (RUG) conferences, taught classes on DB2 Fundamentals and Database Administration (DB2 8.1 for Linux, UNIX, and Windows), and is the author of nine books on DB2 and one book on ODBC. Roger is also a member of the DB2 Certification Exam development team and the author of a regular column (Distributed DBA) in DB2 Magazine.

• Roger Sanders

Jeremy Brumer has been working with the DB2 system verification test department in the IBM Toronto Lab for the last six years. His areas of expertise include high availability solutions, and DB2's integration with N-series.

• Jeremy Brumer

ISBN

0738496820

IBM Form Number
SG24-7323-00

Number of pages
130