Location: Sheraton Centre Toronto (Essex Ballroom)
| 08:15 - 09:00 | REGISTRATION / CONTINENTAL BREAKFAST
| 09:00 - 09:15 | OPENING REMARKS - Chairperson
| 09:15 - 10:30 | IDENTIFYING AND TUNING DB2 UNIVERSAL DATABASE CONFIGURATION PARAMETERS
| Phil Gunning - Quest Systems 10:30 - 10:45
| COFFEE BREAK
| 10:45 - 12:00 | MANAGING DB2 BUFFERPOOLS FOR OS/390 - A PRACTICAL POINT OF VIEW
| Key-Soo Rho and John Dube - Ministry of Transportation 12:00 - 01:15
| LUNCH
| 01:15 - 02:30 | DB2 V7.1 AND XML EXTENDER
| David Sky and Eric Sirois - IBM Toronto Lab 02:30 - 02:45
| COFFEE BREAK
| 02:45 - 04:00 | DB2 UDB V7.1 REPLICATION - A PRIMER
| Tim Johnson - Whitefriars Group Inc. |
IDENTIFYING AND TUNING DB2 UNIVERSAL DATABASE CONFIGURATION PARAMETERS
DB2 UDB for UNIX, Windows and OS/2 is one of the premier databases used for OLTP and OLAP. It is full of functions and features.
However, to ensure that your company is getting the best performance possible from DB2 UDB,
a detailed in-depth knowledge of Database Manager and Database Configuration parameters is required.
The old rule that you only make one change and then monitor the results of that change are hard to do because many parameters are interrelated.
This presentation will identify the important tuning parameters and other dependent parameters that should be tuned at the same time.
Snapshot, Event monitoring, and problem diagnosis will be discussed.
This presentation is based on real-world tuning challenges in a production environment.
Phil Gunning is a Senior Systems Consultant with Quest Software Specializing in Database Administration, SQL Tuning, Monitoring/Diagnostics,
and Space Management tools for DB2 UDB and DB2 for OS/390.
He has presented at IDUG North America, and other local DB2 Users Groups.
MANAGING DB2 BUFFERPOOLS FOR OS/390 - A PRACTICAL POINT OF VIEW
This presentation will discuss bufferpool tuning in a customer environment, and will include:
Key-Soo Rho and John Dube are senior DBAs at the Ministry of Transportation.
DB2 V7.1 AND XML EXTENDER
XML is the standard for digital document exchange on the web, particularly in business-to-business and business intelligence solutions.
Traditional markup languages, like HTML, typically describe how a document looks; XML describes what a document means.
DB2 XML Extender enables organizations to store, retrieve and search XML documents either inserted as character data into XML-enabled columns,
or stored as collections of XML documents in an external filesystem, but managed using DB2 Universal Database V7.1.
This presentation discusses the benefits of both types of XML storage methods (columns vs. collections),
how to enable your DB2 databases and columns for use with XML Extender, and how to retrieve XML data to satisfy ad-hoc queries.
We will also demonstrate a prototype client/server document retrieval system using XML Extender, Apache Server, PHP and a web browser.
This functionality is available in both DB2 for OS/390 and DB2 for UNIX, Windows and OS/2.
David Sky has been a member of the DB2 Information Development group for over five years,
during which time he has been responsible for end-user documentation, sample programs, and external IBM Web pages.
Currently he is responsible for DB2 user assistance in general as well as DB2 HTML, SGML and XML coding practices and standards.
Eric Sirois is a software developer at IBM's Toronto Software Lab, and is member of the DB2 Information Development group.
His current projects include the development of Query Optimization Wizards and XML related technologies.
Both David and Eric are IBM Certified Solutions Experts for DB2 UDB v7.1 Database Administration for UNIX, Windows and OS/2.
DB2 UDB V7.1 REPLICATION - A PRIMER
The DB2 UDB for UNIX, Windows and OS/2 product includes Replication functionality that was previously available as a separate product, Data Propagator.
This presentation will provide an overview of the DB2 Replication functionality provided as part of DB2 UDB V7.1 for UNIX, Windows and OS/2,
and outline the implementation of Replication in a Windows 2000 platform, for a distributed customer application.
Tim Johnson is an independent consultant, and has been working with DB2 for longer than he cares to remember.