C1000-198 logo
Focused certification exam prep
Start practice

C1000-198 Study Guide 2026: How to Pass on Your First Attempt

TL;DR
  • The exam has 66 questions in 90 minutes, and you need 47 correct answers to pass.
  • Operating carries roughly 33% of the weighting, so it deserves about a third of your study time.
  • IBM states the exam includes multiple-choice questions and performance-based lab tasks, so hands-on Db2 practice is mandatory.
  • IBM allows at most two attempts at the same exam within any 30 days, at the regular retake price.

What This Exam Actually Is

The C1000-198 exam leads to the IBM Certified Db2 v12.1 Database Administrator - Professional credential (credential code C9009700) under the IBM Professional Certification Program. It covers Db2 v12.1 for Linux, UNIX and Windows, the distributed-platform edition of Db2. The certification and the exam are both listed as live, and it is the only required exam for the credential. If you want a plain-language orientation before diving in, see What Is C1000-198 Certification?

Understand the scope clearly: this is a database administration exam. It tests whether you can run production Db2 instances, not whether you can write clever SQL or design application schemas. Every domain is framed around the work of a DBA: installing, operating, monitoring, securing, and recovering databases.

Who it is aimed at: IBM describes the intended Professional-level candidate as having at least two years of practical, hands-on experience. That is target-candidate guidance, not a formal eligibility gate, but it tells you the exam assumes you have actually run Db2 rather than only read about it. For a closer look at what is and is not formally required, read C1000-198 Requirements: Eligibility, Prerequisites & How to Qualify.

Format, Timing, and Booking Mechanics

ItemWhat IBM Publishes
Number of questions66
Time allowed90 minutes for the whole exam
Correct answers required47
LanguageEnglish
Question stylesMultiple-choice (including multiple-response) and performance-based lab tasks
DeliveryPearson VUE; test center or OnVUE, subject to the options offered for this exam at booking
Required examsOne

Doing the math on time

Ninety minutes across 66 questions averages a little under 82 seconds per question. That average is misleading, because lab-style tasks consume far more time than a simple recall item. Plan to move quickly through straightforward questions so you bank time for the tasks that require you to work through a procedure. IBM does not publish a separate time allotment for the practical portion, so the 90 minutes is shared across everything.

Passing math

The published cut is 47 correct answers out of 66. That works out to roughly 71%, which leaves room for 19 misses. Our breakdown in C1000-198 Passing Score: Exactly What You Need to Pass goes deeper on how to think about that margin. The practical point: you cannot afford to write off an entire domain, but you also do not need perfection anywhere.

Booking, prohibited materials, and fees

You register through the IBM certification pathway with Pearson VUE. Unauthorized reference materials are prohibited during the exam. As for cost, we could not verify a current certification-exam fee in the sources we reviewed, so check the live price at checkout and see C1000-198 Certification Cost: Complete Pricing Breakdown for how to approach budgeting. Be careful not to confuse this exam's price with the price of IBM's separate assessment exams. For scheduling logistics, C1000-198 Exam Dates: Testing Windows, Deadlines & Scheduling covers what to expect.

Where the Points Live: Six Domains

IBM publishes six exam-objective sections with approximate weights that total 100%. Here is how they stack up:

DomainApprox. WeightStudy Priority
Domain 4: Operating33%Highest
Domain 3: Monitoring18%High
Domain 5: Security and Compliance15%High
Domain 6: Business continuity14%High
Domain 2: Db2 Server and Client Installation and Management11%Medium
Domain 1: Design and Architecture9%Medium

Operating, Monitoring, Security and Compliance, and Business continuity together account for 80% of the exam. A candidate who is strong in those four can absorb weakness in the other two and still clear 47 correct answers. The reverse is nearly impossible. For a section-by-section walkthrough of what each domain tests, see C1000-198 Exam Domains: Complete Guide to All 6 Content Areas.

Domain 4: Operating, the One-Third Domain

Operating (approx. 33%)

