Central Ohio DB2 User Group
(CODUG)
June 22, 2005 Agenda

Meeting at NiSource - Formerly Columbia Gas
1600 Dublin Rd.* (Map, Directions) Just South of 5th Ave. on Rt. 33
*Lots of free parking.

Contrasting DB2 Optimizer Choices Between V6-7-8

HLS Technologies, Inc. has preformed a study consisting of 17 scenarios for common SQL changes. Each scenario was preformed on the same machine, which was running Z/OS V1R5. The data structures, data and DB2 Buffer setups were the same for each scenario across V6, V7, and V8. This presentation contrasts the choices made by the DB2 Optimizer across these Versions of DB2. Some choices are surprising, and some are not, while most are concerns that need to be considered when migrating between Versions of DB2.

The presentation will begin with a few notes on current migration issues and surprises that have come from our consulting engagements.

A detailed PDF is available from the HLS Technologies, Inc. website, as are the DBRMs, data, data structures and instructions for you to recreate your own test of our 17 scenarios.

About the Speaker  -  Gerald Hodge, HLS Technologies, Inc.

Gerald Hodge started HLS Technologies, Inc., in 1990 as a DB2 Tools and DB2 Consulting company. Bind Manager and Path Checker from IBM are HLS products resold under the IBM banner. Mr. Hodge has consulted in several successful V8 conversions both in the U.S. and in Europe. These V8 experiences are the formation of the HLS presentations on V8 Conversion and Contrasting DB2 Optimizer Choices between V6, V7 and V8.

Mr. Hodge is a member of the IBM Gold Team, and specializes in System Programming issues with DB2. Before founding HLS Technologies, Inc., Mr. Hodge had real jobs. He has worked in retail, manufacturing, Petroleum, and banking. In his last real position he was responsible for Performance and Capacity at eight data centers across the U.S. for what was then the third largest bank in the U.S.

Announcements

All in attendance must have either paid in advance or be prepared to pay the dues at the meeting. Please review the Membership page. Our Officer of Dues and Membership is Sharon Hamilton. She can be reached at  membership@codug.org or (614) 249-4313. Contact her with any questions regarding your company's membership status.

Nominations for President and Vice-President - Thanks for your hard work over these last 6 years, Kristi and Rosemary!! Kristi took over the Presidency in Spring 1999 and has done a great job of getting the DB2 community together in Columbus.

We are now accepting applications for members who wish to take over the office of president. See the special note on the web site for a list of the duties performed by the president. If you would like to be considered, send an e-mail to president@codug.org. Applications will be accepted through 7/31/2005. If more than one person expresses interest, we will conduct an election. Paid members as of 7/31/2005 will be notified of the voting procedure. The new president will be announced at the September meeting.

Directions

North I: 315 S. to I-670 W, exit Rt 33 N (#1a), left on Dublin Rd.

North II: I-71 S, I-670 W, exit Rt 33 N (#1a), left on Dublin Rd.

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

South: I-71 N to 315 N. exit Long St./Dublin Rd. Turn left.

East: I-70 W, to 315 N, exit Long St./Dublin Rd. Turn left.

Airport: I-670 W, exit Rt 33 N (#1a), left on Dublin Rd.

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

From the West: I-70 E to I-670 E, exit Grandview Ave., right (N) on Grandview, left on Dublin Rd.