IBM 000-734 : DB2 9 Advanced Database Administrator for Linux UNIX and Windows Exam
IBM is presenting the 000-734 exam for Database Administrators who are finalizing their requirements for the IBM Certified Advanced Database Administrator-DB2 for Linux, UNIX, and Windows certification. Successful candidates will typically perform duties that include being the lead DBA for the DB2 products on multiple platforms such as Linux, UNIX, and Windows. Before enrolling in this certification path, candidates should have work experience that includes an extensive knowledge of DB2 9 and the ability to perform advanced tasks such as performance, high availability, security, and networking.
The IBM 000-734 (DB2 9 Advanced Database Administrator for Linux UNIX and Windows) is a 90-minute exam that contains 51 multiple-choice style questions. The questions are set up into six main topic sections. Below is a brief overview of each section that is intended as a general guide for preparation purposes:
Section 1-Database Design (demonstrate the ability to design, create, and manage table spaces, buffer pools, and federated database access).
Section 2-Data Partitioning and Clustering (Demonstrate the ability to design, create, and manage data partitioning, multi-dimensional clustered tables, and table partitioning).
Section 3-High Availability and Diagnostics (The ability to manage database logs for recover, use advanced backup and recovery features, and use of diagnostic tools).
Section 4-Performance and Scalability (query optimizer concepts, use of DB2 registry variables and configuration parameters, use of data compression, analyzing performance problems, managing large number of users and connections).
Section 5-Security (using DB2 audit, implementing data encryption and label based access control)
-Section 6-Connectivity and Networking (configuring client server connectivity, resolving connection problems, and managing connections to host systems).
Candidates are encouraged to participate in the DB2 courses that are available. Exam content will be based on work experience and material from IBM training events.