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

Philip K. Gunning (Author)

Book Description

Series: IBM Press Series--Information Management | Publication Date: August 4, 2003

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.

Editorial Reviews

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.

Product Details

• Paperback: 496 pages
• Publisher: IBM Press (August 4, 2003)
• Language: English
• ISBN-10: 0130661112
• ISBN-13: 978-0130661111
• Product Dimensions: 9.3 x 7 x 0.8 inches
• Shipping Weight: 1.5 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #2,155,824 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars A fine job.Reads like a fine wine, and has loads of tips!, April 6, 2004

By 

Rick Anowitl (Austin,TX USA) - See all my reviews

This review is from: DB2(R) Universal Database V8 Handbook for Windows, UNIX, and Linux (IBM Press Series--Information Management) (Paperback)

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.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Written by top DB2 GURU in the Industry, and You Can Tell!, March 7, 2004

By 

Chris Jones (Columbus, OH) - See all my reviews

This review is from: DB2(R) Universal Database V8 Handbook for Windows, UNIX, and Linux (IBM Press Series--Information Management) (Paperback)

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.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Straight and to the Point, May 11, 2004

By A Customer

This review is from: DB2(R) Universal Database V8 Handbook for Windows, UNIX, and Linux (IBM Press Series--Information Management) (Paperback)

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.