This is the daily-work domain, and it is where lab tasks are most likely to appear. Think about everything a DBA does to keep a Db2 database healthy and serving workloads.

  • Creating and managing databases, table spaces, buffer pools, and storage groups
  • Managing database objects, including tables, indexes, views, and constraints
  • Moving data in and out with utilities such as load, import, export, and db2move
  • Maintenance utilities, including statistics collection and reorganization (RUNSTATS, REORG, REORGCHK)
  • Configuring database manager and database configuration parameters, and understanding which changes take effect immediately versus after a restart
  • Working from the Db2 command line processor and administrative SQL routines

Because this domain is a third of the exam, treat it as the backbone of your preparation. The recurring pattern in this kind of question is "given this situation, which command or setting accomplishes the goal with the least disruption?" Knowing that a command exists is not enough; you need to know its options, its prerequisites, and what state the database must be in.

Command fluency beats recall: If a task asks you to carry out a utility operation, you may need to produce correct syntax from memory in a live environment. Practice typing the commands, including the options you rarely use, until you can do it without looking anything up.

Monitoring, Security, and Business Continuity

Domain 3: Monitoring (approx. 18%)

What to master

Monitoring questions test whether you can find the cause of a performance or availability problem using Db2's own instrumentation.

  • Monitoring table functions and administrative views, and what each reports
  • Reading snapshot-style and event-based information to diagnose workload behavior
  • Locking and concurrency problems, including lock waits, escalations, and deadlocks
  • Memory and I/O indicators such as buffer pool hit ratios and sort overflows
  • The diagnostic log and how to interpret its messages

Domain 5: Security and Compliance (approx. 15%)

What to master

Expect questions about controlling who can do what, and proving it.

  • Authentication methods and where authentication happens
  • Authorities and privileges, and how GRANT and REVOKE interact with them
  • Role-based access control and trusted contexts
  • Row and column access control for fine-grained data protection
  • Encryption options and auditing facilities that support compliance requirements

Domain 6: Business continuity (approx. 14%)

What to master

This domain is about surviving failure and recovering cleanly. Note that IBM's official name uses lowercase "continuity".

  • Backup and restore strategies, including online, incremental, and delta backups
  • Logging modes and the difference between circular and archive logging, and what each makes possible
  • Roll-forward recovery and point-in-time recovery
  • High availability disaster recovery (HADR) concepts and role takeover behavior
  • Choosing a recovery approach that matches a stated recovery objective

Backup and recovery questions often hinge on a single constraint buried in the scenario, such as whether archive logging is enabled. Read each scenario for the detail that rules out otherwise plausible answers.

Design, Installation, and Client Management

Domains 1 and 2 together carry about 20% of the exam. They are lighter, but they are also the easiest points to protect if you have field experience, because they reward practical familiarity rather than deep memorization.

Domain 1: Design and Architecture (approx. 9%)

IBM's detailed study guide labels this domain "Design and Architecture", while its web summary says "Design and Architect". Both refer to the same 9% section.

  • How instances, databases, and table spaces relate to one another
  • Choosing storage and table space designs appropriate to the workload
  • Understanding Db2 process and memory architecture at a conceptual level
  • Selecting among deployment topologies and data organization options

Domain 2: Db2 Server and Client Installation and Management (approx. 11%)

  • Installing and configuring Db2 servers and clients on supported platforms
  • Instance creation and management, and preparing the operating system environment
  • Configuring client-to-server connectivity and cataloging nodes and databases
  • Applying fix packs and managing upgrades

If your day job is mostly operations, schedule extra time for design topics, since architecture decisions are often made before a DBA arrives on a project. Candidates on the other end, who design more than they operate, should invest in hands-on installation practice.

Preparing for Performance-Based Lab Tasks

IBM explicitly lists performance-based lab tasks alongside multiple-choice questions. That changes how you should prepare. Reading a study guide builds recognition; lab tasks demand production. If you have only ever studied by reading, you will find the difference uncomfortable on exam day.

  1. Build a practice environment. A Db2 v12.1 instance on a spare Linux machine or container gives you a safe place to break things and fix them.
  2. Rehearse end-to-end procedures. Create a database, load data, take a backup, damage the database, and restore it. Repeat until each step is automatic.
  3. Practice reading error output. Learn what SQLCODE and SQLSTATE messages tell you, and what to do about them.
  4. Time yourself. A procedure that takes you ten relaxed minutes may be unaffordable on a 90-minute exam.

