|
 |
|
 |
 |
DB2(R) High Performance Design and Tuning
|
by Richard A. Yevich and Susan Lawson
Sales Rank: 815749
|
$39.78
At Amazon
|
|
Hardcover: 736 pages
Publisher: Prentice Hall PTR; 2 edition August 24, 2000
Language: English
ISBN-10: 0132037955
ISBN-13: 978-0132037952
Product Dimensions:
9.5 x 7.4 x 2.1 inches
Shipping Weight: 3.5 pounds
Book Description
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 Myths and 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 system, with DB2 High Performance Development & Tuning!
Book Info
Comprehensive guide to optimizing DB2 performance. Covers all aspects, including hardware, physical design, stored procedures, triggers, and JAVA. The reader can also review storage management, CPU tuning, memory tuning, buffer-pool design and more. The reader can also learn application techniques that deliver high DB2 performance. DLC: IBM Database.
Customer Reviews & Comments
Book gives a great over view and lays out a common sense approach to performance. Each chapter opens up talking a good game but then falls short of the expectations that it has set. Book falls short by not covering the SQL Optimizer, how it works, or how to change the pre-bind parameters to influence it. Covers DB2 version 5-6 and mentions some things coming along in version 7. Book lists "Hints" but does not give definitions for each one nor the behavior that it should invoke. Performance tools, techniques, scripts, screenshots are all from the mainframe environment. The event monitor GUI on the windows 200 interface tells you how code is actually behaving instead of the SETEXPLAIN which makes estimates and guesses. The book never mentions the event monitor tool. (I like books that cover different implimentations.) Considering that this is the only performance book available for DB2, it's the best. I have an older Oracle performance book that most of my SQL Tuning/modeling techniques are based on. This DB2 book doesn't compare in depth or breadth. If your new to DB2 or to Tuning, this book could help you out. If you already know Tuning or another database, read the DB2 RedBooks at ibm.com, they're free.
Comment | Permalink |
(Report this)
|
DB2(R) High Performance Design and Tuning
Available from Amazon
Price: $39.78
| |
|
|
|
|
