- What the C1000-198 Certification Actually Certifies
- Exam Format: 66 Questions, 90 Minutes, 47 to Pass
- The Six Domains and Where the Points Are
- Operating (33%): The Domain That Decides Your Result
- Monitoring, Security and Compliance, and Business Continuity
- Preparing for Performance-Based Lab Tasks
- Registration, Delivery and Retake Rules
- Who Should Sit This Exam and Who Hires for It
- A Domain-Weighted Preparation Sequence
- Frequently Asked Questions
- C1000-198 is IBM's Db2 v12.1 Database Administrator - Professional exam for Linux, UNIX and Windows, tied to credential C9009700.
- The exam has 66 questions in 90 minutes, and you need 47 correct answers to pass.
- Operating is 33% of the exam and Monitoring is 18%, so together they carry just over half the weight.
- Expect multiple-choice, multiple-response and performance-based lab tasks, so hands-on Db2 command practice matters.
What the C1000-198 Certification Actually Certifies
The C1000-198 exam leads to the IBM Certified Db2 v12.1 Database Administrator - Professional credential, listed by IBM under credential code C9009700. It sits inside the IBM Professional Certification Program and is scoped specifically to Db2 v12.1 for Linux, UNIX and Windows. That scope matters: this is not a general database-theory credential, and it is not a mainframe z/OS Db2 exam. It tests whether you can administer a Db2 LUW environment the way a working DBA does.
Only one exam is required for the credential, and both the certification and the exam are listed as live. IBM's recommended courses are preparation resources, not additional exam domains, so you do not need to hunt for a second test to complete the certification. If you are new to the acronym and want the plain-language background first, our explainers on what C1000-198 is and what the C1000-198 certification covers start from the basics. This article goes deeper into how the exam is built and how to prepare for it.
Exam Format: 66 Questions, 90 Minutes, 47 to Pass
The headline numbers are simple and worth memorizing because they drive your pacing:
| Item | C1000-198 Detail |
|---|---|
| Total questions | 66 |
| Time allowed | 90 minutes for the whole exam |
| Correct answers required | 47 |
| Language | English |
| Question styles | Multiple-choice, multiple-response, performance-based lab tasks |
| Testing provider | Pearson VUE |
| Reference materials | Unauthorized materials prohibited |
Ninety minutes across 66 items averages out to a little under 82 seconds per question. That average is misleading, because lab-style tasks will almost certainly consume more time than a straightforward multiple-choice item. IBM does not publish a separate time allocation for the practical portion; the 90 minutes covers everything. Your pacing plan should therefore bank time on quick recall questions so that you can afford to work through a hands-on task carefully.
Passing requires 47 correct answers out of 66. We walk through the arithmetic and what it means for how many items you can miss in our C1000-198 passing score breakdown.
The multiple-response trap
IBM's official sample test demonstrates multiple-response items, where more than one option is correct. These are where otherwise well-prepared candidates drop points, because partial knowledge produces a plausible but incomplete selection. Read the question stem for the number of answers requested, and treat each option as an independent true-or-false judgment about Db2 behavior rather than looking for the single best fit.
The sample test also carries a warning that success on the sample does not predict success on the real exam. Use it to learn the item formats, not to gauge readiness. For a frank view of how demanding the real exam is, read how hard the C1000-198 exam is.
The Six Domains and Where the Points Are
IBM's study guide lists six exam-objective sections. The published weights total 100% and IBM describes them as approximate, so treat them as planning guidance rather than exact question counts.
| Domain | Weight | Priority |
|---|---|---|
| Domain 1: Design and Architecture | 9% | Lowest weight, but concepts feed every other domain |
| Domain 2: Db2 Server and Client Installation and Management | 11% | Foundational and lab-friendly |
| Domain 3: Monitoring | 18% | Second largest; heavy on diagnosis |
| Domain 4: Operating | 33% | Largest by a wide margin |
| Domain 5: Security and Compliance | 15% | Authorities, privileges, encryption, auditing |
| Domain 6: Business continuity | 14% | Backup, recovery and high availability |
One small naming note: the detailed PDF study guide calls Domain 1 "Design and Architecture," while IBM's web summary uses "Design and Architect." Both refer to the same 9% section. For a section-by-section treatment, see our complete guide to all six C1000-198 content areas.
Operating (33%): The Domain That Decides Your Result
A single domain worth a third of the exam deserves a disproportionate share of your preparation. Operating is where daily DBA work lives, and it is also where performance-based lab tasks are most naturally situated. Practice these areas until the commands and behaviors are second nature:
Day-to-Day Database Operations
Know how to create, configure and maintain databases and instances, and how to read and change configuration at the instance and database levels.
- Instance and database configuration parameters, and how to view and update them from the command line
- Storage management: table spaces, containers and how data is physically organized
- Routine maintenance tasks that keep statistics and physical organization healthy
- Data movement: moving data in and out of databases using Db2's utilities
- Database objects: tables, indexes, views and how they are created and altered
Rather than memorizing option lists, build the habit of running each task end to end in a real Db2 v12.1 LUW environment: create a database, adjust a configuration parameter, load data, run maintenance, and verify the result. Questions in this domain tend to reward people who have seen the actual output of a command, because distractor options are often plausible-sounding but slightly wrong syntax or behavior.
Monitoring, Security and Compliance, and Business Continuity
Monitoring (18%)
Monitoring questions test whether you can find out what the database is doing and why it is slow, blocked or failing. Be ready to interpret monitoring output, identify resource bottlenecks, recognize locking and concurrency problems, and know where Db2 records diagnostic information. The skill being measured is diagnosis: given a symptom, which tool or data source answers the question fastest?
Security and Compliance (15%)
This domain covers who can do what, and how you prove it. Candidates should understand the Db2 authority and privilege model, how access is granted and revoked, how data is protected in transit and at rest, and how auditing supports compliance requirements. Questions often present a business requirement and ask which mechanism satisfies it, so learn the distinctions between similar-sounding controls.
Business continuity (14%)
Business continuity is about surviving failure. Expect questions on backup and restore strategies, recovery from various failure scenarios, and high-availability and disaster-recovery approaches available in Db2 LUW. The key judgment skill is matching a recovery objective to the right technique, and understanding what each approach does and does not protect against.
Key Takeaway
Operating and Monitoring reward hands-on familiarity, while Security and Business continuity reward scenario judgment. Practice commands for the first pair and practice mapping requirements to mechanisms for the second pair. Our C1000-198 cheat sheet condenses the must-know facts for last-minute review.
Preparing for Performance-Based Lab Tasks
IBM explicitly states that the exam includes performance-based lab tasks alongside multiple-choice questions. Because no separate practical-assessment timer is published, assume lab work draws from the same 90-minute pool. A few preparation habits follow from that:
- Work from the command line. Even if you prefer graphical tools day to day, rehearse tasks using the Db2 command line processor so that syntax recall is fast and accurate.
- Read the task fully before typing. Lab tasks typically specify a precise end state. Missing one stated requirement can cost the item.
- Verify your work. Build the habit of running a quick check after each change, since confirmation is cheap compared with losing the item.
- Practice under a clock. Time yourself on end-to-end tasks so that you know how long a realistic lab item takes you.
Because unauthorized reference materials are prohibited, you cannot count on looking up syntax mid-exam. Command fluency has to live in your memory. Our C1000-198 training overview discusses how to choose between courses, labs and self-study for building that fluency.
Registration, Delivery and Retake Rules
Exams are delivered through Pearson VUE. IBM's program offers test centers and online proctoring through OnVUE, but the options actually available depend on what is offered for this exact exam at the time you book, so confirm during registration rather than assuming. Check the Pearson VUE IBM page for current scheduling, and see our C1000-198 exam dates and scheduling guide for planning your window.
Retake policy is specific and worth knowing before your first attempt:
- IBM permits at most two attempts at the same exam within any 30-day period.
- Each retake is charged at the regular exam price.
- You cannot retake an exam you have already passed.
- Continuing validity of the credential is governed by IBM's Certification Agreement.
Who Should Sit This Exam and Who Hires for It
The Professional-level framing points to working database administrators and engineers who already manage Db2 LUW systems, or who are moving into that role with real hands-on practice. Typical job contexts include organizations that run Db2 for transactional systems, data warehousing and analytics workloads, where a certified administrator signals dependable operational skill. Roles that commonly line up with this credential include Db2 database administrator, database operations engineer, and infrastructure or platform engineers who support Db2 environments. Our C1000-198 jobs overview looks at the roles in more detail.
If you are weighing the investment, compare the credential against your current role and your employer's Db2 footprint. Our C1000-198 ROI analysis and salary guide cover the career side without relying on invented figures.
A Domain-Weighted Preparation Sequence
Rather than a generic schedule, sequence your study so that foundational domains come first and the heaviest domain gets the most repetition. This example assumes six weeks; compress or stretch it to fit your experience.
Design and Architecture plus Installation and Management
- Review instance, database and storage architecture (9% weight)
- Practice server and client installation and management tasks (11% weight)
- Set up a lab environment you will reuse all the way through
Operating
- Work through configuration, storage, maintenance and data movement hands-on
- Repeat command-line tasks until syntax is automatic
- Spend extra time here, since it is 33% of the exam
Monitoring
- Generate load and problems deliberately, then diagnose them
- Practice interpreting monitoring output and locating diagnostic data
Security and Compliance plus Business continuity
- Configure authorities, privileges and auditing, then test them
- Perform backup and restore cycles and walk through recovery scenarios
Integration and timed practice
- Take timed practice sets covering all six domains
- Revisit weak areas, prioritizing Operating and Monitoring
For a broader plan and resource list, see our C1000-198 study guide for a first-attempt pass, and when you are ready to test yourself under exam-style conditions, try the C1000-198 practice tests to check your readiness across all six domains.
Frequently Asked Questions
It covers IBM Db2 v12.1 for Linux, UNIX and Windows administration at the Professional level, across six domains: Design and Architecture, Db2 Server and Client Installation and Management, Monitoring, Operating, Security and Compliance, and Business continuity.
The exam has 66 questions in 90 minutes, and 47 correct answers are required to pass. The format includes multiple-choice questions, multiple-response items and performance-based lab tasks.
Operating, at about 33% of the exam, deserves the most attention, followed by Monitoring at 18%. The published weights are approximate, so use them as a guide to allocating study time rather than as exact question counts.
IBM permits at most two attempts at the same exam within any 30-day period and charges the regular retake price. You 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 that is target-candidate guidance. Confirm any registration conditions on the IBM and Pearson VUE pages when you book. For more on the background, see our C1000-198 certification overview.