IBM's official sample test is useful for understanding item formats, including multiple-response questions where more than one answer is correct. But IBM itself cautions that success on the sample does not predict success on the real exam, so treat it as a format preview, not a readiness gauge. For more on how to gauge difficulty honestly, see How Hard Is the C1000-198 Exam? Complete Difficulty Guide.

A Domain-Ordered Study Sequence

Rather than a generic schedule, order your weeks by weight and by dependency. Operating comes first because it is the largest domain and because monitoring and recovery both build on it.

Weeks 1-2

Operating: foundations

  • Stand up your practice instance and create databases, table spaces, and objects
  • Drill load, import, export, and db2move until the syntax is automatic
  • Practice RUNSTATS and REORG, and learn when each is warranted
Week 3

Operating: configuration, plus Design and Architecture

  • Work through database manager and database configuration parameters
  • Review instance, database, and table space relationships
Week 4

Monitoring

  • Use monitoring table functions to diagnose lock waits and memory pressure
  • Read the diagnostic log and trace a problem to a cause
Week 5

Business continuity

  • Run backups under different logging modes and recover to a point in time
  • Study HADR roles and takeover behavior
Week 6

Security and Compliance, plus Installation

  • Configure authorities, roles, and row and column access control
  • Practice installation, instance creation, and client cataloging
Week 7

Integration and review

  • Take timed practice sets and revisit your weakest domain
  • Rehearse full lab procedures against the clock

If you have more than two years of daily Db2 work, you can compress this plan. If your experience is narrower, extend the weeks devoted to whichever domains your job rarely touches. IBM offers recommended courses, but these are preparation aids and do not add extra exam domains. Our overview at C1000-198 Training covers how to choose among them, and the broader roadmap in C1000-198 Study Guide 2026: How to Pass on Your First Attempt ties these pieces together. For a quick last-week refresher, keep C1000-198 Cheat Sheet: One-Page Review of Must-Know Facts nearby.

Key Takeaway

Spend your first and longest block on Operating, and verify every concept in a live Db2 environment. Because the exam includes lab tasks, a topic you have only read about is a topic you have not yet learned.

Retake Rules and Why They Shape Your Plan

IBM permits at most two attempts at the same exam within any 30-day period, and a retake is charged at the regular retake price. IBM also prohibits retaking an exam you have already passed. Continuing validity of the credential is governed by IBM's Certification Agreement, so review it rather than assuming a particular renewal cycle.

The practical implication is that a rushed first attempt is an expensive way to find out what you do not know. A failed attempt does teach you which domains need work, but it costs you money and a waiting period, so go in prepared. Our analysis in C1000-198 Pass Rate: What the Data Shows explains why we avoid quoting a population pass rate: none has been verified from IBM's published sources.

Why bother with this credential: Db2 DBAs work in financial services, insurance, government, retail, and other industries that run large transactional systems. The certification signals verified, hands-on administration skill. For the career angle, see C1000-198 Jobs, and for a decision framework on cost versus benefit, read Is the C1000-198 Certification Worth It? Complete ROI Analysis.

When you are ready to test yourself under realistic conditions, the C1000-198 practice tests on our main site let you work through exam-style questions across all six domains, and you can use them to find the domains where your score lags before you book the real thing.

Frequently Asked Questions

How many questions are on the C1000-198 exam and how many must I get right?

The exam has 66 questions in 90 minutes, and IBM requires 47 correct answers to pass. The question set includes multiple-choice items, some with multiple correct answers, and performance-based lab tasks.

Which domain should I prioritize?

Operating, at roughly 33% of the exam, is the largest domain by a wide margin. Monitoring (18%), Security and Compliance (15%), and Business continuity (14%) follow. Together those four make up about 80% of the weighting.

Do I need two years of experience to sit the exam?

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 stated eligibility rule. Candidates with less experience can still pass, but should compensate with extensive lab practice.

How many times can I retake the exam?

IBM allows 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.

Can I take the exam from home?

IBM exams are delivered through Pearson VUE, which offers test centers and the OnVUE online option for IBM's program. Whether each option is available for this exact exam depends on what is offered at the time you book, so confirm during registration.

Ready to pass your C1000-198 exam?

Put this into practice with free C1000-198 questions across every exam domain.