Home • Message Board • Membership • Mailing List • Downloads • Meeting Info

Meeting Information for March 2004

The next meeting of the LA Area DB2 User Group will be held on March 4, 2004 at the Sheraton Cerritos. The meeting room will open at 8:00am for coffee and refreshments with the meeting beginning at 8:30am. This is a full day meeting with a catered lunch and hosted by Quest Software. We will have 2 presentations, the first by Chuck Sodowsky from Quest and the second by Sheryl M. Larsen.

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: Chuck Sodowsky - Quest Software

Chuck Sodowsky is currently the Product Marketing Manager for database products at Quest Software.

 He has worked with DB2 since 1990 and has held many roles including developer, DBA, Presales Systems Consultant, as well as Presales Director.

Representing various database tools vendors for the last 12 years, Chuck has given countless technical and product presentations centered around database management at numerous user groups and trade shows including IDUG and the IBM DB2 Technical Conference.

PRESENTATION:  Similarities & Differences between DB2, Oracle and SQL Server

Everyday,  DBA's are being asked to do more with less. In today's economy, it has become commonplace for Oracle DBAs to also manage Microsoft SQL Server databases. Even DB2 mainframe DBAs are expected to administer DB2 as well as other databases on UNIX and NT. This presentation addresses the similarities as well as the differences between DB2, Oracle, and Microsoft SQL Server as well as the challenges faced by the heterogeneous DBA.


PRESENTER: Sheryl M. Larsen - Sheryl M. Larsen, Inc.

Sheryl M. Larsen is president and founder of Sheryl M. Larsen, Inc.(www.smlsql.com), a firm specializing in Advanced SQL Consulting and Education.

She is an internationally recognized researcher, consultant and lecturer, specializing in DB2 and is known for her extensive expertise in SQL.

Sheryl has over 19 years experience in DB2, has published many articles, several popular DB2 posters, and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999.

She was selected as a keynote speaker for the IDUG Asia Pacific 2002 Conference and is frequently asked to keynote DB2 tool vendor's world wide events.

She was voted into the IDUG "Speaker Hall of Fame" in 2001 and was the Executive Editor of the IDUG Solutions Journal magazine 1997-2000.

Currently, she is President of the Midwest Database Users Group (www.mwdug.org), and a member of IBM's DB2 Gold Consultants program.

PRESENTATION:  DB2 Optimization

This seminar will examine traditional and  innovative methods for altering the DB2 optimizer's chosen access paths.

This will include IBM suggested tuning methods such as OPTIMIZE FOR 1 ROW, no operations, REOPT(VARS), additional methods, such as fake filtering and table expressions, will also be demonstrated.

Creative techniques will be demonstrated for extreme situations. The how to tune SQL is usually easy, however, sometimes drastic situations demand extreme measures.

BACK TO THE HOME PAGE

 

Created and maintained by DataDoneRight.Com Copyright 2004. All rights reserved. Last revised:08/03/04

Home • DB2 Links • 2004 Steering Committee • A legacy of excellence