April 23 SIRDUG Meeting Featuring Terry Purcell
WHEN? April 23 (Thursday)
WHERE?
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.
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
or
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.
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 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.
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
REOPT
Hints
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.
To download the New version of "DB2 for z/OS Optimizer: What have you done for me lately?"
click here