Customer Reviews

DB2(R) Universal Database V8 Handbook for Windows, UNIX, and Linux (IBM Press Series--Information Management)

5 star:		(15)
4 star:		(0)
3 star:		(0)
2 star:		(1)
1 star:		(0)

 

 

I really like the inside tuning tips and recommendations. A lot of other books describe parameters, but do not really give a recommendation. In this book you'll find many recommendations, not many it depends. For a first edtion, it is well done. I'm sure the next edition will have even more details and examples. I use this book and the Adv. Cert Guide for all my work.

This book is written by a DBA for DBAs. Their is no hemming and hawing in this book when it comes to actual tuning recommendations. The author has done a good job at imparting his knowledge to us. This is knowledge he has won in the trenches on our behalf. Im glad Phil included Chapte3 on Logical and physical design. I can use it to show my manager how it should be done. The chapters on Type-2 indexes, tuning bufferpools, including the new block-based bufferpools, the Chapter on SQL tuning makes it very clear on how to identify, tune SQL, or create indexes to eliminates all those sorts that I dind in my Peoplesoft and Siebel systems running rampant. This book tells you about all the new features in V8 and tell's you how to use them. It is a good mixture between V8 enhancements and contains extensive tuning techniques, methodologies, and good examples where needed. You need to have this book to tune-up your databases. I also like Snow's book for the day to day admin tasks. I can't wait for the second edition of this book to come it, cause you know it will just build on the wealth of information provided in the 1st edition.

The chapters on Type-2 indexes and MDC really helped me better understand how type-2 indexes improve performance now I understand what a dimension is and how to identify good candidate dimensions. The chapter on buffer pool tuning and Sort along with the DBM and DB CFG tuning tips have helped get my boss off my back!This is a great book by a DB2 Consultant.

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.

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.

I've heard Phil speak and present and this book just builds on the excellent material Phil's provided in the past. It is a complete reference for monitoring and tuning DB2. If you need to know how to tune DB2 and what to look for, this book is for you.

I found the tuning advice for DB CFG parameters and tuning sort to be verfy helpful. The sort chapter cleared up misunderstandings I had on sort. The information on type-2 indexes was really good. Chapter 10, Monitoring, is the best reference I have found on how to use and interpret monitoring output in solving performance problems.

This book has really helped me understand DB2. Coming from a Sybase background, I didn't know where to start. The DB CFG, bufferpool and sort tuning information helped me get up to speed quick. This book contains information I couldn't find anywhere else.

If you are coming from mainframe DB2, this is the book for you. Phil Gunning does a great job of explaining the many parameters and settings that make up DB2 UDB. Explanations are clear and straight to the point. It helped me to understand the DB2 UDB architecture and to get up to speed quick.

This book has helped my get started on monitoring and tuning my databases. Coming from Sybase, I had no idea where to start. I picked up this book and it guided me through all the monitoring setups and provided a monitoring and tuning methodology -- along with recommendations. This stays on my desk and is very handy.