|
The Colorado DB2 Users Group for z/OS meeting will be held on December 15, 2006 at FedEx.
The following is a list of the presentations:
Introductory Remarks
Rob Crane, FedEx Freight - President of the User Group
IBM DB2 for z/OS Update
Kevin Harrison, IBM - West Region Technical Sales Support for DB2 zSeries
Kevin Harrison is a Certified Senior I/T Architect with broad experience in application development, database
management systems, architecture development, technical infrastructures, and system integration. He is
responsible for pre/post sales technical consulting for DB2 on zSeries in the West region. Kevin draws on
a wide range of experience from 23 years of involvement with DB2 on large systems, with 17 of those years
at IBM as a DB2 technical specialist. Kevin has served as a DB2 educator, led many DB2 design/implementation
reviews, and DB2/zSeries performance and tuning engagements. Kevin serves as an IBM liaison to several
regional DB2 user groups. Kevin is certified in several disciplines for DB2 on z/OS and currently is a member
of the IBM North American I/T Architect Certification board, IBM zChampions, IBM Americas Data Management
technical competency, and the DB2 for z/OS Performance review board.
Click here for a PDF copy of this presentation.
Extreme SQL and Object Tuning for Performance
Sheryl Larsen, Sheryl M. Larsen, Inc.
This presentation will examine traditional and extreme methods for altering optimizer chosen access paths and objects.
IBM warranted tuning methods such as OPTIMIZE FOR 1 ROW, no operations, REOPT(VARS), as well as additional methods,
such as fake filtering, table expressions and views, will be demonstrated. Extreme Cross Query Block Optimization
techniques, X2QBOPT will be demonstrated for extreme situations. The how to tune SQL is usually easy, however, sometimes
drastic situations demand extreme measures.
Sheryl M. Larsen performs SQL performance reviews for many clients, is an internationally recognized researcher, consultant
and lecturer, and is known for her extensive expertise in SQL. She has over 20 years experience in DB2, published many articles,
several popular DB2 posters, and co-authored, DB2 Answers, Osborne-McGraw-Hill, 1999, and will co-author a new book,
in 2006 Design Patterns: Data Strategies for Performance. She is frequently asked to keynote DB2 world wide events.
She is an IDUG "Hall of Fame" speaker, President of the Midwest Database Users Group (www.mwdug.org), and a member of
IBM's DB2 Gold Consultants program.
Link to Sheryl Larsen's home page
|
Colorado DB2 Users Group For z/OS