Central Ohio DB2 User Group
(CODUG)
March 15, 2000 Agenda

Meeting at State Auto - 518 East Broad Street (Map)

DB2 High Performance Design 2000

The rules for high performance keep advancing with each new version. Old techniques fade and new techniques arrive. This presentation focuses on specific issues to achieve maximum performance using the newer stuff. Topics such as large tables (16TB) and NPIs, identify columns and declared tables, object relational data storage and extenders, buffer pool changes and new page sizes, 24 x 7 continuous availability and the enhanced utilities, and transaction design including savepoints are examined for on-line, ODS, and data warehouses integrated with operational, and distributed and intranet/internet applications. The performance impacts of new SQL functionality are covered including outer joins (big change), table expressions without materialization, UDFs, table functions, triggers and more. Stored procedures have too many changes to list, including those new languages. This is not transitional but how to use the features that are both new and retro-fitted into V6.

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 has written columns for several magazines. Richard was formerly a senior consultant with Codd and Date, Inc. He is a regular quest speaker at conventions and user groups in the U.S., Australia, Japan and Europe, and has won best speaker awards for many of these. Richard is a member of the IBM Gold Consultants program. He is one of the authors of "Data Warehouse Practical Advice From the Experts" published by Prentice-Hall and "DB2 Answers!" published by Osborne/McGraw-Hill.

Announcements

IDUG discount coupons ($50) will be available at the meeting.

The remaining two meeting dates are June 14 and September 20.

We are seeking a new site to host one or both of our remaining meetings. If anyone is interested, notify one of the officers. Approximate attendance is 40-50 people.

Any mailing address corrections should be brought to the attention of the Officer of Dues and Membership, Sharon Hamilton.