Product Description

This book contains practice exams, plus detailed answers and explanations, covering every concept and technique for the advanced DBA Certification. Topics covered will include: advanced administration, high availability backup and recovery, performance tuning and scalability, networking and security, how to manage a large number of users and connections and large amounts of data, authentication, and encryption. People will need to pass the Fundamentals and DBA exams before they can take the Advanced DBA. IBM estimates that a large percentage of those who take the regular DBA exam will go on to seek Advanced DBA certification since the information covered with the Advanced DBA material will greatly improve their skills.

---

Product Details

• Amazon Sales Rank: #431640 in Books
• Published on: 2003-07-17
• Original language: English
• Number of items: 1
• Binding: Paperback
• 800 pages

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 supportworkloads from Web-based transactions up to multiterabyte data warehouses. Snow is theproduct manager for DB2 partitioned databases and is co-author of The DB2 ClusterCertification Guide.

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

---

Customer Reviews

Absolutely the best DB2 book!
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.

Excellent book
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.

Excellent book out of the Toronto Lab
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.