The next LAADB2UG meeting will be on November first at the the Sequoia Conference Center in Buena Park. Refreshments at 8:30 and the presentations to run from 9:00 until about noon.
Directions: The Sequoia Conference Center is located at 7530 Orangethorpe Avenue, Buena Park, CA. Telephone is (714) 670-9252. It is one block north of the 91 Freeway at the Beach Boulevard exit (same exit as for Knott�s Berry Farm). The Presentation; DB2 Version 7 Impacts on Performance This presentation will cover the new enhancements to DB2 that are in Version 7. Version 7 provides many enhancements for database and system productivity. These enhancements include restart 'light', statistics history, dynamic DSNZPARMS, and several utility enhancements such as online Load Resume, Parallel Load, and Unload. There are also application enhancements such as Fetch First n Rows, Single Index Support for Max/Min, Union Everywhere (Views, Table Expressions), Commit/Rollback in a Stored Procedure. Many of these enhancements provide significant performance gains, but there are some caveats to their usage and these will be discussed. The Speakers are Richard Yevich and Susan Lawson; Richard Yevich is an internationally recognized consultant, lecturer and teacher known for his expertise in enterprise information systems. He specializes in e-commerce, warehouse, and distributed relational systems across multiple platforms, and in establishing proper design to achieve high performance and high availability. Richard is widely published and has written columns for several magazines. Richard was formerly a senior consultant with Codd and Date, Inc. He is a regular guest speaker at conventions and user groups in the U.S., Australia, Japan and Europe, and has won best speaker awards for many of these. Richard is a member of the IBM Gold Consultants programs for software and S/390, and is an IBM Certified DBA for DB2 UDB Version 7 for OS/390. He is one of the authors of Data Warehouse Practical Advice From the Experts published by Prentice-Hall, DB2 Answers! Published by Osborne/McGraw-Hill, DB2 High Performance Design and Tuning published by Prentice-Hall and DB2 UDB for OS/390 Version 7 Certification Guide published by Prentice-Hall. Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration. In the past, she has been an IBM Data Sharing advocate where she supported a variety of large DB2 customers. She provided technical expertise for migration to DB2 Data Sharing in a Parallel Sysplex environment, as well as troubleshooting performance problems during post-implementation. She currently works with several clients to help development, implement and tune some of the worlds largest and most complex DB2 databases. Her other activities have included authoring articles, presenting at user group meetings (where she has won best speaker awards), and providing technical editing for trade journals. She is an IBM GOLD Consultant for DB2 and S/390, and is an IBM Certified DBA for DB2 UDB Version 7 for OS/390 . She is one of the authors of DB2 Answers! Published by Osborne/McGraw-Hill, DB2 High Performance Design and Tuning published by Prentice-Hall, and DB2 UDB for OS/390 Version 7 Certification Guide published by Prentice-Hall. The website is www.laadb2ug "WorldSecure Server <safeway.com>" made the following annotations on 10/22/01 12:09:18 ------------------------------------------------------------------------------ Warning: All e-mail sent to this address will be received by the Safeway corporate e-mail system, and is subject to archival and review by someone other than the recipient. This e-mail may contain information proprietary to Safeway and is intended only for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately. ============================================================================== ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
