Central Ohio DB2 User Group
(CODUG)
April 2, 2003 Agenda

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

What's New in DB2 Version 8 - William Backs

The latest announced version of DB2 for z/OS, version 8, is the largest single release in the history of DB2. It has numerous enhancements, not the least of which is a complete conversion to Unicode and to 64 bit addressing. Many of these features will have a significant impact on database administration. In the talk Mr. Backs will review many of these new features. He will close with a discussion of the migration path to the new release, the most complex migration ever.

About the Speaker  -  William Backs

Mr. Backs is a Senior Partner with Sobek Consulting, and has been employed in the data processing industry since 1976. For the past fifteen years he has specialized in relational database theory and design, especially DB2. Mr. Backs is a nationally recognized leader in the DB2 community. He has been working with DB2 since Release 1.2. While Director of Information Technology at a large textbook publisher, he was responsible for implementing the first transaction CICS system to utilize DB2 in the Midwest. IBM has recognized his leadership by making him one of their Gold Consultants. Mr. Backs helped found the International DB2 Users Group and was its first president. For years he was on the Board of Directors of the Midwest DB2 Users Group. In addition, he is a member of the faculty at Depaul University.

Tuning Group Buffer Pools and Using Only One Command - Bryce Krohn

This presentation discusses the mechanics of DB2’s for OS/390 data sharing group buffer pools, and the tuning opportunities available for them. For example, how does DB2 for OS/390 provide data integrity when two DB2 subsystems in a data sharing group are accessing a data set simultaneously? What happens when one system updates a page that the other system already has cached? What is cross-invalidation, and how does it work? How does the user know if the group buffer pool is large enough? The presentation will conclude with a discussion of the counters that are included in the output of the DISPLAY GROUPB group buffer pool, and how the values of those counters can be used to monitor and tune the group buffer pool.

About the Speaker  -  Bryce Krohn

Bryce Krohn has over eight years experience in developing and teaching DB2 for z/OS and OS/390 data sharing courses, having been a major contributor to the development of the IBM Learning Services data sharing curriculum during the last five years of his 34 year career with IBM. Bryce has taught data sharing courses internationally, including Australia, Belgium, France, England, Israel, Germany, and Saudi Arabia. He has presented at all the DB2 Technical Conferences. He participated in the development of the parallel sysplex operator certification test, and has given customer data sharing briefings in the Poughkeepsie briefing center.

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) 854-5219. Contact her with any questions regarding your company's membership status.

Directions - Be careful. The Grandview Avenue exit from I-670 is detoured. Also, I-670 is closed through downtown now.

North I: 315 S. to Kinnear/Olentangy, exit right on Kinnear Rd., left (S) on Kenny Rd., right (W) on W. Fifth Ave.,

North II: I-71 S., exit Spring St., through downtown, becomes 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: 670 W, exit Third St., right at Spring St., turns into Dublin Rd.

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

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