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

Event Details

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

Time: January 30, 2018 from 11am to 12pm
Location: VIRTUAL WEBCAST - Timezone EST
Website or Map: http://ibm.biz/30JanDb2Webcast
Event Type: webcast, db2z., replay, surekha, terrypurcell
Organized By: Surekha Parekh
Latest Activity: Jan 30

Export to Outlook or iCal (.ics)

Event Description

Title: What's new from the optimizer in DB2 12 for z/OS?
Speaker Terry Purcell.  STSM, IBM Master Inventor 
Date: 30th January 20018
Time: 11:00 AM EST   (4PM - GMT)
LIVE Q&A session with Terry!
DIRECT URL for webcast series :

This webcast will be presented by Terry Purcell - IBM Db2 for z/OS 

STSM and IBM Master Inventor . Terry will be presenting the latest news and updates from the Db2 Optimizer in Db2 12.

The performance focus from DB2 10 and 11 for z/OS has resonated very well with customers, and DB2 12 for z/OS takes this further to deliver significant performance improvements to new query workload patterns, and for improved scalability of your existing applications. This session will highlight the UNION ALL and outer join performance improvements, sort optimizations, improved predicate indexability and tighter integration of the Optimizer and RUNSTATS. And you will learn how these and other enhancements can enable improved exploitation of other DB2 features such as temporal or archive transparency, and allow analytics and other processing on real-time data with minimal impact to your operational systems.


Comment Wall

Add a Comment

RSVP for What's new from the optimizer in DB2 12 for z/OS? to add comments!

Join The World of DB2

Attending (26)

Might attend (6)

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted by Paul McWilliams on May 22, 2018 at 21:25 0 Comments

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in…



  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service