Description

This intermediate degree certification is meant for individuals who apprehend the DB2 11.1 era and feature the abilties required withinside the every day management of DB2 times and databases. To achieve the certification, applicants have to byskip  checks. To benefit extra information and abilties, and put together for the checks primarily based totally at the process roles and take a look at objectives, click on at the hyperlink to the take a look at beneath and check with the Test Preparation tab,

Requirements

Exam C2090-600: IBM DB2 11.1 DBA for LUW

Exam Objectives

Please be aware this examination has been withdrawn

Number of questions: 60

Number of inquiries to byskip: 38

Time allowed: 90 minutes

Status: Withdrawn

Section 1: Business Rules Implementation10%

Create and adjust desk constraints

Enforce constraint checking with the SET INTEGRITY command

Create and use triggers

Section 2: DB2 Server Management15%

Configure and manipulate DB2 servers, times, and databases

Create and manipulate database garage paths

Exploit autonomic features

Explain the capability of WLM

Describe the abilties of Data Server Manager

Section 3: High Availability13%

Perform database-degree and desk area degree backup and restoration operations

Configure and manipulate HADR

Implement a DB2 pureScale environment

Section 4: Monitoring DB2 Activity12�monstrate the right use of tracking tools

Use the DB2 Problem Determination tool (db2pd)

Describe the abilties of dsmtop

Capture and examine EXPLAIN information

Section 5: Physical Design22%

Implement BLU Acceleration

Describe DB2 pureScale enhancements

Create, manipulate, and modify DB2 objects

Demonstrate the right use of compression

Describe the SQL compatibility available

Describe the partitioning abilties available

Section 6: Security15%

Explain using LDAP authentication

Create and use relied on contexts

Restrict get admission to to touchy information

Explain the way to encrypt information in transit and information at rest

Configure and use the Audit facility

Section 7: Utilities13�demonstrate the right use of DB2’s information motion utilities

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

Perform an INPLACE desk REORG

Demonstrate the right use of db2look and db2move