Meeting Information for March
The next meeting of the LAADB2UG will be on
Thursday, March 3, 2005. This is an all-day meeting with lunch provided
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.
Phil Gunning -
Phil Gunning is an associate consultant for
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.
SQL Coding Best Practices -- Phil Gunning
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
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