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

Reseña del editor

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.

Contraportada

• 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.