April 23 SIRDUG Meeting Featuring Terry Purcell

Download Terry's presentations

To download the New version of "DB2 for z/OS Optimizer: What have you done for me lately?" click here

To download the "Tuning your SQL to get the most out of zIIPs" click here

To download the "Stabilizing Access Paths Across Rebind" click here

To download the "DB2 9 for z/OS Optimizer Enhancements" click here

Meeting Details

WHEN? April 23 (Thursday)

IBM Harris Blvd facility (Charlotte, NC) - See directions below

COST? $20 cash or check, per day, at the door.
We do not accept credit cards.

Meeting Agenda

April 23
Featured Speaker - Terry Purcell

 8:00 -  9:00  -  Registration - Coffee, Danish, and Networking
 9:00 - 10:15  -  Terry Purcell "Stabilizing Access Paths Across Rebind "
10:15 - 10:30  -  Mid-Morning Break
10:30 - 11:45  -  Terry Purcell "DB2 z/OS Optimizer: What have you done for me lately? "
11:45 - 12:45  -  Lunch 
12:45 -  1:55  -  Terry Purcell  "Tuning your SQL to get the most out of zIIPs" 
 1:55 -  2:05  -  Mid-Afternoon Break and chat with Terry
 2:05 -  3:15  -  Terry Purcell  "TBD"
 3:15 -  3:30  -  ?
 3:30 -  4:00  -  Networking, Adjourn 


To pre-register please use our new online registration form at:
meeting registration form
email registration@sirdug.org and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

If you do not wish to continue receiving these occasional notices, please indicate that in your registration email.
Pre-registration must be completed by Midnight, Friday, April 17th. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.

Directions to the meeting site:

The meeting is in the IBM Harris Blvd facility
8501 IBM Drive, Bldg 301

North bound on I-77 (from the Rock Hill direction): Turn right onto I-85 North and follow next directions.

On I-85 (coming from either direction): Take exit 45B onto Harris Blvd. West Turn Left at 2nd stop light onto IBM Drive and follow directions below.

South bound on I-77 (from the Statesville direction) Turn left onto Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th stop light (counting the one at top of I-77 ramp) Turn Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).

Once on IBM Drive, Turn Right at 2nd drive. Look for the SIRDUG parking sign on the right side of the road. We are to park in the lower visitor parking lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria Conference Room.

Terry Purcell Biography

Terry Purcell is a senior software engineer in the DB2 for z/OS SQL Query Technology Team with the IBM Silicon Valley Lab. Terry has more than 13 years experience with DB2 in Database Administration and application development, and is a regular speaker on SQL performance and query optimization at DB2 conferences worldwide.

Technical Sessions

These are all focused on DB2 for z/OS.

Stabilizing Access Paths Across Rebind
Every new DB2 release, maintenance upgrade, or just running RUNSTATS brings the opportunity for changes in access paths after your next static SQL rebind or dynamic SQL execution. Even though the vast majority of SQL shows equal or better performance, we are still measured on the number of failures rather than successes. How can you safeguard yourself against access path regression so that you don't dread the upcoming migration/maintenance?

Causes of access path instability
Limiting exposure to instability
Access Path Backup

DB2 z/OS Optimizer: What have you done for me lately?
You can always read about the features/enhancements of a new release, such as DB2 9 for z/OS, in the manuals, in redbooks or by attending highlight presentations. But what you generally miss from these sources is the answer to your question, "Why do I care about these enhancements?". And if there is one key DB2 focal area that needs extra explanation, it is the optimizer. This presentation will deep dive into some of the key SQL performance enhancements delivered recently in DB2 for z/OS.

Highlights in DB2 V8 for SQL performance and optimization
New enhancements in DB2 V8
DB2 9 enhancements added to DB2 V8
Highlights in DB2 9 for SQL performance and optimization
Less publicized enhancements in DB2 9

Tuning your SQL to get the most out of zIIPs
The largest percentage of zIIP redirect is reserved for the parallel child tasks of your queries. So how do you encourage your queries to run in parallel? This session will focus on the table and index design requirements to exploit parallelism in DB2 V8 and DB2 9 for z/OS.

If you have any links that you would like to see on our pages, send SIRDUG an EMAIL using our mail box below.


SIRDUG Home Page

Last Update: April 24, 2009

Copyright 2009 SIRDUG Inc. All rights reserved.