DB2 Night Show What's new from the optimizer in DB2 10 for z/OS by Terry Purcell

Event Details

DB2 Night Show  What's new from the optimizer in DB2 10 for z/OS by Terry Purcell

Time: May 23, 2011 from 10am to 11am
Location: 10am Central / 17:00 hrs CET
Website or Map: http://bit.ly/TerryPurcell
Event Type: edition, #04:, db2, 10, optimiser, optimization
Organized By: Surekha Parekh
Latest Activity: Jan 22, 2016

Export to Outlook or iCal (.ics)

Event Description

Monday 23 May 2011 at 10am CDT -

What's new from the optimizer in DB2 10 for z/OS by Terry Purcell

Register Now


In episode #4 of The DB2Night Show z/OS Edition, 


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. With skip-release migration supported, it is expected that many more customers may adopt DB2 10 in the coming year - so understanding the performance enhancements can be critical for those customers. This presentation will share the insight uncovered from beta customer and early adopters, and provide the motivation for each enhancement including:
·    “safe” query optimization,
·    improvements to complex OR and IN list processing,
·    RUNSTATS management and performance improvements,
·    and more!

Comment Wall

Add a Comment

RSVP for DB2 Night Show What's new from the optimizer in DB2 10 for z/OS by Terry Purcell to add comments!

Join The World of DB2

Comment by Surekha Parekh on April 28, 2011 at 19:51
sometimes there appears to be some confusion regarding registering for webcast , remember you need to register using this URL http://bit.ly/TerryPurcell

Attending (48)

Might attend (11)

Not Attending (2)

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

Forum

Automatic storage add path

Started by Fernando Monjes in What's hot ? Feb 12. 0 Replies

Hi I have db2 version 10 and tablespace (dms) with automatic storage, how can I add a container or path, I don't use STOGROUP, is there any option? Thank youContinue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Gagan Kakkar Feb 12. 3 Replies

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service