The latest edition of certmag.com has an article about using advanced certifications to advance your career:
After reading this article, I checked our database to see the how many people have been certifed at our Advanced DBA level (you need to pass Exam 704 after achieving a DBA cert): http://www.ibm.com/certify/certs/dbdvud81.shtml.
Although I can't tell you how many certifications have been achieved, I can tell you that only 7% of those who have earned a IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows have also earned the Advanced DBA certification.
I really believe that anyone who has passed Exam 701 also has a good chance of passing Exam 704. If you are one of these people, take the challenge and try Exam 704.
Exam 704 contains a total of 57 questions. Candidates are required to score 56% or better to pass the exam and will have 75 minutes to complete the exam.
Section 1 - Advanced Administration (32%)
Ability to design table spaces
Ability to create table spaces
Ability to manage table spaces
Ability to design buffer pools
Ability to create buffer pools
Ability to manage buffer pools
Ability to exploit intra-parallelism
Ability to exploit inter- parallelism
Ability to design and configure federated database access
Ability to manage distributed unit of work
Section 2 - High Availability (19%)
Ability to develop a logging strategy
Ability to use advanced backup features
Ability to use advanced recovery features
Ability to implement a standby database (log shipping, replication, failover, fault monitor)
Section 3 - Performance and Scalability (37%)
Identify and use configuration parameters that affect database system performance
Identify and use DB2 registry variables that affect database system performance
Knowledge of query optimizer concepts
Ability to manage and tune memory and I/O
Ability to analyze performance problems
Ability to manage a large number of users and connections
Ability to partition large amounts of data for performance
Ability to manage the number of partitions in a database
Ability to create and manage multi-dimensional clustered tables
Ability to determine the more appropriate index
Section 4 - Networking & Security (12%)
Ability to configure a partitioned database on multiple servers
Ability to manage connections to host systems
Ability to identify and resolve connection problems
Knowledge of external authentication mechanisms
Ability to implement data encryption
The best way to prepare for this exam is a combination of EXPERIENCE and STUDY. The only book that was written for this exam is:
Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
by Dwaine Snow and Thomas Phan
Notice that this book has received 12 customer comments on amazon: all 5 stars, except one 4 star.
One of the features of this book that I want to make you aware of is that there are excellent sample study questions in the book. Each chapter contains several questions that are similar to the questions that you'll see on the certification exam. The authors then tell you which answer is correct, and why. Dwaine was on the exam development team and helped create many of the questions that are on the certification exam, so make sure you benefit from his knowledge by reading this book!