DB2 Upgrade Exam - Now Available
svisser1 2700018UK9 Comments (7) Visits (3734)
As with Version 8, there are two different exams that you can take to upgrade to the V9 DBA Certification:
1) Exam 736 - IBM Certified Database Administrator for DB2 9 for Linux, Unix and Windows, Upgrade Exam2) Exam 731 - IBM Certified Database Administrator for DB2 9 for Linux, Unix and Windows, Full Exam
The Upgrade Exam 736 is only an option for candidates who are already certified as an IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows, but if you pass, will earn you the same certificate that you'd earn from passing Exam 731.
You must score 55% or greater to pass this exam.
Section 1 - Server Management (29%)
Understand the functionality of AUTO
Section 2 - Data Placement (21%)
Ability to CREATE DATABASE (new default behavior)Ability to create and manage Automatic Storage tabl
Section 3 - XML Concepts (13%)
Ability to use XML Data typesAbility to create and manage XML indexesAbility to use basic XML functions (XMLPARSE, XMLSERIALIZE, XMLVALIDATE, XMLQ
Section 4 - Analyzing DB2 Activity (16%)
Ability to use DB2 Utilities (db2bfd, db2mtrk, db2pd)Ability to monitor deadlocksAbility to use Adminstrative routines and SNAPSHOT functions
Section 5 - High Availability (10.5%)
Ability to use RECOVER DATABASE commandKnowledge of High Availablity Disaster Recovery (HADR)
Section 6 - Security (10.5%)
Understanding of Label Based Access Control (LBAC)Knowledge of new authentication types
Assessment ExamsThere isn't an Assessment Exam for Exam 736, but it is suggested that you take the Assessment Exam for Exam 731 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.
IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton
Expert Preparation for IBM Exam 730: DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders
DB2 9 DBA exam 731 prep, Part 1: Server management Learn skills that help you to properly manage your DB2 database servers. This tutorial provides information about data consistency, transactions and how they are initiated and terminated, and the use of locks.
DB2 9 DBA exam 731 prep, Part 2: Data placement Learn how to create DB2 databases, and about the mechanisms available for storing your tables, indexes, and data within the database. This tutorial focuses on partitioning, compression, and XML, which are all important performance and application development concepts that you need to know to store and access data quickly and efficiently.
DB2 9 DBA exam 731 prep, Part 3: Database access Take the various steps required to manage some of the objects within DB2. This tutorial includes overview information for topics such as indexes, constraints, referential integrity, and views.
DB2 9 DBA exam 731 prep, Part 4: Monitoring DB2 activity Become familiar with the different options a DBA has for tuning and configuring their DB2 environments. This tutorial shows you how to use the tools, functions, and applications available in DB2 9 that make this task much simpler.
DB2 9 DBA exam 731 prep, Part 5: DB2 utilities Find out what utilities are provided with DB2 servers for data movement and maintenance. This tutorial shows you how to extract data, populate tables, use the db2move, db2look and other commands, use the DB2 Control Center and much more.
DB2 9 DBA exam 731 prep, Part 6: High availability: Backup and recovery Learn how to protect your data using database backup and recovery. This tutorial explains the different methods of database recovery and logging, and how to use the backup, restore, and rollforward commands.
DB2 9 DBA exam 731 prep, Part 7: High availability: Split mirroring and HADR Learn how to use a split mirror to provide high availability and how to setup a high availability disaster recovery (HADR) system.
Title: DB2 Universal Database Administration WorkshopNumber: CF20 (Linux), CF21 (UNIX), CF23 (Windows)Length: 4 Days
Title: DB2 9 for Linux, UNIX, and Windows TransitionNumber: CG09Length: 3 Days
Title: Query XML Data with DB2 9Number: CG10Length: 2 Days
Title: Query and Manage XML data with DB2 9Number: CG13Length: 4 Days
Title: Fast Path to DB2 9 for Experienced Relational DBAsNumber: CF28Length: 3 Days