- C1000-181 is IBM's Db2 13 for z/OS Database Administrator - Professional exam, credential C9006700, replacing C0005400.
- The exam has 60 questions in 90 minutes, and you need 40 correct answers to pass.
- Application Design and Development carries 28%, the largest weight, followed by Operations and Recovery at 23%.
- IBM targets DBAs with three or more years of hands-on Db2 for z/OS experience.
What the C1000-181 Credential Actually Is
The C1000-181 exam is the single required test for the IBM Certified Db2 13 for z/OS Database Administrator - Professional credential, issued under the IBM Professional Certification Program. IBM identifies the credential as C9006700 and states that it replaces the earlier credential C0005400. If you hold the older Db2 for z/OS certification, this is the successor aligned to Db2 13.
The scope is deliberately narrow: Db2 13 running on z/OS. This is not a general database administration test, and it is not a distributed-platform Db2 exam. Everything on it assumes the mainframe environment: subsystems, address spaces, catalog and directory objects, utilities, and the z/OS commands that control them. If you want a plain-language orientation on the name itself, the articles What Is C1000-181? and What Does C1000-181 Stand For? cover that ground, and the main C1000-181 certification overview sits alongside this piece.
Exam Format and Logistics
The published parameters are straightforward and worth memorizing before you plan your preparation time.
| Item | Detail |
|---|---|
| Exam code | C1000-181 |
| Credential | IBM Certified Db2 13 for z/OS Database Administrator - Professional (C9006700) |
| Number of questions | 60 |
| Duration | 90 minutes |
| Correct answers required | 40 |
| Language | English |
| Required exams | One |
| Delivery | Pearson VUE test centers or OnVUE, depending on options offered at booking |
Forty correct answers out of sixty works out to roughly two thirds, but you should think in terms of the raw requirement rather than a percentage. Ninety minutes for sixty questions gives you an average of ninety seconds per item. That sounds comfortable until you hit a scenario question that requires you to mentally walk through a recovery sequence or interpret a snippet of SQL and its access path implications. For a deeper look at the threshold, see C1000-181 Passing Score.
Question style
IBM's official sample test demonstrates single-answer multiple-choice questions. That is what the sample establishes, and it is the safest format to prepare for. The sample does not prove that every possible live item uses the same format, so do not assume nothing else could appear. Practice reading each question stem carefully, because mainframe questions often hinge on one word: which utility, before or after a step, required versus optional.
How the Six Domains Are Weighted
The six domain headings are official exam-objective sections confirmed in IBM's detailed study guide. The percentage weights are published in IBM's certification-page outline and total 100%. Note that the weights are not printed in the study guide itself, so you will find them on the certification page.
| Domain | Weight |
|---|---|
| Application Design and Development | 28% |
| Operations and Recovery | 23% |
| Performance | 17% |
| Database Design and Implementation | 12% |
| Planning and Migration | 12% |
| Security and Auditing | 8% |
Two domains, Application Design and Development and Operations and Recovery, account for 51% of the exam between them. Add Performance and you reach 68%. That concentration should shape how you divide your hours. A candidate who is brilliant at security but shaky on application development and recovery is taking a real risk, since Security and Auditing is the smallest block. The full breakdown lives in C1000-181 Exam Domains: Complete Guide to All 6 Content Areas.
What to Master in Each Domain
The following sections describe the kinds of knowledge each domain calls for. They are framed around the exam-objective headings, so use IBM's study guide as the authoritative checklist and treat this as a practical lens on it.
Application Design and Development (28%)
The heaviest domain rewards candidates who can write, read and reason about SQL in a Db2 for z/OS application context, not just recite syntax.
- Embedded SQL and the program preparation flow, including precompile, bind and package concepts
- Cursor behavior, locking implications of isolation levels, and how application commit strategy affects concurrency
- Stored procedures, user-defined functions and triggers, and when each is the right tool
- Handling SQLCODE and SQLSTATE results and understanding what an application should do next
- Package and plan management, collections, and how bind options influence runtime behavior
Operations and Recovery (23%)
This is where DBA judgment is tested. Expect scenarios, not definitions.
- Image copy strategy, including full and incremental copies and how they interact with recovery
- The RECOVER utility, point-in-time recovery concepts, and the role of the log
- Logging architecture: active and archive logs, the bootstrap data set, and restart behavior
- Utility operation: REORG, RUNSTATS, CHECK, and how to respond to restrictive or pending states
- Commands that display and control databases, table spaces and threads, and how to interpret their output
Performance (17%)
Performance questions usually ask you to connect a symptom to a cause and then to the right lever.
- Reading EXPLAIN output and understanding access path choices such as index access and join methods
- The role of catalog statistics and when stale statistics lead the optimizer astray
- Buffer pool concepts, sort and workfile considerations, and locking-related contention
- Monitoring approaches and trace-based diagnosis at a conceptual level
Database Design and Implementation (12%)
Physical design decisions and the objects that carry them.
- Table space types and their trade-offs, including how partitioning choices affect utilities and availability
- Index design, clustering and the relationship between design and access paths
- Referential integrity, constraints and how they are enforced
- Schema changes and what they imply for rebinding and availability
Planning and Migration (12%)
The detailed study guide includes a Planning and Migration objective covering z/OS installation commands, including ACTIVATE and START. This detail is omitted from the condensed online bullets, so candidates who rely only on the short outline can miss it.
- Migration phases and the sequence by which a subsystem moves to Db2 13 behavior
- Installation-related commands and what each one does to the subsystem
- Preparing applications and packages for a new Db2 version
- Fallback considerations and what remains reversible at each stage
Security and Auditing (8%)
The smallest domain, but it contains questions that are easy to get right with focused review.
- Privileges, authorities and how they are granted and revoked
- Authorization IDs, roles and trusted contexts at a conceptual level
- Auditing facilities and what they can record
- Protecting data through access controls and encryption-related concepts
Key Takeaway
Do not skip the Planning and Migration detail just because it is only 12%. The study guide's installation-command coverage is exactly the sort of narrow, memorizable content that separates a pass from a near miss. Read the full eight-page IBM study guide, not only the summary bullets on the certification page.
Who Should Sit This Exam
IBM describes the intended candidate as a database administrator with three or more years of experience and strong Db2 for z/OS knowledge. That is a guideline for the target audience, not a hard gate: IBM lists a single required exam, with preparation courses and practical experience recommended rather than mandated. You can read the full picture in C1000-181 Requirements: Eligibility, Prerequisites & How to Qualify.
In practice, the exam is a poor fit for someone whose Db2 experience is entirely on distributed platforms, or for someone who has never touched a z/OS console. The questions assume you understand how a mainframe subsystem is operated. If you are earlier in your career, consider building experience with utilities, recovery drills and bind management before attempting it. For a candid view of the challenge, see How Hard Is the C1000-181 Exam?.
Booking, Delivery and Retake Rules
IBM exams are delivered through Pearson VUE. Both physical test centers and online proctoring through OnVUE are program delivery options, but the specific options available depend on the selection you make when booking. Check what is offered for your region and exam at the time of scheduling. Timing and scheduling considerations are covered in C1000-181 Exam Dates.
Retake policy
- IBM allows at most two attempts at the same exam within any 30-day period.
- Retakes are charged at the regular exam price.
- You are prohibited from retaking an exam you have already passed.
Because a failed attempt carries the full price again, treat your first attempt as the one that counts. A practice-test pass in realistic conditions is a far cheaper way to find gaps than a live retake. On pricing, note that no current exam-specific fee was verified for this article, so confirm the price on IBM's certification page or at booking. The cost-related considerations are discussed in C1000-181 Certification Cost.
A Domain-Ordered Study Sequence
Rather than a generic schedule, order your preparation around the weights and the dependencies between topics. Recovery makes more sense once you understand logging; application tuning makes more sense once you can read access paths. The timeline below assumes a working Db2 for z/OS DBA with some time to spare each week. Adjust the length to your own experience, and see the C1000-181 Study Guide for a fuller plan.
Database Design and Implementation, plus the exam blueprint
- Read the IBM eight-page study guide end to end
- Review table space types, indexes and constraints
- Attempt the official sample test cold to expose weak areas
Operations and Recovery, part one
- Logging architecture and restart behavior
- Image copy strategy and the RECOVER utility
Operations and Recovery, part two, and Planning and Migration
- Utility states, restrictive conditions and commands
- Migration phases and the installation commands, including ACTIVATE and START
Performance
- EXPLAIN, statistics and access path reasoning
- Buffer pool and contention concepts
Application Design and Development
- Bind and package management, isolation and locking
- Routines, error handling and program preparation flow
Security and Auditing, then timed practice
- Authorities, privileges and auditing facilities
- Full-length timed practice sets under 90-minute conditions
Application Design and Development gets its own week late in the plan because it builds on the performance and locking knowledge from earlier weeks. If your day job is application-facing, swap the order and start there. You can also reinforce your review with the quick-reference C1000-181 Cheat Sheet and the structured C1000-181 training options, then validate readiness with the C1000-181 practice tests.
Career Context for Db2 for z/OS DBAs
Db2 for z/OS runs inside the large organizations that rely on mainframes for transaction-heavy workloads, and that is where the credential carries weight. Think banks, insurers, government agencies, large retailers and the service providers that run mainframe operations on their behalf. Job titles typically include Db2 database administrator, mainframe DBA, and Db2 systems programmer roles, with the certification serving as an independent signal that you can handle production subsystems.
The credential is most valuable when paired with demonstrable experience. A certification tells a hiring manager you have verified Db2 13 knowledge; your track record tells them you can restore a table space at 3 a.m. For a more detailed look at roles, see C1000-181 Jobs. On earnings and return, no salary figure is asserted here, so consult C1000-181 Salary Guide and Is the C1000-181 Certification Worth It? and weigh them against current market data for your region.
Frequently Asked Questions
The exam has 60 questions with a 90-minute time limit, and you need 40 correct answers to pass. It is delivered in English.
Application Design and Development is the largest at 28%, followed by Operations and Recovery at 23%. Performance is 17%, Database Design and Implementation and Planning and Migration are each 12%, and Security and Auditing is 8%.
Yes. IBM identifies the credential C9006700 as replacing C0005400. The exam code for the current credential is C1000-181, and it targets Db2 13 for z/OS.
IBM allows at most two attempts at the same exam within any 30-day period. Retakes are charged at the regular exam price, and retaking an exam you have already passed is prohibited.
Test centers and OnVUE are IBM program delivery options through Pearson VUE, subject to the options offered for your selected booking. Unauthorized reference materials are prohibited, so plan to rely on memorized knowledge.