June 12 SIRDUG Meeting Featuring Patrick Bossman & Roger Rea
WHEN? June 12 (Thursday)
For detailed directions click here
COST? $20 cash or check, per day, at the door.
We do not accept credit cards.
Featured Speakers - Patrick Bossman & Roger Rea
There will be parallel sessions for DB2 for z/OS and DB2 for LUW.
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 9:10 - Announcements
9:10 - 10:20 - Patrick Bossman - Introduction to query optimization
9:10 - 10:20 - Roger Rea - solidDB part 1
10:20 - 10:40 - Break
10:40 - 11:50 - Patrick Bossman - What Statistics Does Optimizer need
10:40 - 11:50 - Roger Rea - solidDB part 2
11:50 - 12:50 - Lunch
1:00 - 2:10 - Patrick Bossman - Tuning Queries with Optimization Service Center
1:00 - 1:45 - Roger Rea - DB2 Best Practices
2:10 - 2:40 - Break
2:40 - 3:50 - Patrick Bossman - Control your destiny with optimization hints
To pre-register please use our new online registration form at:
meeting registration form
email firstname.lastname@example.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, June 6th. 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).
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
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 2stop light onto IBM Drive and follow
the 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
Patrick Bossman has been working with DB2 since 1993. During
1993 - 1999 Patrick was a user of DB2 and progressed through a
variety of jobs and responsibilities including applications developer,
database administrator, then complex SQL writer a query tuner for a
data warehouse. Patrick joined IBM in 1999 as a DB2 Advocate and
initially traveled and assisted customers with query tuning. Since 2000,
Patrick has worked for DB2 for z/OS Optimizer development. Patrick's
responsibilities are assisting development and service in diagnosing
and solving query performance problems - either through user action,
or improvement to the optimizer. Patrick also was involved as the
scenario architect of Optimization Service Center and Optimizer Expert
query tuning tools. Patrick has inventions in the optimization areas
of query transformation, statistics advisor, and visual plan hint.
Introduction to query optimization
This presentation is an overview of query optimization. It discusses
what features and techniques are applied by the DB2 optimizer in
transforming and costing the available access paths, and how a DB2
parallelizes a query. This is a broad overview of query optimization
What Statistics Does Optimizer need
The DB2 for z/OS optimizer is a cost based optimizer. The foundation of
cost based optimization is estimating the number of rows qualified at
different stages of query execution (index matching, total index
filtering, table filtering, join size, etc). This presentation is a
deep dive into the different statistics available within DB2 and how
the DB2 optimizer uses the different complementary statistics to
accurately cost the candidate access paths.
Tuning Queries with Optimization Service Center
Optimization Service Center (OSC) is workstation tool to assist with
the identification, analysis, and tuning of problem queries. This
presentation will highlight features available to help users tune
- Workload Statistics Advisor
Within Optimization Service Center, you can define query workloads.
You can then run statistics advisor against the entire query workload
to ontain RUNSTATS commands targeted to collect statistics appropriate
for your workload.
- Query annotation:
Has a user ever sent you an unformatted mess of a query? Ever think a
query is simple, then realize the complexity is buried in the views?
Ever wonder what the optimizer transformed query looks like? Query
annotation shows the formatted, optimizer transformed query. The query
is also annotated with table and predicate statistics and costing
information. The query is formatted and annotated in a way to prepare
it for analysis.
- Visual Explain
Optimization Service Center contains the same access path graphing
capabilities users have come to know and love from Visual Explain.
- Query Report
Provide a tablespace, table, index, indexed columns statistics report.
This is a handy reference when looking at a query, the access path
chosen - to know what indexes are available, what columns are in the
index, and what the statistics are on each of the objects.
- Statistics Advisor
Query based Statistics Advisor will analyze an individual SQL statement,
the tables, indexes, and columns used in the where clause to make
targeted statistics recommendations.
- Visual Plan Hint
Ever have difficulty constructing an optimization hint? Visual Plan Hint starts with your existing access path and provides an easy to use GUI interface to allow you to modify the access path. There is built in hint validation to show that the optimization hint was chosen and implemented as expected, and even a before / after plan_table comparison to highlight differences in the access path. Visual Plan Hint also has facilities to deploy the hint into your plan_table.
Control your destiny with optimization hints
Have you struggled with implementing optimization hints? This
presentation is a deep dive into optimization hints. I cover common
pitfalls in implementing optimization hints, and how to avoid them.
I also discuss under what circumstances you might consider optimization
hints, and why they are a better solution than other tricks.
Roger Rea is responsible to drive market share growth for IBM DB2 and
solidDB, leading development, marketing, sales and channels. Prior to
this assignment, Roger has held a variety of sales, technical,
educational, marketing and management jobs at IBM, Skill Dynamics and
He has been awarded with four (4) 100% Clubs for exceeding sales
targets with both large account and general business territories,
one (1) Systems Engineering Symposium for on-time installation of a
Directory Assistance System with multiple sites in two states,
numerous Excellence Awards for development and delivery of Competitive,
Strategic and UNIX Marketing courses and several Teamwork Awards for
successes like revenue growth of 67% in one year as Brand Manager,
Intel-based Systems Management.
Rea earned a Bachelor of Science in Mathematics and Computer Science,
cum laude, from the University of California at Los Angeles (UCLA).
He has also received a Masters' Certificate in Project Management
from George Washington University.
Top Ten Best Practices for DB2 LUW
The combination of skill availability, increasingly complex technology
options as well as increased business demand for a greater return on
investment have pushed many IT engineering teams to either design or
adopt know best practices. DB2 built the Balanced Warehouse,
originally, Balanced Configuration Unit, around a set of proven
methodolgies and practices that achieve the best overall performance
and reliability. Our experience with the Balanced Warehouse and with
engineering teams who have designed their own best practices has shown
that the up front investment in defining the best practices they
follow have reduced the overall number of skill resources needed,
provided greater overall availability, and greater performance around
their investment. Working closesly with partners and field teams the
DB2 development team has defined a set of best practices around
warehouse, OLTP, and SAP deployments.
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: June 6, 2008
Copyright © 2008 SIRDUG Inc. All rights reserved.