An IBM Certified Advanced Database Administrator is the lead DBA for the DB2 products on one or more of the following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows. This individual has extensive experience as a DBA and extensive knowledge of DB2 9. This person is capable of performing the advanced tasks such as performance, high availability, security and networking that are required.
To earn an IBM Certified Advanced Database Administrator Certification for DB2 9, you must pass the following exams:
1) Exam 734 - DB2 9 for Linux, Unix and Windows Advanced Database Administrator2) EITHER Exam 736 - Upgrade Exam for DB2 9 for Linux, Unix and Windows Database Administrator OR Exam 731 - Full Exam for DB2 9 for Linux, Unix and Windows Database Administrator3) EITHER Exam 700 - DB2 V8 Family Fundamentals OR Exam 730 - DB2 9 Fundamentals (Either exam is acceptable as a pre-requisite.) The test contains six sections with 51 multiple-choice questions. You must score 64% or greater to pass the exam. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Database Design - 14%Ability to design, create and manage table spacesAbility to design, create and manage buffer poolsAbility to design and configure federated database access
Section 2 - Data Partioning and Clustering - 15%Ability to design, create, and manage database partitioningAbility to design, create and manage multi-dimensional clustered tablesAbility to design, create, and manage table partitioningKnowledge of Balance Configuration Unit (BCU)
Section 3 - High Availability and Diagnostics - 20%Ability to manage database logs for recoveryAbility to use advanced backup featuresAbility to use advanced recovery featuresAbility to enhance database availabilityAbility to use diagnostic tools (db2pd, db2mtrk, inspect, db2dart, db2diag)
Section 4 - Performance and Scalability - 33%Identify and use DB2 registry variables that affect database system performanceIdentify and use configuration parameters that affect database system performanceKnowledge of query optimizer conceptsAbility to manage and tune database, instance and application memory and I/OAbility to use Data CompressionAbility to analyze performance problemsAbility to manage a large number of users and connectionsAbility to determine the more appropriate indexAbility to exploit parallelism
Section 5 - Security - 8%Knowledge of external authentication mechanismsAbility to implement data encryptionAbility to implement Label Based Access Control (LBAC)Ability to use DB2 Audit
Section 6 - Connectivity and Networking - 10%Ability to configure client server connectivity (e.g., db2discovery)Ability to manage connections to host systemsAbility to identify and resolve connection problems
Assessment ExamsTake the Assessment Exam for Exam 734 to gauge your readiness. There is a $10.00 fee per assessment test.
Schedule Your ExamIBM exams are offered worldwide at Prometric and VUE Testing Centers.
Explore Study ResourcesYou can choose from the number of recommended books, self-study tutorials and classroom courses that are available to assist you with your certification preparation.
There aren't any specific books planned at this time to help you prepare for this exam, but it is one of the books that I am pushing for. I have an author team that is working on a proposal, so stay tuned. The following books have some sections that will help you learn the required topics:
IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton
Understanding DB2 9 Security by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
DRAFT: High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows
Recommended Reading List - a series of useful article Groups of articles are separated by topic to help you quickly find a series of articles that can provide needed insight into the topics.
Title: DB2 9 for LUW Performance Tuning Monitoring WorkshopNumber: CF41Length: 4 Days
Title: DB2 UDB Advanced DBA for ExpertsNumber: CF46Length: 5 Days
Title: DB2 for LUW Quickstart for Experienced Relational DBAsNumber: CF48Length: 4 Days
Title: DB2 Advanced Recovery for Single Partition DatabasesNumber: CF49Length: 4 Days
The developerWorks Connections platform will be sunset on January 2, 2020. This blog will no longer be available unless an extension has been requested. More details available on our FAQ.