This IBM Redbooks publication shows the different techniques customers can use to clone their DB2 system. Although the scenarios in the book use an SAP workload, the DB2 cloning techniques we describe are not specific to SAP. Those techniques can apply to any DB2 system and the applications running on that DB2. The book describes hands-on details of selected DB2 database cloning scenarios, typically the most popular techniques currently used by customers, as well as the most efficient scenarios we would like to recommend to DB2 database administrators.

The scenarios described in this book are based on SAP examples. Our source system resides on a DB2 data sharing group. We have one target system residing on another DB2 data sharing group and one residing on a non-data sharing DB2. All source and target systems are in the same OS/390 Sysplex environment.

We discuss and show DB2 system cloning techniques using the following methods:

- ESS Flashcopy

- DFSMS copy and rename

The book addresses an audience with in depth knowledge of DB2 for z/OS and OS/390 database administration and savy in SAP system requirements.

Ch. 1 Introduction to SAP homogeneous system copy

Ch. 2 Planning for DB2 system cloning

Ch. 3 Designing the DB2 system cloning

Ch. 4 Scenario 1 - FlashCopy with suspended DB2

Ch. 5 Scenario 2 - DFDSS copy with offline DB2

App. A JCL for Scenario 1 - FlashCopy with suspended DB2

App. B JCL for Scenario 2 - DFDSS copy with offline DB2

App. C REXX procedures