Description

This intermediate level certification is intended for those who understand the DB2 11.1 technology and have the skills required in the day-to-day administration of DB2 instances and databases. To attain the certification, candidates must pass two tests. To gain additional knowledge and skills, and prepare for the tests based on the job roles and test objectives, click on the link to the test below and refer to the Test Preparation tab,

Requirements

Exam C2090-600: IBM DB2 11.1 DBA for LUW

Exam Objectives

Please note this exam has been withdrawn

Number of questions: 60

Number of questions to pass: 38

Time allowed: 90 minutes

Status: Withdrawn

Section 1: Business Rules Implementation10%

Create and modify table constraints

Enforce constraint checking with the SET INTEGRITY command

Create and use triggers

Section 2: DB2 Server Management15%

Configure and manage DB2 servers, instances, and databases

Create and manage database storage paths

Exploit autonomic features

Explain the functionality of WLM

Describe the capabilities of Data Server Manager

Section 3: High Availability13%

Perform database-level and table space level backup and recovery operations

Configure and manage HADR

Implement a DB2 pureScale environment

Section 4: Monitoring DB2 Activity12�monstrate the proper use of monitoring tools

Use the DB2 Problem Determination tool (db2pd)

Describe the capabilities of dsmtop

Capture and analyze EXPLAIN information

Section 5: Physical Design22%

Implement BLU Acceleration

Describe DB2 pureScale enhancements

Create, manage, and alter DB2 objects

Demonstrate the proper use of compression

Describe the SQL compatibility available

Describe the partitioning capabilities available

Section 6: Security15%

Explain the use of LDAP authentication

Create and use trusted contexts

Restrict access to sensitive data

Explain how to encrypt data in transit and data at rest

Configure and use the Audit facility

Section 7: Utilities13% demonstrate the proper use of DB2’s data movement utilities

Demonstrate the proper use of REORG, REORGCHK, REBIND, RUNSTATS, FLUSH PACKAGE CACHE, and ADMIN_CMD

Perform an INPLACE table REORG

Demonstrate the proper use of db2look and db2move