Central Ohio DB2 User Group
(CODUG)
March 13, 2002 Agenda

Meeting at Highlights For Children in Grandview
1800 Watermark Dr.* (Map, Directions) Near Grandview Ave and Rt. 33
*Lots of free parking.

Cut Query Times in Half: Sort & I/O Tuning - Scott Hayes

Learn how to measure and evaluate DB2 UDB UNIX, NT, & OS/2 sort and I/O performance, see measurements used in case studies, and learn how to configure your DB2 UDB engine for optimal query performance. Learn 10 steps to performance excellence. Many formulas and case studies will be presented to demonstrate the techniques.

About the Speaker  -  Scott Hayes

Scott Hayes is the founder and president of DGI, a company specializing in performance management tools, consulting, and support for DB2 UDB UNIX. Scott is an IBM DB2 Gold Consultant and IBM DB2 Certified Advanced Technical Expert. He is a frequent speaker at International DB2 User Group (IDUG) meetings worldwide, IBM DB2 Technical Conferences, the DB2 Symposium, and regional user groups meetings, as well as a regular contributor to the DB2-L listserver. Scott most enjoys short DB2 UDB performance tuning consulting engagements.

Tuning Access Paths: Finding the Best Index - Joe Burns

Proper index selection and usage can be the determining factor in the performance of SQL. This presentation will provide insight into a variety of common index access paths and their impact on response time. Straight forward examples will highlight the relationship between finding the best index and better performance. The optimizer is responsible for finding the best available index, which will then drive the development of the rest of the access path. When several indexes are available, the optimizer's choice becomes a key concern for evaluating SQL performance. During this presentation the criteria that the optimizer uses when choosing an index will be reviewed. Furthermore, useful techniques will be covered for influencing the optimizer's decision. These techniques are described by using examples which include modifications to SQL, the use of specialized Runstats, and DB2 Version 6 Hints.

About the Speaker  -  Joe Burns

Joe Burns is a senior member of the DBA staff for Highmark Blue Cross/Blue Shield of Pennsylvania. His responsibilities include actively pursuing database performance problems and training DB2 users on innovative SQL techniques. Joe has spoken on DB2 related topics in several public forums including IDUG North America, IDUG Europe, the Pittsburgh Large Users Group and the Central PA Users Group. As an IDUG North America presenter he was awarded Runner-up Best User speaker in 2001 and received top ten selection in 1999. As an IDUG Europe speaker he was awarded Best User speaker in 2001.

Announcements

It is Membership and Dues time again. Please review the Membership page. Our Officer of Dues and Membership is Sharon Hamilton. She can be reached at  membership@codug.org or (614) 854-5219.

Directions - Orange Barrels willing!!

From the North I:  315 S. to 670 E, exit Neil Ave.  Right at exit (Neil), right at Dublin Rd.

From the North II:  I-71 S. to 670 W, exit Neil Ave.  Left at exit (Neil), right at Dublin Rd.

From the North III: Riverside Dr. south, becomes Dublin Rd.

From the East:  I-70 W, to 670 W, exit Neil Ave.  Left at exit (Neil), right at Dublin Rd.

From the Airport:  670 W, exit Neil Ave.  Left at exit (Neil), right   at Dublin Rd.

From Downtown:  W. on Spring St., becomes Dublin Rd.

From Dublin Rd. at Grandview Ave:  Turn south on Grandview, turn right (west) on Watermark Dr. 

From the West:  I-70 W. to Grandview Exit.  Right (north) on Grandview Ave., left (west) on Watermark Dr.