C2090-600 IBM DB2 11.1 DBA for LUW Exam Overview
"Please visit at www.certsmaster.com or email us at [email protected]
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"