IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

What's new from the optimizer in DB2 10 for z/OS?

Session Number: 1985
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Terry Purcell [IBM Silicon Valley Lab]
Time: Nov 14, 2011 (01:30 PM - 02:30 PM)
Room: Tycho

Speaker Bio: Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he works on the design and development of 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.
Audience experience level: Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Technical areas this presentation will apply to: New Release (DB2 for z/OS)
Objective 1: Learn 1 thing about DB2 10
Objective 2: Learn a 2nd thing
Objective 3: Learn a 3rd thing
Objective 4: Learn a 4th thing
Objective 5: Learn a 5th thing

Abstract:  DB2 10 for z/OS is no exception to the goal of delivering incremental query optimization enhancements to the world‚Äôs most respected cost based optimizer. And as delivery of DB2 10 draws closer, the plan solidifies, and beta customer and internal measurement feedback is more readily available. This presentation will share the insight uncovered in the early usage, provide the motivation for each enhancement, and highlight that actual enhancements including: ‚Ä¢ enhanced plan management, ‚Ä¢ ‚Äúsafe‚Äù query optimization, ‚Ä¢ improvements to complex OR and IN list processing, ‚Ä¢ RUNSTATS management and performance improvements, ‚Ä¢ and more!

For questions or concerns about your event registration, please contact