DB2 REPLICATION WITH DATA PROPAGATOR
This presentation will discuss how Royal Bank re-architected their Client Information File to provide a consolidated view of the information in three separate physical locations. The business requirement was to provide a solution where data could be updated at any location, at any time, with the updates being distributed to the other locations in "near time". This will include the technical solution, and will discuss the use of DB2 and DPROP to achieve the Bank’s objectives.

DB2 AND OLAP
DB2 Version 5 provides a number of important new capabilities for an OLAP environment.
These include: the new SQL CUBE and ROLLUP operations, which allow a single result set to be consolidated, aggregated, and viewed in multiple dimensions; Star joins, exploiting dynamic bitmaps for performance; index ANDing, exploiting dynamic bitmaps for performance.
This presentation will describe these capabilities, and how they operate in the DB2 universal server environments, including the MPP or PE environment.

DB2 VERSION 4.1 IMPLEMENTATION AND EXPLOITATION
This presentation will outline Hudson's Bay experience with DB2 Version 4.1 implementation and exploitation. It covers the complexities of planning and implementation in a large and volatile environment, as well as the practical experiences with new DB2 features: type 2 indices; row level locking; and partition independence.
Do these features really improve performance and on-line access as claimed? The reality is that there is a significant effort required to understand the database access requirements in order to realize these benefits.

DB2 BUFFERPOOL TUNING, DELIVERING THE BENEFITS
This presentation will discuss the performance benefits of splitting DB2 bufferpools, adding hyperpools and adjusting threshold parameters. This will include: up-front preparation and planning; getting started (things to get right the first time); an approach to generating savings in virtual pool and hyperpool management; the major benefits delivered ($2,000,000 reduction in costs of DB2 business); and doing I.T. right the first time: preparing DB2 for datasharing.