Central Ohio DB2 User Group
(CODUG)
January 13, 1999 Agenda

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

Meeting at State Auto (Map)

1:00-1:15 Payment of 1999 Dues (see Membership page)
1:15-1:20 Welcome to State Auto - Vice President Rosemary Schneider and Host Roy Asamoto
1:20-1:30 Introduction of New Dues and Membership Officer Sharon Hamilton
1:30-1:40 User Group Financial Statement - Treasurer Janet Howie
1:40-2:40 Presentation: DB2 Advanced and Complex SQL - Richard Yevich
Abstract
2:40-3:00 Break - Coffee, cookies, and pop will be served. Door prizes!
3:00-4:00 Presentation: Achieving Maximum Performance in DB2 Through Version 5 - Richard Yevich
Abstract
4:00-4:15 What's new at IBM
by Phyllis Groezinger of IBM Santa Teresa
4:15-4:30 DB2 Round table discussion - John Cochran

DB2 Advanced and Complex SQL - by Richard Yevich

DB2 UDB (UDB includes OS/390 V6) brings focus to the fact that SQL syntax is easy but writing good SQL is not, even with query rewrite. Examples are shown of how SQL can solve very difficult business problems, and why this type of SQL never gets written.

Examples of complex SQL in different formulations are shown to demonstrate those that perform efficiently versus those that perform in the worst possible manner.

DB2 brought a whole new world to relational with advancements in SQL processing and object relational support. Presented here are the more advanced examples including:

  • UDF Indexing and retrieval of large object components.
  • Active data triggers implementing complex referential integrity.
  • Table functions.
  • SQL recursive processing.
  • Many other features of the UDB family.

Achieving Maximum Performance in DB2 Through Version 5 - by Richard Yevich

Achieving maximum performance from DB2 requires a different approach and stricter methodologies than simply getting a DB2 application to perform well. This presentation focuses on specific issues of physical object design and application methods to achieve maximum performance through DB2 Version 5.

  • Concurrency and locking.
  • Large tables and NPIs.
  • Buffer pool utilization.
  • DB2 compression.
  • Commit strategies, (24 x 7) continuous availability.
  • Transaction design.

The performance techniques of the new SQL are covered (such as complex outer joins, table expressions, and CASE use). Discover why many old guide-lines no longer apply, and learn the approaches to designing performance into all applications.

About the speaker

Richard Yevich

Richard Yevich is an internationally recognized consultant, lecturer and teacher, known for his expertise in enterprise information systems. He specializes in client/server, warehouse, and distributed relational systems across multiple platforms, and in establishing proper design to achieve high performance and high availability.

Richard is widely published and writes columns in "Data Management Review", and the "IDUG Solutions Journal". Richard was formerly a senior consultant with Codd and Date Inc.

He is a regular guest speaker at conventions and user groups in the U.S., Australia, Japan and Europe, and has won best speaker awards for many of these. He is one of the authors of "Data Warehouse: Practical Advice From the Experts" published by Prentice-Hall in 1997.
Created:August 16, 1998 / Updated: January 4, 1999
Send changes and corrections to webmaster@codug.org