June 12 SIRDUG Meeting Featuring Patrick Bossman & Roger Rea



Meeting Details

WHEN? June 12 (Thursday)

WHERE?

IBM Facility

For detailed directions click here

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


Meeting Agenda

June 12
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
  

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, 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).

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 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 Conference Room.

Patrick Bossman Biography

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.


Patrick Bossman - Session Abstracts


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 technology.

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 queries faster.
- 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 Biography

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 Tivoli Systems.
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.

Roger Rea - Session Abstracts


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. solidDB



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.