Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: DB2 High Performance Design and Tuning by Richard A. Yevich, Susan Lawson ISBN: 0-13-203795-5 Publisher: Prentice Hall PTR Pub. Date: 24 August, 2000 Format: Hardcover Volumes: 1 List Price(USD): $54.99 |
Average Customer Rating: 3.4 (5 reviews)
Rating: 3
Summary: Falls Short
Comment: 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.
Rating: 4
Summary: DB2 High Performance Design and Tuning
Comment: This text has more insight than any other text I have read on tuning a mainframe DB2 system. The text sometimes seems disjointed, but in trying to cram all of the authors combined knowledge and experience into one text and trying to give it some order, is daunting. I would have to say this text rates a bit higher on the scale than DB2 Developer's Guide by Craig Mullins because it is not trying to cover all of the bases that Mr. Mullins is in his book. This is strictly for giving pointers on tuning DB2 in a mainframe OS/390 environment. I hope the authors combine their efforts and put out a true "DB2 for OS/390 Certification Guide" so we DB2 DBAs can train newcomers to the field. Their latest effort falls short of that.
Rating: 4
Summary: Mr. Yevich tells all
Comment: Now that I have your attention -- I must confess I have not yet seen this book. But Richard Yevich has consulted my organization on a complex DB2 system, and I would say that his collaboration on this book should guarantee useful insights.
Note that this book will likely be only for an mainframe environment. For Unix or NT, I would go with a book on the DB2 UDB version.
 |
Title: DB2 for Z/OS and Os/390 Development for Performance (Volume 1) by Gabrielle Wiorkowski ISBN: 0966846052 Publisher: Gabrielle & Associates Pub. Date: February, 2002 List Price(USD): $42.50 |
 |
Title: DB2 for Z/OS and Os/390 Development for Performance (Volume 2) by Gabrielle Wiorkowski ISBN: 0966846060 Publisher: Gabrielle & Associates Pub. Date: February, 2002 List Price(USD): $42.50 |
 |
Title: DB2 Answers! Certified Tech Support by Richard Yevich, Susan Lawson, Klaas Brant, Sheryl Larsen, Inc Ryc ISBN: 0072119144 Publisher: McGraw-Hill Osborne Media Pub. Date: 01 May, 1999 List Price(USD): $29.99 |
 |
Title: DB2: The Complete Reference (Complete Reference Series `) by Roman B. Melnyk, Paul C. Zikopoulos ISBN: 0072133449 Publisher: McGraw-Hill Osborne Media Pub. Date: October, 2001 List Price(USD): $59.99 |
 |
Title: Database Administration: The Complete Guide to Practices and Procedures by Craig S. Mullins ISBN: 0201741296 Publisher: Addison-Wesley Pub Co Pub. Date: 14 June, 2002 List Price(USD): $44.99 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
