Central Ohio DB2 User Group
(CODUG)
September 18, 2002 Agenda

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

Crossing Over - Breaking the DB2 Platform Barrier - Tim Fritz

Platform: IBM DB2 UDB on multi-platforms

• Basic components.
• Terminology differences.
• Storage management differences.
• Object comparisons
• Administrative differences

About the Speaker  -  Tim Fritz

Tim Fritz is a Senior Systems Consultant for Quest Software, a leading database utility vendor. Before joining Quest he was a DBA on DB2 OS/390, and on DB2 UDB for NT and UNIX. Tim has over twenty years of experience in the information technology field, including several years in DB2 application development. Tim is an IBM Certified Solutions Expert in DB2 UDB Database Administration.

Trace Analysis Of Stored Procedures, Triggers, & UDFs - Ed Woods

Stored procedures, triggers, and user-defined functions (UDFs) have expanded the reach and capabilities of DB2 for OS/390. Stored procedures, triggers, and user-defined functions provide powerful functionality, but also imply important considerations for DB2 performance analysis. Fortunately for the DB2 performance analyst, DB2 for OS/390 offers considerable statistics, performance, and accounting trace information.

This presentation will begin with a brief review of stored procedures, triggers, and user-defined functions, and how they are defined and implemented. The presentation will then look at the execution life cycle of these functions, examining what events occur, and in what sequence. Next, the presentation will focus on the performance analysis and management of stored procedures, triggers, and user defined functions. This will include looking at what data is available in the form of statistics, performance, and accounting trace data, and how to analyze the performance repercussions of using stored procedures, triggers, and user defined functions. This presentation is for all DB2 users interested in performance.

About the Speaker  -  Ed Woods

The speaker has 20 years of experience in the data processing industry, primarily in the area of DB2, IMS, and MVS systems programming. He has been a Systems Engineer with Candle Corporation for nine years, supporting the Candle DB2, IMS, and e-Business product lines. The speaker has presented at IDUG North America, IDUG Europe, Guide, Share, CMG, and at regional DB2 User groups on DB2 technical and performance topics. In addition, he has presented as a part of Candle Performance Road Shows, and has published articles in Candle Computer Report and IDUG Solutions Journal. At IDUG North America 2000, he was named Best Overall Speaker.

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.

From the North I:  315 S. to Kinnear/Olentangy, exit right on Kinnear Rd., left (S) on Kenny Rd., right (W) on King Ave., left (S) on Grandview Ave to Dublin Rd.

From the North II:  I-71 S., exit West on Spring St., through downtown, becomes Dublin Rd.

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

From the East:  I-70 W, to 315 N, exit West on Long St./Dublin Rd.

From the Airport:  670 W, exit High St., left on High St., right at Spring St., turns into Dublin Rd.

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

From the West:  I-70 W to revised Grandview exit (33), turn left on Dublin Rd.

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