Central Canada DB2 Users Group
Summer Meeting 1997

AGENDA
Monday July 7, 1997

Location: Hilton Hotel Downtown

09:15 - 10:30

PERFORMANCE ESTIMATING AND CAPACITY PLANNING FOR DB2/MVS
Chuck Hoover - Compuware
10:30 - 10:45 COFFEE BREAK
10:45 - 12:00

PERFORMANCE ESTIMATING AND CAPACITY PLANNING FOR DB2/MVS
Chuck Hoover - Compuware
12:00 - 01:15 LUNCH
01:15 - 02:30

INTERNET COMMERCE WITH DB2
Marilyn Beaton & Ivy Cheng - IBM Canada Ltd.
02:30 - 02:45 COFFEE BREAK
02:45 - 04:00

DB2 UNIVERSAL DATABASE V5 OPTIMIZER - NEW FRONTIERS
Ian Finlay - IBM Toronto Lab.


ABSTRACTS

PERFORMANCE ESTIMATING AND CAPACITY PLANNING FOR DB2/MVS
This presentation is designed to supply sufficient information to address DB2 performance forecasting and capacity planning. This includes techniques to develop "ball park" timing estimations of application programs using various access paths, and the use of the IBM DB2 Estimator for Windows.
It also covers the analysis of resources required for on-line transaction processing applications. This will be illustrated using data from an operational CICS/DB2 order entry system processing 108,000 transactions during a peak hour. Resources that are quantified are: the central processor, direct access storage devices, and the number of concurrent application threads. Application "residency time" is estimated to provide a foundation for response time forecasts.

DB2 AND THE INTERNET
This presentation will show how retailers like L.L. Bean and the Hudson's Bay Company use the Web and DB2 to sell to the world. In the fast paced, fiercely competitive retail world, the ability to get up and running quickly is important. To stay in business, you have to keep on running. It is essential to maintain Web pages quickly, accurately, reliably and easily to keep pace with prices, fashion and selection.

UNIVERSAL DATABASE V5 OPTIMIZER - NEW FRONTIERS
This presentation will cover the DB2 optimizer enhancements available in DB2 for Common Server V5.
This will include: SMP optimization support, making the most of shared memory and multiprocessor machines; cluster optimization support, improved support for shared nothing machines; ROLAP (Cube and Rollup) support; new access methods, dynamic bitmap index ANDing and semi-joins; other optimizer enhancements.




HOME | Our Mission | Calender of Events | Executive Committee
Membership Information | Membership Benefits | Policies | DB2 Links