Central Canada DB2 Users Group

Fall Meeting 2002

A G E N D A
Monday October 28, 2002

Location: Bank of Montreal Institute for Learning

08:15 - 09:00	REGISTRATION / CONTINENTAL BREAKFAST
09:00 - 09:10	OPENING REMARKS - Chairperson
09:10 - 10:25	USING LOBS SUCCESSFULLY Michael Murray – Computer Associates
10:25 - 10:40	COFFEE BREAK
10:40 - 11:55	MY FAVOURITE IFCIDS Joe Borges – Bank of Montreal
11:55 - 01:00	LUNCH
01:00 - 02:15	DB2 TRIGGER HINTS AND TIPS Dan Alion – Carreker/Check Solutions
02:15 - 02:30	COFFEE BREAK
02:30 - 03:45	THE DB2 LOG -WHAT'S IN IT FOR ME? Michael Murray – Computer Associates

ABSTRACTS

MY FAVOURITE IFCIDS
"My Favourite IFCIDs!" is a colourful and practical look into the world of DB2 performance using IFCIDs. After an introduction to DB2’s Instrumentation Facility (DB2 Traces), the presentation will focus on some of the more meaningful and interesting DB2 IFCIDs! Monitor dynamic SQL usage with IFCID 22 and 63… see a practical implementation of IFCID 199 (Buffer Pool Statistics at Data Set level)… AND much more!

Joe is currently a Senior Technical Specialist at the Bank of Montreal (Canada). Bank of Montreal is one of North America’s top 10 banks and employs over 35,000 employees, supporting over 2,500 branches worldwide. Joe has been employed at the Bank of Montreal for the past 20 years and has spent the past 17 years working with DB2 in various capacities. He is currently the Bank’s DB2 Strategist/Planner. Most recently, he has architected the Bank’s DB2 Data Sharing processing strategy. Joe has spoken at various conferences including being on the “DB2 System Performance – Panel” at IDUG 93.

DB2 TRIGGER HINTS AND TIPS
83 triggers, 24 tables…what were we thinking? Start on OS390, then propagate to AIX and NT platforms…what were we thinking? Here is a case study emphasizing trigger coding and testing techniques, and cross-platform differences.

Dan has 20 years of software development and management experience. The past 8 years he has been involved in the development of statistical reports and monitoring applications for check processing systems. This work has often involved DB2 database programming. Current development activities include extensive use of triggers to summarize DB2 information for downstream monitoring applications.

USING LOBS SUCCESSFULLY
Using LOBs can be very beneficial and with proper use, you can avoid performance issues. This presentation will discuss the use of LOBs in a DB2 for z/OS and OS/390 environment. We'll discuss LOB characteristics, Usage, Trends, how they work, Extenders and recovery considerations.

THE DB2 LOG -WHAT'S IN IT FOR ME?
With the emergence of tools enabling the reading of the DB2 log, this presentation looks at how the information stored there may be used. We start by revisiting the DB2 logging mechanism to understand HOW and WHAT DB2 logs, before looking at the ways in which this valuable resource may be utilised.

Michael Murray is a senior DB2 Consultant with Computer Associates.

TRAVELLING TO THE INSTITUTE FOR LEARNING
3550 Pharmacy Avenue, Scarborough, Ontario, M1W 3Z3

From West:
Follow the 401 east bound to the Don Valley Parkway (DVP) exit. From this exit take the 404 north. Follow the 404 north to Steeles and Woodbine exit (Exit 22). Stay to the right of the exit, as you will be turning right on to Steeles. Once on Steeles, go to the third set of lights, which is Pharmacy Avenue, and turn right. Follow Pharmacy Avenue south to the first driveway and turn right. Follow the driveway to the parking lot, which is located on the West side of the building.

From East:
Follow the 401 west bound to the Don Valley Parkway (DVP) exit. From this exit take the 404 north. Follow the 404 north to Steeles and Woodbine exit (Exit 22). Stay to the right of the exit, as you will be turning right on to Steeles. Once on Steeles, go to the third set of lights, which is Pharmacy Avenue, and turn right. Follow Pharmacy Avenue south to the first driveway and turn right. Follow the driveway to the parking lot, which is located on the West side of the building.

From North:
Follow the 404 south to Steeles Avenue. Turn left on to Steeles and at the forth set of lights, which is Pharmacy Avenue, turn right. Follow Pharmacy Avenue south to the first driveway and turn right. Follow the driveway to the parking lot, which is located on the West side of the building.

From South:
Follow the Don Valley Parkway (DVP) north and once you cross over the 401, it becomes the 404. Follow the 404 north to Steeles and Woodbine exit (Exit 22). Stay to the right of the exit, as you will be turning right on to Steeles. Once on Steeles, go to the third set of lights, which is Pharmacy Avenue, and turn right. Follow Pharmacy Avenue south to the first driveway and turn right. Follow the driveway to the parking lot, which is located on the West side of the building.

Meeting Registration Information

HOME | Our Mission | Calendar | Executive Committee
Membership Information | DB2 Links