A10 - Restoring 43TB and Applying 2.2 Billion of DB2 Log Records Within 4 Hour

Session Number: 4053
Track: DB2 for z/OS - I
Session Type: Podium Presentation
Primary Presenter: Bjarne Nelson [UBS AG]
Time: May 03, 2017 (09:20 AM - 10:20 AM)
Room: South Ballroom

Session Code: 4164
Audience experience level: Intermediate, Advanced
Presentation Category: Select a Value
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Data Architects, Database Administrators, Systems Programmers, IT Managers
Technical areas this presentation will apply to: Select a Value
If Tools and Utilities was selected which products: BMC Recovery+ is part of the solution presented
Objective 1: Managing the RTO Objective – Defining Spec's and Requirements
Objective 2: The different dimensions of Big and what the system setup looks like
Objective 3: Being able to perform simulation in a production environment to understand if you can truly meet your RTOs
Objective 4: Mission accomplish: Performing point in time recovery simulation with a RTO of less than 4 hours
Objective 5: Lessons learned around DB2 Object Level FlashCopy and things to keep in mind

Abstract:  Most IT installations have Recovery Time Objectives (RTOs) in place for business critical applications, but proving that such objectives can be met is not always a given. In particular, for worst case scenarios like recovery to a Point in Time (PIT), which is entirely different challenge than fail over to a secondary site.<br />Challenges involve defining and validating subsets of data as you may not have time to recover everything, at least not in the first wave. As such you must focus on what is really required to support truly business critical functions to operate. Secondly you may have to acquire and deploy new technologies to address the need for speed to meet aggressive RTOs. As you start deploying new technologies you’ll learn what works, but more importantly also identify implied pitfalls and understand how to work around them. Finally, you’ll have to prove that everything works as designed and that RTOs can actually be met, which evidently means simulating such PIT recovery scenarios on a live production system while you are still serving your normal business operating in a 24 by 7 all year round modus.<br />Through this presentation you'll get an understanding about how this was achieved at UBS in terms of well-defined processes and deploying state of the art technology both on the hardware side as well software side<br />• Managing the RTO Objective – Defining Spec's and Requirements<br />• The different dimensions of Big and what the system setup looks like<br />• Mission accomplish: Performing point in time recovery simulation with a RTO of less than 4 hours<br />• Lessons learned and things to keep in mind