- What the Credential Actually Is
- Exam Format: 66 Questions, 90 Minutes, 47 to Pass
- The Six Domains and Where the Points Sit
- Who the Exam Is Built For
- Registration, Delivery and Retake Rules
- Concrete Db2 Topics to Master
- Where the Credential Fits in a Db2 Career
- Sequencing Your Preparation Around the Weights
- Frequently Asked Questions
- C1000-198 is IBM's Professional-level Db2 v12.1 for Linux, UNIX and Windows DBA exam, tied to credential C9009700.
- The exam has 66 questions in 90 minutes, and you need 47 correct answers to pass.
- Operating carries 33% of the weight, nearly double Monitoring at 18%, so it deserves the largest share of study time.
- Expect multiple-choice, multiple-response and performance-based lab tasks, not just recall questions.
What the Credential Actually Is
C1000-198 is the exam code for IBM Certified Db2 v12.1 Database Administrator - Professional, issued under the IBM Professional Certification Program. The certification itself is registered as credential C9009700, and the exam is the single required test needed to earn it. Both the certification and the exam are listed as Live, meaning IBM currently offers them to candidates.
The scope is precise: Db2 v12.1 for Linux, UNIX and Windows. That wording matters. It tells you the exam targets the distributed-platform Db2 product, so a candidate whose experience is entirely on another Db2 family member should expect to do some translation work. It also tells you the version: v12.1 behaviors, features and defaults are what the exam is written against, not those of older releases you may have run in production for years.
Because several unrelated credentials in the industry reuse similar alphanumeric codes, it helps to anchor on the full name every time you search for study materials. If a resource does not mention Db2 v12.1 and IBM, it is not about this exam. For a broader orientation to the code and naming, see What Is C1000-198? and C1000-198 Meaning.
Exam Format: 66 Questions, 90 Minutes, 47 to Pass
The published parameters are straightforward. The exam contains 66 questions, you have 90 minutes for the whole sitting, and you need 47 correct answers to pass. The exam is delivered in English. That works out to a little under 1 minute 25 seconds per question on average, which sounds comfortable until you hit the harder item types.
Question styles you should expect
IBM explicitly states that the exam includes both multiple-choice questions and performance-based lab tasks. IBM does not publish a separate time allowance for the practical portion, so lab-style items draw from the same 90-minute pool as everything else. The official sample test also demonstrates multiple-response items, where you must select more than one correct option. IBM adds a caution on the sample itself: doing well on it does not predict how you will do on the real exam. Treat it as a format preview, not a readiness gauge.
The practical consequence is that rote memorization of command names will not carry you. A lab-style task rewards candidates who have actually typed Db2 commands, read the output and fixed something that was misconfigured. Multiple-response items punish half-knowledge, since partially correct selections are a common trap.
Passing threshold in plain terms
With 47 correct answers required out of 66, you can miss 19 questions and still pass. That is a useful planning figure, but do not over-read it: IBM describes the domain weights as approximate, and the published materials do not detail how any individual item type is scored beyond the stated requirement. For more on the threshold itself, see C1000-198 Passing Score, and for a realistic read on workload, How Hard Is the C1000-198 Exam?
| Exam Parameter | Published Detail |
|---|---|
| Exam code | C1000-198 |
| Credential | C9009700, IBM Certified Db2 v12.1 Database Administrator - Professional |
| Product scope | Db2 v12.1 for Linux, UNIX and Windows |
| Number of questions | 66 |
| Time allowed | 90 minutes, whole exam |
| Correct answers to pass | 47 |
| Item types | Multiple-choice, multiple-response, performance-based lab tasks |
| Language | English |
The Six Domains and Where the Points Sit
IBM's study guide divides the exam into six objective sections. The weights are approximate and total 100%. Here is how they stack up:
| Domain | Approximate Weight |
|---|---|
| 1. Design and Architecture | 9% |
| 2. Db2 Server and Client Installation and Management | 11% |
| 3. Monitoring | 18% |
| 4. Operating | 33% |
| 5. Security and Compliance | 15% |
| 6. Business continuity | 14% |
A small naming note: the detailed study-guide PDF labels the first domain "Design and Architecture," while IBM's web summary words it as "Design and Architect." Both refer to the same 9% block, so do not be thrown if you see either phrasing in different places.
Operating (33%)
This is the heart of the exam. A third of the weight sits here, which means roughly a third of your scored items will probe day-to-day administration of a running Db2 system.
- Expect hands-on style tasks that mirror what a DBA does on a normal working day.
- Depth beats breadth: know the commands and the reasoning behind them.
Monitoring (18%)
The second-heaviest domain. It rewards candidates who can read system and database activity and draw conclusions, not just recite the names of monitoring tools.
- Practice interpreting output rather than only producing it.
- Connect symptoms to likely causes, since scenario questions tend to work that way.
Security and Compliance (15%) and Business continuity (14%)
Together these two domains carry 29%, almost as much as Operating on its own. Candidates who treat them as afterthoughts leave a lot of points on the table.
- Security and Compliance covers protecting data and demonstrating control over access.
- Business continuity covers keeping the database recoverable and available when things go wrong.
For a section-by-section breakdown of what each objective covers, read C1000-198 Exam Domains: Complete Guide to All 6 Content Areas.
Who the Exam Is Built For
IBM positions this as a Professional-level credential. The intended candidate is described as having at least two years of practical, hands-on experience with the product. Note the nature of that statement: it is target-candidate guidance describing who the exam is written for, not a formal prerequisite that blocks registration. There is no listed gate that stops you from booking the exam on day one, but the guidance is a fair signal of the depth the questions assume.
In practice, three groups tend to benefit most:
- Working Db2 DBAs who want a vendor-backed record of their skills on the current v12.1 release.
- DBAs migrating from other platforms or older Db2 versions who need to prove they have caught up on v12.1 behavior.
- Infrastructure and operations engineers who support Db2 estates and are moving toward formal database administration responsibilities.
If you are earlier in your career, the exam is still reachable, but you will need to compensate for missing production experience with serious lab time. Details on eligibility are covered in C1000-198 Requirements.
Registration, Delivery and Retake Rules
IBM delivers this exam through Pearson VUE. Candidates can generally choose between a physical test center and the online-proctored OnVUE option, but availability is subject to what is actually offered for this exact exam at the time you book. Check the options shown during scheduling rather than assuming both will always appear.
Two rules deserve attention before you commit to a date:
- Unauthorized reference materials are prohibited. This is a closed-resource exam, so plan on working from memory and hands-on familiarity.
- Retakes are limited. IBM permits at most two attempts at the same exam within any 30-day period, charges the regular retake price each time, and does not allow you to retake an exam you have already passed.
On cost, be careful. The retrieved IBM sources did not confirm a current exam fee for C1000-198, so this article will not quote one. You may encounter a USD 30 figure in the study guide, but that price applies to a separate assessment exam, not to this certification exam. Confirm the live price on the Pearson VUE booking page for your region. For a fuller discussion, see C1000-198 Certification Cost and C1000-198 Exam Dates.
Concrete Db2 Topics to Master
The domains name the territory; the work is in the specifics. Here is how to translate each domain into things you should be able to do at a command line, not just describe.
Design and Architecture (9%)
Understand how a Db2 instance, its databases, storage and memory structures relate to one another, and how design choices affect performance and manageability. Be able to reason about why one layout suits a workload better than another.
Db2 Server and Client Installation and Management (11%)
Know the installation and configuration lifecycle on Linux, UNIX and Windows, including how clients connect to servers and how instance- and database-level settings are managed. Questions here are often procedural: what comes first, what depends on what.
Monitoring (18%)
Practice reading monitoring output and diagnosing from it. Be comfortable with how Db2 exposes activity and health information, and train yourself to link a symptom, such as slow queries or resource contention, to its probable cause.
Operating (33%)
Spend most of your lab hours here. Day-to-day administration, including managing objects, handling workloads, maintaining the database and keeping it healthy, is where the exam concentrates its points. Run the commands yourself against a v12.1 environment and read every message the system returns.
Security and Compliance (15%)
Learn how access to data is granted, restricted and audited, and how Db2 supports protecting sensitive information. Expect questions that ask which control meets a stated requirement.
Business continuity (14%)
Focus on backup, recovery and availability concepts. A strong candidate can explain what a given failure scenario requires and which recovery approach fits it, then actually perform that recovery in a lab.
Key Takeaway
Because lab tasks sit alongside multiple-choice items, build a personal Db2 v12.1 practice environment early. Reading about a recovery procedure and executing it are very different skills, and the exam tests the second one.
A compact reference to reinforce these topics is available in the C1000-198 Cheat Sheet, and structured preparation resources are discussed in C1000-198 Training.
Where the Credential Fits in a Db2 Career
A Db2 DBA credential signals to employers that you can operate a relational database in production, secure it, monitor it and recover it. Organizations that run Db2 on Linux, UNIX and Windows, typically large enterprises with long-lived transactional systems, are the natural audience. Roles that commonly reference this skill set include database administrator, database operations engineer and platform or infrastructure engineer with a data focus.
Be cautious about any precise earnings claims attached to the certification. The sources used for this article did not verify salary or pass-rate data, so none is quoted here. Whether the credential pays off depends heavily on your region, your employer's Db2 footprint and your existing experience. For analysis of those questions, see Is the C1000-198 Certification Worth It?, C1000-198 Salary Guide, C1000-198 Jobs and C1000-198 Pass Rate.
Finally, remember that continuing validity of the certification is governed by IBM's Certification Agreement. Read it when you pass so that you understand any maintenance expectations rather than discovering them later.
Sequencing Your Preparation Around the Weights
You do not need an elaborate method here; you need an order that matches where the points are. Below is one sensible sequence for a candidate with some Db2 background. Adjust the pace to your own experience.
Foundations: Design and Architecture plus Installation and Management (20%)
- Build or refresh a Db2 v12.1 lab environment on Linux or Windows.
- Walk through instance and database creation and client connectivity.
Operating (33%)
- Spend the longest block here because it carries the most weight.
- Practice administration tasks hands-on, then review every error message you hit.
Monitoring (18%)
- Generate load in your lab and diagnose it from monitoring output.
Security and Compliance (15%) and Business continuity (14%)
- Configure access controls, then rehearse backup and recovery scenarios end to end.
Timed practice and gap repair
- Take timed sets mixing multiple-choice and multiple-response items.
- Return to your weakest domain for additional lab work.
The logic is simple: early weeks build the foundation that Operating assumes, the biggest block gets the biggest slice of time, and the last week is for simulating the 90-minute pressure. For a fuller plan, see the C1000-198 Study Guide, and when you are ready to test yourself under exam-like conditions, try the C1000-198 practice tests to check your readiness across all six domains.
Frequently Asked Questions
It demonstrates that you can administer Db2 v12.1 for Linux, UNIX and Windows at a Professional level. It is issued by IBM as credential C9009700 after you pass the single required exam, which covers design, installation, monitoring, operating, security and business continuity.
The exam has 66 questions with a 90-minute limit for the whole sitting. You need 47 correct answers to pass. Question types include multiple-choice, multiple-response and performance-based lab tasks.
Operating, at an approximate 33%. Monitoring follows at 18%, then Security and Compliance at 15%, Business continuity at 14%, Db2 Server and Client Installation and Management at 11%, and Design and Architecture at 9%. IBM describes these weights as approximate.
Yes, but IBM allows at most two attempts at the same exam within any 30-day period and charges the regular retake price each time. You also cannot retake an exam you have already passed.
IBM describes the intended Professional-level candidate as having at least two years of hands-on experience, but this is target-candidate guidance rather than a listed gate. Candidates with less experience can still prepare, though they should invest heavily in lab practice. See C1000-198 Certification for more background.