Location: Sheraton Centre Toronto (City Hall Room)
| 08:15 - 09:00 | REGISTRATION / CONTINENTAL BREAKFAST
| 09:00 - 09:15 | OPENING REMARKS - Chairperson
| 09:15 - 10:30 | BATCH PROMOTION AND COMPILATION OF SQL STORED PROCEDURES FOR Z/OS
| Michael Harper - TD Canada Trust 10:30 - 10:45
| COFFEE BREAK
| 10:45 - 12:00 | WAYS TO ACCESS DB2 FROM A JAVA/WEB APPLICATION
| John Mallonee - Highmark, Inc. 12:00 - 01:15
| LUNCH
| 01:15 - 02:30 | DB2 UDB AT TD BANK
| Darryl Scott - TD Canada Trust 02:30 - 02:45
| COFFEE BREAK
| 02:45 - 04:00 | AUTONOMIC DB2-SIMPLICITY/PERFORMANCE, AVAILABILITY
| Sam Lightstone - IBM Toronto Lab |
BATCH PROMOTION AND COMPILATION OF SQL STORED PROCEDURES FOR Z/OS
Platform: DB2 for OS/390 and z/OS - Audience: All
IBM DB2® Universal Database™ for OS/390™ Version 6 saw the introduction of the SQL Procedural language (SQL/PSM).
With this language one could author DB2 stored procedures composed entirely of SQL statements.
IBM also supplied a Java® PC application (Stored Procedure Builder) as part of the
DB2 Connect Application Development Client to provide an easy-to-use, graphical tool to create, debug, install, and test SQL Stored Procedures.
In a z/OS environment requiring secure, auditable method of promotion and compilation,
Stored Procedure Builder has serious limitations. This presentation discusses “batch” alternatives to this tool to supply the required functionality.
Michael Harper is a Senior IT Specialist with TD Canada Trust, and has over 20 years of experience, 15 years with DB2.
Over the years Michael has presented on various DB2 topics at GUIDEs, IDUG, and other user groups (including CCDB2UG). Regulars will recognized him as one of the cheerful executives always happy to greet attendees.
WAYS TO ACCESS DB2 FROM A JAVA/WEB APPLICATION
Platform: Cross Platform - Audience: All
DB2 has become an open database platform and is accessible from web applications through a variety of different methods.
What are the available methods for getting to DB2 through Java and which ones are good candidates for different situations?
This session will discuss several different approaches and when each is a good solution.
It is designed to show the application developer how it's done. It will cover the following areas:
John Mallonee has 19 years experience as an applications developer, designer, and (internal) consultant.
Initially with COBOL, IMS, and DB2.
Increasingly he has worked with Java technology over the last 5 years, and primarly consults with an applications group developing WebSphere applications.
DB2 UDB AT TD BANK
Platform: DB2 for Linux, Unix, Windows - Audience: All
Large-scale data warehousing requires careful planning and due diligence when choosing from a variety of architectural/management options.
In the last year, TD Bank has expanded it use of DB2 UDB by implementing a variety of new warehousing initiatives (Anti-Money Laundering, Basel, etc.)
and an Enterprise Staging and Integration layer.
In this presentation, you'll see a high-level overview of the TD warehousing environment, a more detailed look at the new/recent UDB initiatives,
as well as some lessons learned when doing capacity upgrades, redistribution,
workload management and DB2 V8 migrations.
Darryl Scott is a Distributed Database Architect with TD Bank Financial Group.
Over the last 8 years, Darryl has designed, benchmarked and administered large-scale data warehouses on Oracle and DB2 UDB.
AUTONOMIC DB2-SIMPLICITY/PERFORMANCE, AVAILABILITY
Platform: DB2 for Linux, Unix, Windows - Audience: All
Manageability of technology is a major and growing imperative across the industry.
Middleware products are increasingly feature rich and systems are increasingly interconnected creating complexity for human administrators.
In this presentation learn how DB2 is pushing the envelope through autonomic computing to provide cutting edge technology that configures, optimizes and administers DB2 with ever decreasing human involvement.
This presentation will cover autonomic computing features in DB2 with a highlight on the expansive new autonomic capabilities in DB2 UDB v8.2. Some of DB2's newest features allow DB2 to administer itself in ways a human administrator never could.
Autonomic Computing leads to unheralded increases in return on investment, reduced total cost of ownership, system availability and system performance.
Sam Lightstone is a Senior Technical Development Manager with the DB2 Universal Database Development team.
Sam currently leads DB2's Autonomic Computing R&D effort.
Additionally Sam manages his own Advanced Technology department wich does development and applied research on topics on Autonomic Computing for database systems.
Sam is a member of IBM's Autonomic Computing Architecture Board. Prior to his current position, Sam worked as Development Manager and Technical Lead for the DB2 Load & Sort development components.
Sam holds numerous patents including several in relational database technology. He has published and lectured on topics including database systems, voice encoding, image processing, object oriented design, intellectual property, and software testing and speaks frequently at DB2 conferences.
He has been with IBM for eleven years.