IDUG DB2 Tech Conference in Sydney, Australia 2014
Sydney, Australia
10 - 12 September, 2014

View Printable Version

'DB2 11 Mash-up : Utilities, Optimisation and Extension of the LRSN / RBA'

Session Number: 3056
Track: z/OS Track
Session Type: Podium Presentation
Primary Presenter: Florence Dubois [IBM UK Ltd]
Co-Presenter: Terry Purcell [Senior Technical Staff Member - IBM Silicon Valley Lab]
Co-Presenter 2: John Campbell [Distinguished Engineer - IBM DB2 for z/OS Development]

1.13S => Fri, Sep 12, 2014 (08:30 AM - 11:45 PM)

Speaker Bio: Florence Dubois is an IBM Certified Consulting IT Specialist and a member of the DB2 for z/OS Development SWAT team. In this role, she consults for worldwide customers on a variety of technical topics, including implementation and migration, design for high performance and availability, performance and tuning, system health checks, disaster recovery. Florence presents regularly at conferences and has co-authored several IBM Redbooks publications.

Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the DB2 for z/OS Optimizer. Terry has 2 decades of experience with DB2 in Database Administration and application development as a customer, consultant and DB2 developer.

John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.
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: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), Disaster Recovery (DB2 for z/OS), High Availability (DB2 for z/OS), New Release (DB2 for z/OS)
Objective 1: Understand key new features of DB2 for z/OS utilities being delivered in DB2 11

Objective 2: See how to take advantage of new features to simplify DBA processing, reduce operational costs and improve application availability

Objective 3: Learn about query performance improvements that can improve performance for your DB2 applications

Objective 4: Understand the extended RBA/LRSN format and the implications for the DBA
Objective 5: Share best practices on migration to the new log record format

Abstract:  DB2 11 for z/OS is jam packed with query performance improvements: predicate rewrites to improve indexability, hash join optimizations, duplicate removal enhancements, DPSIs, subqueries..... It also delivers major new utilities capabilities in terms of availability, performance and function. This half-say seminar will give an overview of what is new in query performance and the DB2 11 for z/OS Utilities Suite. It will also discuss the extended RBA/LRSN format and its implications for the DBA, and share best practices on migration to the new log record format.

For questions or concerns about your event registration, please contact