October 20 SIRDUG Meeting Featuring Terry Purcell



Meeting Details

WHEN? October 20 (Thursday)

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

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


Meeting Agenda

October 20
Featured Speaker - Terry Purcell

 8:00 -  9:00  -  Registration - Coffee, Danish, and Networking
 9:00 - 10:15  -  Terry Purcell "Can my WHERE clause use an index?"
10:15 - 10:30  -  Mid-Morning Break
10:30 - 11:45  -  Terry Purcell "What statistics are required by the DB2 optimizer?"
11:45 - 12:45  -  Lunch 
12:45 -  1:55  -  Terry Purcell  "How to Tune SQL Like an Expert in DB2 V8" 
 1:55 -  2:05  -  Mid-Afternoon Break and chat with Terry
 2:05 -  3:15  -  Terry Purcell  "Query Tuning When You Can't Change the SQL (indexing, clustering, partitioning)"
 3:15 -  3:30  -  Business meeting and installation of officers for 2006
 3:30 -  4:00  -  Networking, Adjourn 

Registration

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, October 14th. 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

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


"How to tune SQL like an expert"
Can my WHERE clause use an index?

A prominent DB2 consultant once said, “The 3 most important aspects of SQL performance are filtering, filtering, and filtering”. The first part of this session will focus on what elements of a SQL statement allow this filtering to occur by explaining the topics of index matching, screening, stage 1 and stage 2 predicates with V7 and V8 differences highlighted.

"What statistics are required by the DB2 optimizer?"
This presentation will help you answer the question: What statistics do I need to collect and why? To ensure the DB2 optimizer has all information to determine the most efficient access path. In addition, basic costing of the various single table and multi-table join methods will be covered.

"Why did the optimizer choose that access path?"
One of the most pressing questions for SQL performance is: Why did the optimizer choose the wrong access path? Before DB2 V8, you had to be an optimizer expert to answer that question. This presentation will outline a method to utilize the extensive access path detail available with V8 Visual Explain and compare with the actual reality for a given query. The end result is that you will be able tune SQL like an expert.

"Tuning SQL when you can’t change the SQL"
Sometimes you can’t change the SQL, because it’s adhoc, or from an ERP, it’s a legacy application, or nobody wants to touch it!!!! Once statistics accurately represent the data and the “best available” access path is chosen, then there are physical design decisions that can be made to help boost runtime performance further. Indexing, partitioning and clustering will be discussed and how to exploit these, with the objective of maximizing filtering and reducing I/O.


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: October 2, 2005

Copyright © 2005 SIRDUG Inc. All rights reserved.