The Online Schema (R)evolution

Session Number: 2138
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Steve Thomas [Principal Software Consultant - BMC Software]
Time: Nov 15, 2011 (08:30 AM - 09:30 AM)
Room: Leo

Speaker Bio: Steve is a Principal Consultant at BMC Software, and supports customers across the UK, Northern Europe, Greece, Turkey and Israel. He has been a DB2 specialist since 1989 and an IBM Information Champion since 2009. Steve has presented on a wide range of topics at events across the UK and in Europe. He helps organize the UK DB2 RUG and has been a member of the IDUG EMEA Conference Planning Committee for the past 5 years.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Data Architects, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: High Availability (DB2 for z/OS), New Release (DB2 for z/OS), Tools and Utilities
If Tools and Utilities was selected which products: Online Reorganziation Utilities
Objective 1: Explain the limitations in OLS capabilities provided in previous releases of DB2
Objective 2: Describe what has been delivered in DB2 10 for z/OS with the new Deferred Alter capability
Objective 3: Discuss how to use the new feature in a real life environment including overcoming any pitfalls or gotchas that may not be obvious from the release notes
Objective 4: Provide an Online Schema Change Checklist that delegates can use back at the ranch
Objective 5: What's still missing and what may be coming next (bearing in mind that I don't work for IBM!)

Abstract:  The latest improvements in Online Schema capabilities introduced in DB2 10 for z/OS represent something more like a Revolution rather than an enhancement to the OLS Evolution capabilities we've been used to seeing in successive releases of DB2. For the first time DBAs can register the changes they wish to make and then implement them at a time of their choosing using an Online Utility rather than having the object concerned move into an Advisory Status which may cause serious Performance Issues or worse. This session will describe the new OLS capabilities, how to use them and some pitfalls which may not be immediately obvious when you read the new features list. Come and listen to the way of the future as far as making Changes to your DB2 database structures is concerned!