- What This Exam Actually Covers
- The Domain Weight Map
- Domain 6: Application Design and Development (28%)
- Domain 2: Operations and Recovery (23%)
- Domain 4: Performance (17%)
- Domain 1: Database Design and Implementation (12%)
- Domain 5: Planning and Migration (12%)
- Domain 3: Security and Auditing (8%)
- Sequencing Your Preparation by Domain
- Exam Format and Booking Mechanics
- Frequently Asked Questions
- The exam has six domains; Application Design and Development is largest at 28%, followed by Operations and Recovery at 23%.
- You get 60 questions in 90 minutes and need 40 correct answers to pass.
- Security and Auditing carries only 8%, but Planning and Migration (12%) includes installation commands like ACTIVATE and START.
- IBM describes the intended candidate as a Db2 for z/OS DBA with three or more years of experience.
What This Exam Actually Covers
The IBM Certified Db2 13 for z/OS Database Administrator - Professional credential (exam C1000-181, credential C9006700) validates hands-on administration skills for Db2 13 running on z/OS. IBM lists it as a live credential and identifies C9006700 as replacing the earlier C0005400. If you are still orienting yourself on what the credential is, the overview in What Is C1000-181 Certification? covers the basics, and this article goes deeper into the six content areas that make up the blueprint.
IBM describes the target candidate as a database administrator with three or more years of experience and strong Db2 for z/OS knowledge. That framing matters for how you read the domains. The questions are written for someone who has actually run subsystems, recovered tablespaces, tuned access paths, and planned version migrations, not someone who has only read the manuals. The official study guide is eight pages and lists objectives under each of the six domain headings; the percentage weights come separately from IBM's certification-page outline and total 100%.
The Domain Weight Map
Before diving into each content area, it helps to see how the exam distributes its attention. The table below uses the six official domain names and the weights published in IBM's certification-page outline.
| Domain | Weight | Priority |
|---|---|---|
| Application Design and Development | 28% | Highest - study first and longest |
| Operations and Recovery | 23% | Very high - core DBA daily work |
| Performance | 17% | High - overlaps with design and development |
| Database Design and Implementation | 12% | Moderate |
| Planning and Migration | 12% | Moderate - narrow but command-specific |
| Security and Auditing | 8% | Lower weight, but still scored |
Two domains, Application Design and Development and Operations and Recovery, account for just over half the exam between them. Add Performance and you are at roughly two thirds of the questions. A candidate who is strong in those three areas has a real cushion, while a candidate who is weak in them cannot make it up by mastering the smaller domains. For a sense of how demanding that balance is in practice, see How Hard Is the C1000-181 Exam?
Domain 6: Application Design and Development (28%)
This is the largest content area, and it is the one most likely to surprise DBAs who have spent their careers on the operations side. The domain reflects a reality of Db2 for z/OS shops: the DBA is routinely the person who reviews SQL, advises developers on access patterns, and decides how applications interact with the database.
What candidates must understand
Expect scenario questions where you are handed a design or coding problem and must choose the best approach for correctness, concurrency, and efficiency.
- SQL design choices, including how statements are written and how they affect access path selection
- Locking and concurrency behavior as it affects application design, including isolation levels and commit frequency
- Static and dynamic SQL considerations, packages, and the bind process
- Stored procedures and user-defined functions as application building blocks
- Application-level handling of errors, cursors, and unit-of-work boundaries
Because this domain is so heavily weighted, treat it as the backbone of your preparation rather than an afterthought. The questions tend to be practical: given a described workload, which design decision is most appropriate? Candidates with a pure operations background should budget extra time here, because the best answers depend on understanding how developers actually write and deploy code against Db2.
Domain 2: Operations and Recovery (23%)
This domain covers the day-to-day running of Db2 subsystems and, critically, getting data back when something goes wrong. It is the territory most experienced Db2 for z/OS DBAs know best, which also means the questions can be precise about utility behavior, options, and restart or recovery sequencing.
High-value operations and recovery topics
Think in terms of what you would do on a real shift: monitor, maintain, and recover.
- Utility usage for maintaining data, including when each utility is appropriate and what it requires
- Backup and recovery strategies, including image copies, log usage, and recovery to a point in time
- Commands for controlling and displaying database objects and subsystem activity
- Dealing with restricted or pending states on objects and understanding how to clear them correctly
- Subsystem operations such as startup, shutdown, and restart considerations
Questions here often present a failure or restricted-state scenario and ask for the correct next step or the correct utility option. Knowing a utility's name is not enough. You need to know what it does to the object, what it locks, and what state it leaves behind. If you work primarily in a shop where another team handles recovery, make a point of studying recovery sequences end to end rather than relying on familiarity.
Domain 4: Performance (17%)
Performance is the third-largest domain and overlaps naturally with application design. Where Application Design and Development asks what a developer should write, Performance asks how a DBA diagnoses and improves what is already running.
What this domain rewards
Diagnostic reasoning: reading evidence, identifying the likely bottleneck, and choosing the corrective action.
- Access path analysis, including how the optimizer chooses paths and how statistics influence those choices
- Statistics collection and its relationship to bind and rebind decisions
- Indexing strategy and how index design supports or hurts query performance
- Buffer pool and memory-related tuning concepts
- Monitoring and tracing facilities used to find where time is being spent
Because performance questions are usually scenario-based, they reward candidates who have actually tuned a workload. A useful exercise is to take a poorly performing statement from your own environment and walk through each step: what the access path shows, what statistics exist, and what change you would make. That habit maps well onto how this domain frames its questions.
Domain 1: Database Design and Implementation (12%)
This domain covers how database objects are designed and created. It is the foundation that the operations, performance, and application domains all build on, which is why it is worth understanding even though it carries a moderate weight on its own.
Core design and implementation topics
Know the objects, their options, and the consequences of choosing one over another.
- Table, tablespace, and index design choices and the physical implications of each
- Data types, constraints, and referential integrity
- Partitioning approaches and when they make sense
- Creating and altering objects, including which changes are immediate and which require additional steps
- How design decisions affect later recovery, performance, and migration
One tip for this domain: do not study object definitions in isolation. Questions frequently hinge on the downstream effect of a design choice, such as how a tablespace type or partitioning decision changes what a later utility or alter operation can do.
Domain 5: Planning and Migration (12%)
Planning and Migration matters because this is a Db2 13 exam, and part of what IBM tests is whether you can plan the move to that version safely. The detailed study guide includes a Planning and Migration objective covering z/OS installation commands, including ACTIVATE and START, which the condensed online bullets omit. That is an easy detail to miss if you only skim the summary on the certification page.
Planning and migration focus areas
Think about the sequence of a version move and the commands and checks that support it.
- Migration planning and the order of steps involved in moving to Db2 13
- z/OS installation commands, including ACTIVATE and START, and what each accomplishes
- Understanding how new-function activation relates to the migration process
- Preparing applications and objects for a new version and verifying readiness
- Fallback and coexistence considerations during a staged migration
At 12%, this domain is not the biggest, but it is narrow and command-oriented, which makes it highly learnable. Candidates who drill the specific commands and their purposes can convert these questions into reliable points.
Domain 3: Security and Auditing (8%)
Security and Auditing is the smallest domain, but 8% of a 60-question exam is still a handful of questions, and they are often among the most straightforward points available if you know the model.
Security and auditing essentials
Focus on how authority is granted, controlled, and tracked.
- Privileges and authorities, including how they are granted and revoked
- Controlling access to data and objects
- Auditing facilities and what they record
- Understanding how security choices interact with applications and utilities
Do not skip this domain just because of its low weight. Security questions tend to be conceptual and rule-based, so they respond well to focused review rather than long hours of practice. A modest, targeted investment here protects you from losing easy points.
Sequencing Your Preparation by Domain
The domain weights suggest a natural order of attack. The goal is to spend time in proportion to weight while front-loading the areas where a gap would hurt most. The timeline below is one reasonable way to do that over six weeks; adjust it to your experience, and see the C1000-181 Study Guide for a fuller planning framework.
Application Design and Development
- Cover SQL design, locking, packages, and stored routines
- Highest weight at 28%, so start here while you are fresh
Operations and Recovery
- Review utilities, recovery sequences, and restricted states
- Walk through at least one full recovery scenario end to end
Performance plus Database Design and Implementation
- Pair access path analysis with the design choices that influence it
Planning and Migration plus Security and Auditing
- Drill installation commands including ACTIVATE and START
- Review privilege and audit concepts
Timed practice and gap closing
- Take timed sets against the 60-question, 90-minute format
- Revisit your weakest domain, weighted by its share of the exam
Practice with realistic questions throughout, not only at the end. The C1000-181 practice test site is built for exactly this kind of domain-by-domain drilling, and a one-page recap such as the C1000-181 cheat sheet is useful for last-day review.
Exam Format and Booking Mechanics
Knowing the domains is only half the picture; you also need to understand the container they come in. The exam consists of 60 questions to be completed in 90 minutes, and you must answer 40 correctly to pass. It is delivered in English. IBM's official sample test demonstrates single-answer multiple-choice questions, though the sample does not establish every possible item format on the live exam, so prepare for the format shown but stay flexible. For a closer look at scoring, see C1000-181 Passing Score.
- Program and delivery: The exam is part of the IBM Professional Certification Program and is delivered through Pearson VUE. Test centers and OnVUE online proctoring are IBM program delivery options, subject to what is offered for the booking you select.
- Requirements: One required exam is listed. Preparation courses and practical experience are recommended rather than mandatory. Details are covered in C1000-181 Requirements.
- Reference materials: Unauthorized reference materials are prohibited during the exam.
- Retakes: IBM allows at most two attempts at the same exam within any 30-day period, charges the regular exam price for retakes, and prohibits retaking a passed exam.
- Validity: Continuing validity of the credential is governed by IBM's Certification Agreement.
No current exam-specific fee was verified in the sources used for this article, so check the booking page for the price that applies to you, and see C1000-181 Certification Cost for how to think about total spend. Likewise, no population pass rate was verified, so treat any figure you see elsewhere with caution; C1000-181 Pass Rate discusses what can and cannot be said from the available data.
Key Takeaway
Study in proportion to weight, but do not ignore the small domains. Application Design and Development and Operations and Recovery carry just over half the exam, while the command-level material in Planning and Migration and the rule-based content in Security and Auditing are efficient points for well-prepared candidates.
Frequently Asked Questions
The exam has six domains: Database Design and Implementation, Operations and Recovery, Security and Auditing, Performance, Planning and Migration, and Application Design and Development. The weights total 100%.
Application Design and Development is the largest at 28%, followed by Operations and Recovery at 23%. Performance is third at 17%, with Database Design and Implementation and Planning and Migration each at 12% and Security and Auditing at 8%.
The exam has 60 questions with a 90-minute time limit, and you need 40 correct answers to pass. It is offered in English.
No. The six domain headings are official exam-objective sections in IBM's detailed study guide, but the percentages are published in IBM's certification-page outline rather than printed in the guide itself.
The detailed study guide includes an objective covering z/OS installation commands, including ACTIVATE and START, which the condensed online bullets omit. Read the full guide so you are not surprised by command-level questions.
Once you have mapped your strengths against these six areas, the next step is deciding how the credential fits your career. For that, read Is the C1000-181 Certification Worth It? and then begin domain-focused practice at the main practice test site.