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