Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows

Dwaine R. Snow, Thomas Xuan Phan9780130463883, 0130463884

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 scalability