C2090-600: IBM DB2 11.1 DBA for LUW

Full Name: IBM DB2 11.1 DBA for LUW

Exam Code: C2090-600

Try Sample Exam »

IBM DB2 DBA for LUW Exam Summary:

Exam Name	IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows
Exam Code	C2090-600
Exam Price	$200 (USD)
Duration	90 mins
Number of Questions	60
Passing Score	63%
Sample Questions	IBM DB2 DBA for LUW Sample Questions
Practice Exam	IBM C2090-600 Certification Practice Exam

IBM C2090-600 Exam Syllabus Topics:

Topic	Details	Weights
Business Rules Implementation	- Create and modify table constraints - Enforce constraint checking with the SET INTEGRITY command - Create and use triggers	10%
DB2 Server Management	- 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	15%
High Availability	- Perform database-level and table space level backup and recovery operations - Configure and manage HADR - Implement a DB2 pureScale environment	13%
Monitoring DB2 Activity	- Demonstrate the proper use of monitoring tools - Use the DB2 Problem Determination tool (db2pd) - Describe the capabilities of dsmtop - Capture and analyze EXPLAIN information	12%
Physical Design	- 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	22%
Security	- 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	15%
Utilities	- 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	13%