Advanced DBA Exam - Now available!
svisser1 2700018UK9 Comments (2) Visits (2143)
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 part
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 perf
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., db2d
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