Central Ohio DB2 User Group
(CODUG)
March 14, 2001 Agenda


Officers
Meeting Schedule
Meeting Minutes
Membership
Links of interest
DB2 Trivia
Hot Tips
Home

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

12:30-1:00 Registration
1:00-1:15 Business Meeting. Announcements.
1:15-2:45 Presentation: Fun with DB2 Performance for Everyone - Part 1
Presented by Willie Favero of BMC Software
Abstract
2:45-3:00 Break - Coffee, cookies, and pop will be served.
3:00-4:30 Presentation: Fun with DB2 Performance for Everyone - Part 2
Presented by Willie Favero of BMC Software
Abstract

Fun with DB2 Performance for Everyone - Willie Favero

Companies have been running DB2 for over 15 years now. Through the years, customers have asked the same question: "How do you make DB2 run faster?" In the beginning, tuning DB2 was left to the system programmers. Then it spread to the DBAs. Now, for optimal performance, everyone must be involved - from management to DBA to application programmer. This presentation discusses some of the fundamentals of DB2 performance tuning with a different approach. The best DBA and the newest DB2 application programmer will gain new skill from this presentation. Everything from pools to locking, bind to logging, and commit processing to SQL will be covered. EXPLAIN is also covered briefly, with a look at some of the performance improvements and tools that were made available in the most current version of DB2 UDB for OS/390.

About the Speaker  -  Willie Favero

Willie Favero is a principal consultant at BMC Software. He has worked with database software for more than 26 years, starting with IMS. For the last 16 years, he has worked with all aspects of DB2. Willie has authored numerous articles, contributed to several of IBM®'s Redbooks and acted as a technical editor on dozens of database, object-oriented, programming, and data warehouse books. He is a highly sought after presenter at IDUG (North America, Europe, and Asia Pacific), GUIDE, SHARE, local and international DB2 User Groups and the IBM DB2 Technical Conference.

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.


 

Created: March 6, 2001 / Updated: March 6, 2001
Send changes and corrections to webmaster@codug.org