At our company, we've developed the expertise to perform DB2 cloning operations "manually". The original poster needs to read the Redbook mainly to find out how big an effort he is undertaking. Cloning DB2 is perfectly possible, but is complex. For example, it is probably going to be necessary to prepare the DB2 environment so that cloning is possible (separate high level qualifiers, MVS catalogs, volumes, etc). Once an environment is prepared, then DB2 cloning lends itself to scripting and can be repeatedly and easily done - at least from my perspective as an observer of other people who know what they are doing who are actually doing it.
I would think that once one understands how large an undertaking cloning a DB2 environment is, then one could assess the value proposition of utilizing a tool to assist in the process. As pointed out below, IBM offers a tool, and I think there are several third party vendor alternatives as well. Brian On Wed, 23 May 2007 16:22:00 +0900, Timothy Sipples wrote: >Brian Peterson writes: >>Check out IBM Redbook "SAP on DB2 for z/OS and OS/390: DB2 System >>Cloning". >>http://www.redbooks.ibm.com/abstracts/sg246287.html > >This is a very good redbook but bear in mind it was written over 5 years >ago, and we've had a couple DB2s since then (now V9). Another thing that's >changed is that IBM has the DB2 Cloning Tool for z/OS out now. But it's >good background reading, certainly, and (mostly) still very useful. > >- - - - - >Timothy Sipples >IBM Consulting Enterprise Software Architect >Specializing in Software Architectures Related to System z ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
