I B M C E R T I F I C A T I O N
C9006700 IBM Certified Db2 13 for z/OS Database Administrator – Professional Practice Exam
Exam Number: 4392 | Last updated April 17, 2026 | 412+ questions across 5 vendor-aligned objectives
Senior-DBA professionals who own enterprise Db2 13 for z/OS estates target the C9006700 credential. This professional-level exam goes beyond the associate track — deep performance tuning, complex recovery scenarios, high-availability design, and the operational practices that distinguish senior DBAs. Candidates should be fluent with Db2 utilities, dynamic SQL management, bufferpool tuning at scale, and Db2 data-sharing mechanics.
Piling on 26% of the exam, Performance and Tuning covers bufferpool tuning, access-path analysis, RUNSTATS strategy, and dynamic SQL governor. At 22%, Recovery and Availability covers log-based recovery, data-sharing recovery, PITR, and cross-site recovery planning. A further 20% targets Data Sharing and Parallel Sysplex, covering data-sharing groups, coupling-facility tuning, and workload distribution.
Lathing the final domains, Advanced Utility Operations accounts for 18% and spans online REORG, utility automation, and cross-system consistency. Security and Compliance represents 14% and spans trusted contexts, row and column access control, and audit-policy authoring. Professional questions reward depth in data-sharing — many scenarios hide the root cause in coupling-facility structures rather than in the Db2 subsystems themselves.
Every answer links to the source. Each explanation below includes a hyperlink to the exact IBM documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
759
practice exam users
94%
satisfied users
91%
passed the exam
4.7/5
quality rating
Test your C9006700 db2 v13 admin professional knowledge
10 of 412+ questions
Question #1 - Performance and Tuning
A senior Db2 13 DBA at Oakhaven Capital sees heavy synchronous read I/O against a critical bufferpool.
Which Db2 13 performance-tuning action fits?
A) Analyze bufferpool hit ratios via DISPLAY BUFFERPOOL, increase VPSIZE as headroom allows, tune thresholds (DWQT, VDWQT, page-stealing algorithm), and monitor the result against baseline
B) Randomly enlarge every bufferpool by 50% without analysis
C) Shrink the bufferpool to force more I/O for clarity
D) Ignore bufferpool tuning and add more indexes blindly
Show solution
Correct answers: A – Explanation:
DISPLAY BUFFERPOOL-driven tuning with thresholds monitoring is the Db2 13 professional performance reference. Random enlargement, shrinkage, and index-blind-adding all fail tuning. Source: Check Source
Question #2 - Performance and Tuning
A senior Db2 13 DBA at Brandlmere Insurance finds a dynamic SQL query flooding the system with bad plans.
Which Db2 13 professional tool fits?
A) Accept the bad plans as unchangeable
B) Disable the offending query globally without governor controls
C) Use the Dynamic SQL Governor (resource-limit facility) with appropriate profile rules to constrain the runaway query, and collaborate with developers to address the underlying query rather than rely solely on runtime limits
D) Ask Db2 to stop accepting dynamic SQL entirely
Show solution
Correct answers: C – Explanation:
Resource-limit facility / dynamic SQL governor developer collaboration is the Db2 13 professional reference. Global kills, acceptance, and dynamic-SQL bans all fail tuning practice. Source: Check Source
Question #3 - Performance and Tuning
A senior Db2 13 DBA at Pembleton Trust designs a RUNSTATS strategy for tables with varying update patterns.
Which Db2 13 strategy fits?
A) Run RUNSTATS once at install and never again
B) Run RUNSTATS on every table every day uniformly
C) Skip RUNSTATS because the optimizer adapts on its own
D) Stratify RUNSTATS by table volatility — run full RUNSTATS on volatile tables frequently, lightweight RUNSTATS on stable tables less often, and targeted column/index statistics where the optimizer shows sensitivity
Show solution
Correct answers: D – Explanation:
Volatility-stratified RUNSTATS is the Db2 13 professional statistics-strategy reference. Uniform-every-day, skipping, and once-and-done all fail statistics discipline. Source: Check Source
Question #4 - Recovery and Availability
A senior Db2 13 DBA at Hallingford Bank must plan cross-site recovery for a tier-1 application.
Which Db2 13 recovery design fits?
A) Rely solely on local image copies with no off-site component
B) Combine local image copies, off-site log shipment, and a cross-site recovery plan (active-standby or active-active depending on tooling) aligned to the business’s RTO and RPO, and drill the plan periodically
C) Skip cross-site planning because single-site DR is enough
D) Copy the database manually once a quarter and hope
Show solution
Correct answers: B – Explanation:
Local copies off-site logs cross-site plan drills is the Db2 13 recovery reference. Local-only, no-cross-site, and quarterly manual copies all fail cross-site recovery. Source: Check Source
Question #5 - Recovery and Availability
A senior Db2 13 DBA at Rosevale Credit must recover a single tablespace to a point-in-time five minutes before an accidental update.
Which Db2 13 recovery approach fits?
A) Restore the last full image copy and accept the intermediate loss
B) Run RECOVER with TOLOGPOINT to the precise RBA (or LRSN) before the accidental update, following dependency ordering for related objects — and verify data integrity before releasing the objects to applications
C) Drop and recreate the tablespace empty
D) Skip recovery and tell users to re-enter data
Show solution
Correct answers: B – Explanation:
RECOVER TOLOGPOINT with dependency ordering verification is the Db2 13 PITR reference. Image-only restore, drop-and-recreate, and user-re-entry all fail PITR. Source: Check Source
Question #6 - Data Sharing and Parallel Sysplex
A senior Db2 13 DBA at Meadowcliff Financial must add a member to an existing data-sharing group.
Which Db2 13 data-sharing procedure fits?
A) Start a standalone Db2 and hope it joins
B) Clone another member’s datasets and start it without DSG registration
C) Follow the documented add-member procedure — provision the member’s subsystem, register with the DSG, configure coupling-facility structures, and start the member so it joins the group cleanly
D) Skip data sharing and run independent subsystems
Show solution
Correct answers: C – Explanation:
Documented add-member procedure with CF structure configuration is the Db2 13 data-sharing reference. Dataset clone without registration, standalone start, and skipping DSG all fail data-sharing admin. Source: Check Source
Question #7 - Data Sharing and Parallel Sysplex
A senior Db2 13 DBA at Vermont Ridge Trust sees global-lock contention in a data-sharing group during peak.
Which Db2 13 data-sharing tuning step fits?
A) Add more members to spread the contention automatically
B) Ignore CF tuning and blame the application
C) Disable data sharing to remove the CF involvement
D) Analyze coupling-facility structure usage, tune lock-structure size and MODIFY LOCKS thresholds, and consider partitioning or affinity so unrelated workloads touch different lock entries
Show solution
Correct answers: D – Explanation:
CF structure analysis lock-structure tuning workload placement is the Db2 13 professional data-sharing reference. CF-ignoring, disabling data sharing, and member-adding-blind all fail tuning. Source: Check Source
Question #8 - Advanced Utility Operations
A senior Db2 13 DBA at Brinkhaven Insurance must reorganize a 10-TB partitioned tablespace with minimal outage.
Which Db2 13 advanced utility approach fits?
A) Run REORG with SHRLEVEL CHANGE on specific partitions (online REORG), using appropriate parallelism options and monitoring log overhead, so the bulk of the reorganization happens concurrently with application access
B) Run REORG with SHRLEVEL NONE during business hours
C) Skip REORG and accept fragmentation indefinitely
D) Drop and recreate the tablespace
Show solution
Correct answers: A – Explanation:
Per-partition online REORG with tuned parallelism is the Db2 13 advanced-utility reference. Offline REORG during peak, skipping, and drop-and-recreate all fail advanced utility practice. Source: Check Source
Question #9 - Advanced Utility Operations
A senior Db2 13 DBA at Hollandsmith Credit automates utility execution across many subsystems.
Which Db2 13 utility-automation approach fits?
A) Hand-type utility commands interactively on every subsystem
B) Author utility jobs parameterized by subsystem, schedule via the enterprise scheduler, and monitor outcomes centrally — with error handling that opens tickets on failures
C) Skip automation and run utilities ad-hoc during incidents
D) Invent a custom utility framework unrelated to Db2 utilities
Show solution
Correct answers: B – Explanation:
Parameterized jobs enterprise scheduling central monitoring error-handling is the Db2 13 advanced-utility-automation reference. Hand-typing, ad-hoc runs, and custom frameworks all fail automation. Source: Check Source
Question #10 - Security and Compliance
A senior Db2 13 DBA at Wilmington Ledger must enforce that audit events for row updates on sensitive tables are captured for compliance.
Which Db2 13 security-and-compliance capability fits?
A) Define an audit policy targeting the sensitive tables with the relevant events (EXECUTE, CHANGE), enable the policy via START TRACE with IFCID records, and ensure captured records are archived per retention policy
B) Rely on application logs only for database-level audit
C) Disable audit because it adds overhead
D) Capture audit data only during business hours and skip the rest
Show solution
Correct answers: A – Explanation:
Audit policies START TRACE archived IFCIDs is the Db2 13 compliance reference. App-logs-only, audit-off, and business-hours-only all fail compliance audit. Source: Check Source
Get 412+ more questions with source-linked explanations
Every answer traces to the exact IBM documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated April 17, 2026
Learn more...
What the C9006700 db2 v13 admin professional exam measures
- Tune and analyze bufferpools, access paths, RUNSTATS strategy, and dynamic SQL governor to sustain query performance at enterprise scale through changing workloads
- Recover and coordinate log-based recovery, data-sharing recovery, PITR, and cross-site plans to meet aggressive RTO and RPO targets for mission-critical Db2 estates
- Share and balance data-sharing groups, coupling-facility tuning, and workload distribution to scale Db2 workloads across multiple members without hot-spotting
- Reorganize and automate online REORG, utility automation, and cross-system consistency to keep large Db2 estates healthy through routine maintenance without downtime
- Trust and audit trusted contexts, row and column access control, and audit policies to enforce enterprise-grade security and compliance requirements consistently
How to prepare for this exam
- Review the official exam guide to understand every objective and domain weight before you begin studying
- Work through the relevant IBM Training learning path — ibm certified db2 13 for z os database administrator professional C9006700 — to cover vendor-authored material end-to-end
- Get hands-on inside IBM TechZone or a comparable sandbox so you can practice the console tasks, CLI commands, and APIs the exam expects
- Tackle a real-world project at your workplace, a volunteer role, or an open-source repository where the technology under test is actually in use
- Drill one exam objective at a time, starting with the highest-weighted domain and only moving on once you can teach it to someone else
- Study by objective in PowerKram learn mode, where every explanation links back to authoritative IBM documentation
- Switch to PowerKram exam mode to rehearse under timed conditions and confirm you consistently score above the pass mark
Career paths and salary outlook
Senior Db2 13 DBAs command premium rates at mainframe-heavy enterprises leading continuous-delivery upgrades:
- Senior Db2 z/OS DBA — $125,000–$170,000 per year, running Db2 13 estates at banks and insurers (Glassdoor salary data)
- Principal Database Engineer — $140,000–$185,000 per year, leading Db2 strategy and upgrade programs (Indeed salary data)
- Mainframe Database Consultant — $135,000–$180,000 per year, advising enterprises on Db2 strategy and tuning (Glassdoor salary data)
Official resources
Work through the official IBM Training learning path for this certification, which bundles videos, labs, and skill tasks aligned to every objective. The official exam page lists the full objective breakdown, prerequisite knowledge, and scheduling details.