- The Exam at a Glance: Numbers to Memorize
- Domain Weights on One Screen
- Application Design and Development (28%)
- Operations and Recovery (23%)
- Performance (17%)
- Database Design, Planning and Migration, Security and Auditing
- Booking, Retake and Policy Rules
- A Domain-Ordered Review Schedule
- Common Traps in Exam Wording
- Frequently Asked Questions
- The exam has 60 questions, a 90-minute limit, and requires 40 correct answers to pass.
- Application Design and Development carries 28%, the largest weight, followed by Operations and Recovery at 23%.
- Planning and Migration (12%) includes z/OS installation commands such as ACTIVATE and START, which condensed bullets omit.
- IBM allows at most two attempts at the same exam in any 30-day period; retakes cost the regular price.
The Exam at a Glance: Numbers to Memorize
This page condenses what the IBM Certified Db2 13 for z/OS Database Administrator - Professional exam (C1000-181) asks of you. It is not a substitute for hands-on z/OS time. The exam is built for DBAs with three or more years of experience and strong Db2 for z/OS knowledge, so treat this sheet as a memory aid layered over real experience. If you are still deciding how to prepare, the full C1000-181 study guide walks through the longer path.
| Item | Fact |
|---|---|
| Certification | IBM Certified Db2 13 for z/OS Database Administrator - Professional |
| Exam code / credential code | C1000-181 / C9006700 (replaces C0005400) |
| Certifying program | IBM Professional Certification Program |
| Delivery partner | Pearson VUE (test centers and OnVUE, subject to what your booking offers) |
| Questions | 60 |
| Time limit | 90 minutes |
| Correct answers required | 40 |
| Language | English |
| Required exams | One |
| Intended candidate | DBA with 3+ years of experience and strong Db2 for z/OS knowledge |
| Status | Listed as Live |
Two quick calculations are worth doing before exam day. Forty correct out of sixty means you can miss twenty questions, and ninety minutes across sixty items gives roughly a minute and a half per question. That pace is comfortable for recall questions but tight for scenario items that require you to reason through a utility option or a bind behavior. For a deeper treatment of the cut line, see what you need to pass.
Domain Weights on One Screen
The six domain names below are the official exam-objective sections confirmed in IBM's detailed study guide. The percentages come from IBM's certification-page outline and are not printed in the study guide itself. They total 100%.
| Domain | Weight | Approx. share of 60 questions |
|---|---|---|
| Application Design and Development | 28% | about 17 |
| Operations and Recovery | 23% | about 14 |
| Performance | 17% | about 10 |
| Database Design and Implementation | 12% | about 7 |
| Planning and Migration | 12% | about 7 |
| Security and Auditing | 8% | about 5 |
The question counts are simple arithmetic on 60 items, not an IBM-published distribution, so expect some drift on any given form. The pattern still matters: the top three domains account for 68% of the exam. A fuller breakdown lives in the complete guide to all six content areas.
Application Design and Development (28%)
This is the heaviest domain, and it is where a DBA's knowledge of how programs interact with Db2 is tested. Expect questions that connect SQL behavior, binding, and program preparation to what a DBA must configure or diagnose.
Application Design and Development: what to be ready for
Think like the DBA who reviews and supports application teams, not like the developer who writes the code.
- Package and plan concepts: how programs are bound, what bind options change, and how packages are organized and versioned.
- Static versus dynamic SQL, and the behavioral and security consequences of each.
- Locking and concurrency from the application side: isolation levels, lock sizes, commit frequency, and how they affect other work.
- Cursors, result handling, and how application design choices affect resource usage.
- Stored procedures and user-defined functions as database objects a DBA must support.
- Distributed access concepts, since applications often reach Db2 for z/OS remotely.
When a question pairs an application symptom (timeouts, deadlocks, unexpected plan changes) with a design cause, the answer usually lies in isolation, commit scope, or bind configuration. Rehearse reading a scenario and naming the single most likely lever.
Operations and Recovery (23%)
Second in weight, this domain rewards candidates who have actually lived through recoveries, restarts, and utility runs. It is the area where memorized definitions are least useful and operational judgment matters most.
Operations and Recovery: core ground
- Backup and recovery strategy: image copies, recovery to current versus to a point in time, and what the log contributes.
- Utilities: knowing which utility fits which job (copy, recover, reorganize, load, unload, statistics collection, consistency checking) and what each requires of the object state.
- Restricted and pending states: recognizing why a table space or index is unavailable and the correct way to clear it.
- Logging and restart: the role of the active and archive logs and what happens during subsystem restart.
- Commands for monitoring and controlling objects and threads.
- Data sharing awareness, where relevant to operational procedures.
Performance (17%)
Performance rounds out the top three domains. It covers how the DBA finds and fixes slowness, and how the optimizer's choices are influenced by what you maintain.
Performance: what shows up
- Statistics and how they feed access path selection; why stale or missing statistics change plans.
- Explain output and reading an access path: index use, scan types, join methods.
- Index design trade-offs: benefit to queries versus cost to inserts, updates, and utilities.
- Reorganization decisions and how to tell when an object needs one.
- Buffer pool and memory concepts, and how sizing affects I/O.
- Monitoring tools and trace concepts used to locate where time is going.
For difficulty context across these three domains, the difficulty guide explains why experienced DBAs still find the scenario items demanding.
Database Design and Implementation, Planning and Migration, Security and Auditing
Together these three domains make up 32% of the exam. Do not neglect them: a missed 12% domain costs about as many questions as skipping a whole subtopic of a larger one.
Database Design and Implementation (12%)
- Choosing and creating the right object types: table spaces, tables, indexes, views.
- Table space types and their trade-offs for size, access, and maintenance.
- Data types, constraints, and referential integrity as implemented in the database.
- Partitioning concepts and when they help.
Planning and Migration (12%)
The detailed study guide includes a Planning and Migration objective covering z/OS installation commands, including ACTIVATE and START, and this is omitted from the condensed online bullets. That is a classic gap: candidates who study only the short summary can arrive unprepared for command-level questions. Read the full eight-page study guide rather than relying on the abbreviated outline.
- Db2 13 migration and activation concepts, including how new function becomes available.
- The installation and migration commands named in the detailed guide.
- Planning considerations before moving an existing subsystem to Db2 13.
Security and Auditing (8%)
- Authorization model: privileges, authorities, and how they are granted and revoked.
- Controlling access to data and to administrative functions.
- Auditing concepts: what can be recorded and why a DBA would turn it on.
- The smallest domain, so aim for clean fundamentals rather than obscure detail.
Booking, Retake and Policy Rules
These are the rules that cost people money or time when they are overlooked. Verify every one against IBM's current terms at booking, because policies are governed by IBM's program documents and the Pearson VUE listing for your selected option.
| Rule | What IBM states |
|---|---|
| Retake limit | At most two attempts at the same exam within any 30-day period |
| Retake cost | The regular exam price applies to retakes |
| Passed exam | Retaking a passed exam is prohibited |
| Delivery | Test centers and OnVUE are program options, subject to what your booking offers |
| Reference materials | Unauthorized materials are prohibited |
| Continuing validity | Governed by IBM's Certification Agreement |
A Domain-Ordered Review Schedule
If you have about five weeks, order your review by exam weight and by how much each domain depends on the previous one. Adjust the pacing to your own experience; a DBA who recovers objects weekly can compress the operations block, while someone who rarely touches installation should extend the migration block.
Application Design and Development
- Binding, packages, static versus dynamic SQL, isolation and locking.
- Stored procedures and distributed access concepts.
Operations and Recovery
- Utility selection, recovery sequences, restricted states, restart.
- Run each utility in a test subsystem if you can.
Performance
- Statistics, explain output, index trade-offs, reorganization triggers.
Design, Planning and Migration, Security
- Object types and table space choices.
- ACTIVATE, START, and migration planning from the detailed study guide.
- Authorization and auditing fundamentals.
Timed practice
- Full 60-question sets under a 90-minute clock; review every miss by domain.
Practice questions are most useful once you know the material, so save timed runs for the final week and use the C1000-181 practice tests to find which domain is dragging your score.
Common Traps in Exam Wording
- Db2 13 specificity. The credential is for Db2 13 for z/OS. Answers true of an older release or of Db2 on another platform may not be the best answer here.
- "Best" versus "possible." With single-answer questions, several options may be technically valid. Pick the one that fits the stated goal, such as least disruption or minimum outage.
- Object state blindness. Many operational answers depend on whether an object is in a restricted or pending state. Read for the state before you read the options.
- The omitted objective. Command-level installation questions can appear even though condensed summaries skip them. Cover ACTIVATE and START from the full guide.
- Weight neglect. Spending equal time on all six domains under-prepares you for the 28% and 23% areas.
- Confusing acronym sources. Make sure any third-party material you use is about this Db2 13 for z/OS exam; the code C1000-181 should map to the credential C9006700 on IBM's page. If the terminology is new to you, see what C1000-181 is.
Key Takeaway
Allocate your hours roughly in proportion to the weights, but never skip the smaller domains: a 12% domain is about seven questions, and the pass line leaves you only twenty misses in total.
Frequently Asked Questions
The exam has 60 questions with a 90-minute time limit, and you need 40 correct answers to pass. It is offered in English. IBM's official sample shows single-answer multiple-choice questions, though that sample does not establish every possible live item format.
Application Design and Development is the largest at 28%, followed by Operations and Recovery at 23% and Performance at 17%. Together those three make up 68% of the exam, so they deserve the most preparation time, while the remaining three still need solid coverage.
IBM permits at most two attempts at the same exam within any 30-day period and charges the regular exam price for retakes. Retaking a passed exam is prohibited. Confirm the current terms in IBM's program policies when you book.
Yes. The detailed study guide's Planning and Migration objective covers z/OS installation commands, including ACTIVATE and START, even though the condensed online bullets leave them out. Read the full study guide to avoid that blind spot.
It signals Db2 13 for z/OS DBA skill and is aimed at experienced administrators, so its value depends on your role and employer. See the ROI analysis for the trade-offs, and C1000-181 jobs for the kinds of roles that look for this credential.