Skip to main content

 
Professional certification

  >  
Certifications

  >  
Test information

Test 736: DB2 9 Database Administrator for Linux UNIX and Windows Upgrade


Overview Objectives alt="" height="1" width="30" Test Preparation

The test contains six sections totalling approximately 38 multiple-choice questions.  The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Server Management (29%)

  1. Understand the functionality of AUTOCONFIGURE
  2. Ability to manually configure communications (protocol image(IPV6))
  3. Ability to enable automatic maintenance
  4. Ability to enable Self Tuning memory Manager
  5. Ability to enable Utility Throttling

Section 2 - Data Placement (21%)

  1. Ability to CREATE DATABASE (new default behavior)
  2. Ability to create and manage Automatic Storage tablespaces
  3. Knowledge of Table Partitioning
  4. Knowledge of Data Row Compression

Section 3 - XML Concepts (13%)

  1. Ability to use XML Data types
  2. Ability to create and manage XML indexes
  3. Ability to use basic XML functions (XMLPARSE, XMLSERIALIZE, XMLVALIDATE, XMLQUERY)
  4. Understanding XQuery fundamentals
  5. Using DB2 Utilities with XML data

Section 4 - Analyzing DB2 Activity (16%)

  1. Ability to use DB2 Utilities (db2bfd, db2mtrk, db2pd)
  2. Ability to monitor deadlocks
  3. Ability to use Adminstrative routines and SNAPSHOT functions

Section 5 - High Availability (10.5%)

  1. Ability to use RECOVER DATABASE command
  2. Knowledge of High Availablity Disaster Recovery (HADR)

Section 6 - Security (10.5%)

  1. Understanding of Label Based Access Control (LBAC)
  2. Knowledge of new authentication types
Test registration

Authorized Prometric test centers (worldwide testing)