 | |
| |
DB2 UDB v8 Handbook for Windows and UNIX/Linux
 |
Author: Philip K. Gunning
List Price: $59.99
Our Price: Click to see the latest and low price
ISBN: 0130661112
Publisher: Prentice Hall PTR (06 August, 2003)
Edition: Paperback
Sales Rank: 57,530
Average Customer Rating: 4.67 out of 5
|
Customer ReviewsRating: 5 out of 5
A DB2 Book that will make you Rock!
I bought this book to find out the latest and greatest with V8, but found all kinds of tuning information as well. After reading this book I can now tune bufferpools, SQL and a whole suite of DBM and DB CFG parameters. The chapter on Type-2 indexes really helped me to understand them and there is also a migration plan presented. And the chapter on logical and physical design remind me how a database should be designed. I've already shared that with my data modelers. I'm very impressed with the details in this book. Heck, I carry it with me since all the DB2 catalog tables are in Appendix A. And lastly, the chapter on monitoring on SQL Snapshot functions, with details on how to insert the output into an SQL Snapshot repository, along with the new event monitor write-to-table capability, has given me the capability to truly have a historical respository of performance data.
Rating: 5 out of 5
This book is the best book written on DB2 by a DB2Guru
The chapter on DPF was key for me. I'm getting into partitioning and didn't know where to start. Well, Chapter 13 took me through it step by step. I also think the chapters on tuning bufferpools, SQL, and SORTs are the best I've found. They actually work. My databases are running faster than every before. And the chapter on Type-2 indexes was just what I was looking for. It describes type-2 indexes in detail, and I could easily understand them. I really like Appendix A, DB2 Catalog tables, I refer to this appendix all the time. Hat's off to Phil Gunning for writing such a great book.
Rating: 5 out of 5
Top book on how to use and tune new v8 features
This book is just great for helping short handed DBAs quickly get up to speed on V8. The chapter on Type-2 indexes clearly points out how to implement and monitor them, along with the perforomance benefits. The Chapter on tuning cfg parameters provides recommendations based on actual experience, the chapter on tuning buffer pools, sorts, and SQL are invaluable for me to be able to support my production databases. The chapter on utilities is up to date with all the added V8 features, along with tips on what to use and exploit. Well written by a real guru.
Similar Products
· Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
· DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (5th Edition)
· DB2 Version 8: The Official Guide
· DB2 SQL Procedural Language for Linux, Unix and Windows
· DB2 Universal Database v8 Application Development Certification Guide, Second Edition
| | | | | |
| |
