Back Next

Meeting Information for March 2005

The next meeting of the LAADB2UG will be on Thursday, March 3, 2005. This is an all-day meeting with lunch provided by itgain.

Driving Directions: The Sheraton Cerritos is located at 12725 Center Court Drive, Cerritos CA 90703. Telephone is (562) 809-1500. It is one block south of the 91 Freeway in the Cerritos Towne Center. Click here for directions and a map.


PRESENTER:    Phil Gunning - itgain

Phil Gunning is an associate consultant for itgain, a German based consulting and software company focused on DB2 UDB and gateway connect products and services. Phil is currently an internationally acclaimed consultant, author, and lecturer with Gunning Technology Solutions. He provides DB2 UDB consulting and knowledge transfer to companies around the world and has presented extensively on DB2. Phil has taught and designed DB2 college courses, where he was an early member of the DB2 Scholars program. Phil is the author of DB2 UDB V8 Handbook for Linux, UNIX, and Windows, IBM Press, and co-author of the IBM Redbook, DB2 UDB ESE High Performance Design for OLTP and BI, and DB2 UDB for Windows V8.2, The Official Guide, IBM Press. Phil is a member of the IDUG Solution Solutions Journal editorial board.


PRESENTATION:

SQL Coding Best Practices -- Phil Gunning (Gunning TS)

This presentation will show you how to code high performing SQL It will cover Range delimiting, Index SARGable, Data SARGable and residual predicates. Filter factors and selectivity will be discussed along with query rewrite examples. Index design and predicate selection best practices and restriction of result sets will be covered. After attending this session you will be able to go out and code top performing SQL.

Advanced DB2 performance monitoring for UNIX and Windows -- Phil Gunning (Gunning TS)

Many new challenges have been presented to the DB2 DBA due to the introduction of IBM's DB2 UDB. DB2 UDB performance tuning is one of the most critical functions of UDB administration. Poor performance and costly down time can be the result if DB2 UDB is not closely monitored and managed on a day-to-day basis. The focus here is to present a process and methodology of monitoring several UDB installations with a minimum of overhead while proactively reporting and tuning to minimize database and application performance issues.

Note: This presentation includes a vendor product presentation from itgain.

BACK TO THE HOME PAGE

 

     Find out more about UDB Benchmarks here.


Website created and maintained by DataDoneRight.Com 
Copyright 2005. All rights reserved.