C2090-612 Exam Dumps
IBM DB2 10 DBA for z/OS C2090-612 real exam questions and online practice test engine by FreeCram. Try C2090-612 exam questions for free. You can also download a free demo of the C2090-612 exam PDF version.
IBM's C2090-612 actual exam materials brought to you by FreeCram group of IBM certification experts.
View all C2090-612 actual exam questions & answers and explanations for free.
If you like our product, you can request full access to all the latest IBM DB2 10 DBA for z/OS C2090-612 exam premium questions.
| Certification Provider: | IBM |
|---|---|
| Exam Code / Number: | C2090-612 |
| Exam Name: | DB2 10 DBA for z/OS |
| Exam Questions: | 134 |
| Last Updated: | Jun 24, 2026 |
| Corresponding Certification: | DB2 |
(306 Up Votes)IBM C2090-612 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Performance | -Plan for performance monitoring by setting up and running monitoring procedures -Analyze performance -Analyze and respond to RUNSTATS statistics analysis -Determine when and how to perform REBIND -Calculate cache requirements for new applications -Understanding and implementing data distribution and replication -Describe DB2 interaction with WLM -Interpret traces and explain the performance impact of different DB2 traces -Identify and respond to critical performance metrics -Review and tune SQL -Dynamic SQL Performance -Design features for performance | 28.5% |
| Security and Auditing | -Understanding privileges and authorities -Protect access to DB2 and its objects -Audit DB2 activity and resources and identify primary audit techniques -Identify and respond appropriately to symptoms from trace output or error messages that signify security problems -Create and maintain roles and trusted contexts -Implementing column and row level authorizations | 9% |
| Database Design and Implementation | -Design tables and views -Explain the different performance implications of identity column, row ID, and sequence column definitions (applications, utilities), reorder row format, hash access -Design indexes -Design table spaces (choose a DB2 page size, clustering) and determine space attributes -Perform partitioning -Normalize data (E-R model, process model) and translate data model into physical model (denormalize tables) -Implement user-defined integrity rules -Use the appropriate method to alter DB2 objects -Create and Manage XML and LOB objects -Understand impacts of different encoding schemes -Implementing data distribution and replication | 30% |
| Installation and Migration / Upgrade | -Understand the critical ZPARMs -Identify the migration/upgrade modes -Identify & explain Datasharing components | 4% |
| Operation and Recovery | -Knowledge of commands for normal operational conditions -Knowledge of commands and utility control statements for use in abnormal conditions -Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically -Load and unload data into and from the created tables -Reorganize objects when necessary -Monitor the object by collecting statistics -Monitor and manage threads and utilities -Identify and respond to advisory/restrictive statuses on objects -Understanding the significance of checkpoints -Identify and perform problem determination -Perform health checks -Develop backup and recovery scenario -Describe the special considerations for recovery in a data sharing environment -Understand the concept of disaster recovery -Understanding the concept of virtual storage constraints and limitations | 28.5% |
IBM DB2 DBA for z/OS Exam Certification Details:
| Books / Training | New Functions and Features in DB2 11 for z/OS DB2 SQL Workshop |
| Passing Score | 60% |
| Exam Code | C2090-612 |
| Exam Price | $200 (USD) |
| Schedule Exam | Pearson VUE |
| Exam Name | IBM Certified Database Administrator - DB2 10 for z/OS |
| Sample Questions | IBM DB2 DBA for z/OS Sample Questions |
| Number of Questions | 67 |
| Duration | 90 mins |