B12 - Cloning Objects in DB2 for z/OS

Session Number: 3416
Track: DB2 for z/OS - II
Session Type: Podium Presentation
Primary Presenter: Steve Thomas [CA Technologies]
Time: May 25, 2016 (02:15 PM - 03:15 PM)
Room: Trinity B

Speaker Bio: Steve is a Senior Engineering Services Architect at CA Technologies. In this role he reports into the R&D organization and ensures customers get the most out of their tools as well as helping influence future product strategy and direction. Steve has been a DB2 Specialist for over 25 years, an IBM Champion for Information Management since 2009 and is a regular speaker at User Groups across Europe and beyond. He has been a member of the Conference Planning Committee for IDUG EMEA for 10 years and was Chair of the 2015 Conference in Dublin.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Data Management, Emerging Technology, Implementing New DB2 Releases and Features, Managing Availability, Managing Database Resources
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), High Availability (DB2 for z/OS), New Release (DB2 for z/OS)
If Tools and Utilities was selected which products: Generic use of utilities wand hardware capabilities but with no specific vendor in mind
Objective 1: Understand the options available to create copies or clones of DB2 objects
Objective 2: Understand what can be done to speed up the process using each option
Objective 3: Exploiting Hardware technology (such as Flashcopy) to create such copies
Objective 4: Understand the impact of compliance and other regulations and provide some things to think about if copying data from Production databases
Objective 5: Delegates will come away from the session with a lot of options they can try out in their own shops to improve such processing

Abstract:  Being asked to Clone or create an exact copy of a database or set of DB2 for z/OS objects is a very common requirement. This session will provide a set of detailed hints, tips and examples which will allow you to accomplish this task quickly and efficiently. We’ll cover things you can do when creating the DDL for the target object which can significantly improve the speed of the data copying process, as well as a range of options for handling the data itself, ranging from using Service Aids such as DSN1COPY through various Utilities though to more advanced hardware based techniques such as Flashcopy and equivalents. We’ll also touch on other topics that may need to be considered including compliance requirements such as Masking, Referential Integrity, Versioning, Row formats, Storage requirements, DB2 CLONE objects and more.