I developed a process to clone Db2 systems based on a Rdbook: SAP on DB2 for z/OS and OS/390: DB2 System Cloning ( https://www.redbooks.ibm.com/abstracts/sg246287.html ). Works to this day. Easiest method is with the source Db2 down but if you are adventurous, it can be done with a running source system. Basically build a target system, blow away all the non system data, flash the source system to the target system (rename source to target HLQ) then massage the target catalog. One thing I have found over the years is that it works best with source down and sortwork databases dropped. Redefine when you bring the source back up.
Regards, Ron Eddinger -----Original Message----- From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Lance D. Jackson Sent: Friday, November 4, 2022 4:05 PM To: [email protected] Subject: Re: Db2 z/OS Subsystem Cloning Thanks Mike. -----Original Message----- From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Mike Schwab Sent: Friday, November 4, 2022 15:58 To: [email protected] Subject: Re: Db2 z/OS Subsystem Cloning Suspend PPRC, copy selected datasets, restart PPRC? Restore from replicated VTape? On Fri, Nov 4, 2022 at 12:57 PM Lance D. Jackson <[email protected]> wrote: > > Can anyone suggest some approaches to cloning a subsystem w/o the use > of a tool? A client a sandbox environment where DDL changes are made, > and rather than rollback the changes, they'd rather revert the entire > subsystem to a prior point in time. BACKUP SYSTEM & RESTORE SYSTEM > were my first consideration, but I'm not sure if this is the most > efficient approach. Any ideas would be appreciated. > > Lance J. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected] with the message: INFO IBM-MAIN -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the contents are safe. When in doubt, report it. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
