Product Description

Straight from IBM, this is the only book to offer complete, start-to-finish coverage of DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, including: database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. The book contains an extensive collection of IBM's most useful tips and tricks, designed to save DBAs and developers time and money -- while at the same time optimizing database performance and availability. DB2 Version 8 represents one of the most feature-packed significant releases in DB2's history! With Version 8 key topics such as Performance Enhancements, Manageability Enhancements, etc are addressed. The IBM Press DB2 series presents not only the new features in Version 8, but also gives technical details about the new features, tips and tricks, and detailed examples.

Product Details

• Amazon Sales Rank: #360798 in Books
• Published on: 2003-08-04
• Original language: English
• Number of items: 1
• Binding: Paperback
• 496 pages

From the Back Cover

IBM DB2 Universal Database V8 offers breakthrough availability, manageability, performance, and scalability. Now, straight from IBM, there's a start-to-finish guide to DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows.

This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, including database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more.

Using real-world examples, this book shows how to take full advantage of DB2 V8's most powerful enhancements. Philip K. Gunning brings together IBM's best tips and techniques for saving time and money in every facet of database design, development, deployment, and administration.

Coverage includes:

• Leveraging DB2 V8's new Wizards, Advisors, and other automation/self-management features
• Using the enhanced DB2 XML Extender to build next-generation B2B applications
• Quickly creating Stored Procedures and UDFs with the new Development Center
• Exploiting multidimensional clustering, prefetching, materialized query tables, Java threading, and other performance improvements
• Using the DB2 improved monitoring and logging facilities
• Maximizing availability via online table and index reorganization and dynamic configuration
• Understanding the latest changes in the DB2 product family

About the Author

PHILIP K. GUNNING, Vice President of the Professional Services Division at DGI (Database-GUYS, Inc.), is responsible for the firm's DB2 UDB product training and consulting practices. A recognized expert on IBM DB2 database platform, he has earned IBM recognition as both a IBM Certified Advanced Technical Expert in DB2 database administration and as a DRDA IBM Certified Solutions provider.

Customer Reviews

A fine job.Reads like a fine wine, and has loads of tips!
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.

Written by top DB2 GURU in the Industry, and You Can Tell!
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.

Straight and to the Point
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.