Central Ohio DB2 User Group
(CODUG)
June 10, 1998 Agenda

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

Meeting at Nationwide Plaza 1 Heritage Room (Map)

1:00-1:15	Welcome to Nationwide and a short business meeting
1:15-2:15	Presentation: DB2 Version 6 for OS/390 - What's New - by William Backs. Abstract
2:15-2:30	Break - Coffee, cookies, and pop will be served.
2:30-3:30	Second presentation: DB2 Query Parallelism: Optimizing Performance - by Robert Catterall. Abstract
3:30-4:00	CDB Software Product Overview - by Sam Edwards. Abstract
4:00-4:10	What's new at IBM by Phyllis Groezinger of IBM Santa Teresa
4:10-4:30	Round table discussion.

Special Note:

At the January 14, 1998 meeting Chuck Hoover, of Compuware Corporation, intended to distribute copies of the latest book in his series on DB2. Unfortunately, Broader Horizons with DB2 Version 5 was not available from the publishers at that date. However, the book is available now and twenty copies will be distributed at the June 10, 1998 meeting to CODUG members whose dues were paid at the January 1998 meeting. Please see John Cochran for a copy of the book.

Highlights of "DB2 Version 6 for OS/390 - What's New" presentation by William Backs

DB2 Version 6 is a major release with many new features. In his talk, William will discuss:

Object-Relational Extensions:

Large Objects
User Defined Data Types
User Defined Functions

Extenders
Trigger Support and New Functions
SQL Enhancements
Networking and Client/Server Enhancements
Utility Improvements, Included Tools, Performance and Availability
Miscellaneous (a long list!)
Migration Concerns.

William Backs is a Senior Partner with Sobek Consulting and has been employed in Information Technology since 1976. His experience includes data modeling and data administration, distributed data architectures and relational database design and theory, especially with DB2. Mr. Backs is a nationally noted author, lecturer and teacher and is currently on the faculty of DePaul University.

Highlights of "DB2 Query Parallelism: Optimizing Performance" presentation by Robert Catterall

DB2 Query Parallelism includes any form of parallelization of tasks to reduce the response time of large queries. Many performance opportunities exist including optimizing I/O parallelism, CP (Central Processor) parallelism and CPU parallelism. Once invoked, Query Parallelism can result in dramatically reduced run times for queries. In his talk, Robert will discuss:

How parallelism is chosen by the DB2 Optimizer.
How to determine if parallelism is being used.
How query de-composition and query merge is performed.
What is meant by the DB2 Degree parameter.
How you can influence the Degree on your queries.

Robert Catterall is a Senior DB2 Specialist at the IBM Dallas Systems Center voted best overall speaker an the IDUG 1997 Asia Pacific conference. Robertís primary areas of expertise are DB2 performance and database design. For the past three years Robert has help companies in the United States and several other countries implement and tune DB2 Data Sharing.

CDB Software Product Overview - by Sam Edwards

CODUG welcomes CDB software as a Vendor Sponsor. Sam Edwards will discuss CDBís suite of high performance DB2 tools including:

Automation of DB2 utilities to free DBAs from manual intervention.
Drastic reduction in required JCL.
Online 24x7 Read-Write Utilities (first to the Market).
Tools to manage partition tablespaces (first to the Market).
Dynamic management of datasets.
Takings advantage of multiprocessing, parallelism, datasharing, sysplex and raid devices.

Sam Edwards- is a technical support person for CDB Software. In addition to his experience at CDB in the DB2 area, Sam spent 30 years at IBM as a CE and a systems engineer for several large IBM customers in large mainframe MVS environments.