1. Home
  2. IBM
  3. C2090-600 Exam Syllabus

IBM C2090-600 Exam Syllabus

Start Free C2090-600 Exam Practice After Reviewing the Topics

Before starting your C2090-600 exam preparation, it is recommended to review the complete IBM DB2 11.1 DBA for LUW exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free C2090-600 questions. We also provide premium C2090-600 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

IBM C2090-600 Exam Objectives

Section Weight Objectives
DB2 Server Management 15%
  • 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
Physical Design 22%
  • 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
Business Rules Implementation 10%
  • Create and modify table constraints
  • Enforce constraint checking with the SET INTEGRITY command
  • Create and use triggers
Monitoring DB2 Activity 12%
  • Demonstrate the proper use of monitoring tools
  • Use the DB2 Problem Determination tool (db2pd)
  • Describe the capabilities of dsmtop
Capture and analyze EXPLAIN information Utilities 13%
  • 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
High Availability 13%
  • Perform database-level and table space level backup and recovery operations
  • Configure and manage HADR
  • Implement a DB2 pureScale environment
Security 15%
  • 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
Official Information https://www-03.ibm.com/certify/exam.html?id=C2090-600