DB2 High Performance Design and Tuning

Improve the performance of any IBM DB2 database with expert Version 6.x and 7.0 tuning techniques! The only all-in-one, start-to-finish guide to maximizing DB2 performance! Top 20 DB2 Performance Myths-and what to do about them Includes exclusive, in-depth coverage of DB2 Versions 6.x and 7! Tuning for the DB2 designers, developers and administrators Design and tuning for robust e-commerce functionality Foreword by Roger Miller, IBM Lead DB2 Strategist This is the most comprehensive, practical DB2 optimization guide ever published! World-renowned DB2 consultants Richard Yevich and Susan Lawson cover all aspects of DB2 performance tuning: hardware, physical design, application coding, SQL, stored procedures, triggers, Java, and beyond. Review I/O, storage management, SMS usage, CPU tuning, memory tuning, and bufferpool design. Master every key DB2 database design optimization, including indexing, code and reference tables, and supporting the DB2 Catalog and Directory. Discover start-to-finish application development techniques proven to deliver outstanding performance, including commit strategies, application interfaces, and superior SQL coding techniques. Top 20 DB2 Performance Mythsand what to do about them! Based on hands-on experience at hundreds of DB2 installations Includes hands-on, in-depth coverage of data sharing and DB2 Version 7! For developers, designers, and DBAs From OLAP to OLTP, e-business to high availability, troubleshooting to long-term monitoring, this book covers it all. You'll be amazed at how much more performance you can squeeze out of your DB2 systemwith DB2 High Performance Development & Tuning!Yevich, Richard A. is the author of 'DB2 High Performance Design and Tuning' with ISBN 9780132037952 and ISBN 0132037955.