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

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 spacesAbility to design, create, and manage buffer poolsWhen and how to exploit parallelism in DB2 UDBConfiguring federated database accessDesigning and implementing a backup and recovery strategyAbility to implement a standby databaseMonitoring and tuning DB2Using and managing tables with multidimensional clusteringDesigning and configuring multiple database partitionsImplementing authentication and encryption on a large scaleLeveraging parallelism and symmetric multiprocessingPreparing for and executing recovery in an enterprise environmentRapid recovery in the event of table space or table level disastersEffective monitoring and problem determinationMaximizing performance and scalabilityAbout 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.