Skip to main content

 
Professional certification

  >  
Certifications

  >  
Test information

Test 704: DB2 V8.1 for Linux UNIX and Windows Advanced Database Administration


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

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 Universal Database. This person is capable of performing the advanced tasks such as performance, high availability, and networking that are required. 

Section 1 - Advanced Administration (32%)

  1. Ability to design table spaces
  2. Ability to create table spaces
  3. Ability to manage table spaces
  4. Ability to design buffer pools
  5. Ability to create buffer pools
  6. Ability to manage buffer pools
  7. Ability to exploit intra-parallelism
  8. Ability to exploit inter- parallelism
  9. Ability to design and configure federated database access
  10. Ability to manage distributed unit of work

Section 2 - High Availability (19%)

  1. Ability to develop a logging strategy
  2. Ability to use advanced backup features
  3. Ability to use advanced recovery features
  4. Ability to implement a standby database (log shipping, replication, failover, fault monitor)

Section 3 - Performance and Scalability (37%)

  1. Identify and use configuration parameters that affect database system performance
  2. Identify and use DB2 registry variables that affect database system performance
  3. Knowledge of query optimizer concepts
  4. Ability to manage and tune memory and I/O
  5. Ability to analyze performance problems
  6. Ability to manage a large number of users and connections
  7. Ability to partition large amounts of data for performance
  8. Ability to manage the number of partitions in a database
  9. Ability to create and manage multi-dimensional clustered tables
  10. Ability to determine the more appropriate index

Section 4 - Networking & Security (12%)

  1. Ability to configure a partitioned database on multiple servers
  2. Ability to manage connections to host systems
  3. Ability to identify and resolve connection problems
  4. Knowledge of external authentication mechanisms
  5. Ability to implement data encryption

Test registration

Authorized Prometric test centers (worldwide testing)