Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows - Softcover

Snow, Dwaine; Phan, Thomas Xuan

Softcover

ISBN 10: 0130463884 ISBN 13: 9780130463883

Publisher: IBM Press, 2003

Synopsis

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.

About this title

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.

Edition details

• Publisher: IBM Press
• Publication date: 2003
• ISBN 10: 0130463884
• ISBN 13: 9780130463883
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 800