Advanced DBA Certification Guide and Reference for DB2® Universal Database v8 for Linux, UNIX, and Windows [Paperback]

Dwaine R. Snow (Author), Thomas Xuan Phan (Author)

Book Description

ISBN-10: 0130463884 | ISBN-13: 978-0130463883 | Publication Date: July 17, 2003

Straight from IBM, Advanced DBA Certification Guide and Reference for DB2 Universal Database v8for Linux, UNIX, and Windows is the definitive guide to enterprise-class DB2 v8 administration - andthe only authoritative self-study guide for IBM's new DB2 advanced DBA exam. Delivers proventechniques for enterprise-class security, user management, recovery, scalability, optimization,troubleshooting, remote administration, and more! CD-ROM: DB2 Universal Database v8 EnterpriseServer Edition trial version plus complete documentation.

Editorial Reviews

From the Back Cover

• Definitive preparation for Exam 704: DB2 UDB V8.1 Advanced Database Administration for Linux, UNIX, and Windows, which leads to an IBM Certified Advanced Database Administrator certification.
• Database design, performance monitoring and tuning, scaling for terabytes of data, high availability, enterprise-level security, and more.
• The appendices contain sample certification exam questions and answers.

Whether you're a long-time DB2 UDB professional or an experienced DBA who's migrated from another database platform, there's one sure way to demonstrate the highest level of skills in DB2 Universal Database administration: pass the challenging IBM DB2 Universal Database Advanced Database Administration Exam 704.

Now, there's a definitive guide to advanced DB2 UDB database administration that also delivers all the depth and insight you need to prepare for the tough new IBM exam. Straight from the DB2 experts at IBM, this book offers systematic and authoritative coverage of every exam objective and will serve as a reference after you have passed the test.

For the first time, this book brings together IBM best practices, techniques, tips, guidelines, and rules of thumb for virtually every aspect of advanced DB2 UDB v8 database administration-including all this and more:

• Ability to design, create, and manage table spaces
• Ability to design, create, and manage buffer pools
• When and how to exploit parallelism in DB2 UDB
• Configuring federated database access
• Designing and implementing a backup and recovery strategy
• Ability to implement a standby database
• Monitoring and tuning DB2
• Using and managing tables with multidimensional clustering
• Designing and configuring multiple database partitions
• Implementing authentication and encryption on a large scale
• Leveraging parallelism and symmetric multiprocessing
• Preparing for and executing recovery in an enterprise environment
• Rapid recovery in the event of table space or table level disasters
• Effective monitoring and problem determination
• Maximizing performance and scalability

About the CDThe accompanying CD-ROM contains the IBM® DB2® Universal Database Enterprise Server Edition Version 8.1, for Windows® Operating Environments, Evaluation Copy, plus DB2 UDB v8 Enterprise Server Edition documentation in PDF format.

About the Author

DWAINE R. SNOW has twelve years of experience implementing and tuning DB2 to support workloads from Web-based transactions up to multiterabyte data warehouses. Snow is the product manager for DB2 partitioned databases and is co-author of The DB2 Cluster Certification Guide.

THOMAS X. PHAN is an IBM Certified I/T Specialist in the IBM Data Management Consulting practice with over thirteen years of data processing experience. He specializes in relational database-related services including application design, logical and physical database design, and performance and tuning on numerous DB2 UDB platforms.

Product Details

• Paperback: 800 pages
• Publisher: IBM Press (July 17, 2003)
• Language: English
• ISBN-10: 0130463884
• ISBN-13: 978-0130463883
• Product Dimensions: 9.3 x 7 x 1.2 inches
• Shipping Weight: 2.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.9 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #1,809,714 in Books (See Top 100 in Books)
  • #59 in Books > Computers & Technology > Certification > Linux

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

5.0 out of 5 stars Absolutely the best DB2 book!, May 17, 2004

By A Customer

This review is from: Advanced DBA Certification Guide and Reference for DB2® Universal Database v8 for Linux, UNIX, and Windows (Paperback)

I just found this book, and after reading it wish I had found this years ago. This is the most comprehensive book on DB2 that I have ever seen. This book has already saved me a lot of time. The performance chapter is great and helped me improve the performance of my DB2 server by over 30% in less than a week.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Excellent book, May 12, 2004

By 

"ibmshiva" (Minneapolis) - See all my reviews

This review is from: Advanced DBA Certification Guide and Reference for DB2® Universal Database v8 for Linux, UNIX, and Windows (Paperback)

This is the book I was waiting for long on DB2UDB. This not only covers topics for certifications but also good (very good) reference material for all UDB DBAs on LUW platform.

2 of 2 people found the following review helpful:

4.0 out of 5 stars Excellent book out of the Toronto Lab, March 7, 2004

By A Customer

This review is from: Advanced DBA Certification Guide and Reference for DB2® Universal Database v8 for Linux, UNIX, and Windows (Paperback)

This book is the best book published on DB2 out of the Toronto Lab. Although it doesn't have the flair you can get with a book written by a consultant, The authors provide much more useful information that what you usually find in a book out of the developemnt lab. Usually, they just tell the party line. The authors have broken that mold and have done a really excellent job on new SQL snapshot functions. I'm building my snapshot repository as I write this. I use this book and Gunning's for all my DB2 needs. Boy and I a happy camper with these two books on my deskstop. I have to keep them from disappearing. I rated this 4 stars as it still had the company line to some extent. Great book though.