I B M C E R T I F I C A T I O N
C0005400 IBM Certified Administrator – Db2 12 for z/OS Practice Exam
Exam Number: 4374 | Last updated April 17, 2026 | 401+ questions across 5 vendor-aligned objectives
z/OS-DBA professionals who administer Db2 12 for z/OS in production target the C0005400 credential. Unlike the associate-level fundamentals exam, this administrator track focuses on day-to-day operations — performance tuning, utility execution, backup and recovery, and the operational surface that keeps Db2 healthy. Candidates should be fluent with Db2 utilities, the bufferpool monitoring interface, log management, and recovery scenarios.
Shouldering 26% of the exam, Utility Operations covers LOAD, REORG, RUNSTATS, COPY, and the broader utility suite including online versus offline variants. At 22%, Performance and Tuning covers bufferpool sizing, access-path analysis, and query-performance diagnosis. A further 20% targets Backup and Recovery, covering image copies, log-based recovery, PITR scenarios, and the recovery PITA trade-offs.
Crimping the remaining domains, Locking and Concurrency accounts for 18% and spans lock escalation, isolation-level effects, and contention troubleshooting. Security Administration represents 14% and spans privileges, row and column access control, and authentication integration. Administrators should expect scenario questions where the right answer turns on which utility to run in which order — memorize the dependencies.
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 →
758
practice exam users
94%
satisfied users
91%
passed the exam
4.6/5
quality rating
Test your C0005400 db2 v12 admin knowledge
10 of 401+ questions
Question #1 - Utility Operations
A Db2 12 for z/OS admin at Brentmoor Bank needs to reorganize a fragmented tablespace with minimal outage.
Which Db2 12 utility operation fits?
A) Run REORG TABLESPACE with SHRLEVEL CHANGE so applications continue to access the data during the reorganization, and the utility makes the switch at the end
B) Run REORG with SHRLEVEL NONE during business hours
C) Skip REORG entirely and accept fragmentation
D) Drop and recreate the tablespace
Show solution
Correct answers: A – Explanation:
REORG SHRLEVEL CHANGE is the Db2 12 online-reorg reference. SHRLEVEL NONE at peak, skipping, and drop-and-recreate all fail utility operations. Source: Check Source
Question #2 - Utility Operations
A Db2 12 admin at Parsfield Insurance must load a large flat file into a table overnight.
Which Db2 12 utility fits?
A) Use the LOAD utility with appropriate options (RESUME, REPLACE, LOG NO where appropriate) and run it within the maintenance window, running RUNSTATS afterward so the optimizer has current statistics
B) Write one INSERT per row and run overnight
C) Load data via FTP without a Db2 utility
D) Skip loading and enter data manually
Show solution
Correct answers: A – Explanation:
LOAD post-load RUNSTATS is the Db2 12 bulk-load reference. Row-at-a-time inserts, FTP-only, and manual entry all fail utility practice. Source: Check Source
Question #3 - Utility Operations
A Db2 12 admin at Caldwick Bank must take an image copy for recovery purposes without blocking applications.
Which Db2 12 utility option fits?
A) Power down Db2 to take a copy
B) Run COPY with SHRLEVEL REFERENCE during peak hours
C) Skip image copies and rely on crash-recovery only
D) Run COPY with SHRLEVEL CHANGE to produce a full image copy while applications continue to access the data
Show solution
Correct answers: D – Explanation:
COPY SHRLEVEL CHANGE is the Db2 12 online image-copy reference. Reference-level during peak, no-copy, and Db2 power-down all fail utility operations. Source: Check Source
Question #4 - Performance and Tuning
A Db2 12 admin at Hornmere Credit sees heavy synchronous I/O on a mission-critical bufferpool.
Which Db2 12 performance adjustment fits?
A) Ignore bufferpool tuning and add more indexes
B) Decrease the bufferpool to save memory and accept more I/O
C) Increase the bufferpool’s VPSIZE and review thresholds (DWQT, VDWQT) so more pages stay resident in memory, reducing synchronous I/O for the hot objects
D) Disable bufferpools
Show solution
Correct answers: C – Explanation:
Bufferpool size/threshold tuning is the Db2 12 performance reference. Shrinking, ignoring, and disabling bufferpools all fail performance tuning. Source: Check Source
Question #5 - Performance and Tuning
A Db2 12 admin at Ebbsfield Insurance sees a query with an unexpected access path.
Which Db2 12 diagnostic step fits?
A) Rebind every package in the system blindly
B) Guess at the access path without EXPLAIN
C) Use EXPLAIN to capture the access path to PLAN_TABLE, review the plan for index usage and join methods, and confirm statistics are current before deciding whether to rebind or add indexes
D) Delete the query
Show solution
Correct answers: C – Explanation:
EXPLAIN PLAN_TABLE stats targeted rebind is the Db2 12 performance-diagnosis reference. Guesses, blanket rebinds, and deletion all fail diagnosis. Source: Check Source
Question #6 - Backup and Recovery
A Db2 12 admin at Holborne Bank must recover a tablespace to a specific point in time within the last 24 hours.
Which Db2 12 recovery approach fits?
A) Skip recovery and accept data loss
B) Drop and recreate the tablespace
C) Restore the last full image copy and ignore logs
D) Run RECOVER with TOLOGPOINT (or TORBA) to the desired point, following the documented recovery order for the tablespace and its dependent objects
Show solution
Correct answers: D – Explanation:
RECOVER TOLOGPOINT with dependency ordering is the Db2 12 PITR reference. Drop-and-recreate, image-only restores, and skipping all fail recovery. Source: Check Source
Question #7 - Backup and Recovery
A Db2 12 admin at Millsdale Financial must decide how often to take full image copies versus incremental copies.
Which Db2 12 backup-strategy concept fits?
A) Take only full image copies regardless of cost
B) Balance full image copies (longer to take, faster to recover) against incremental copies (faster to take, longer recovery chain) based on recovery-time objectives and change volume, then document the schedule
C) Take only incremental copies with no full baseline
D) Skip backups and rely on fault-tolerance
Show solution
Correct answers: B – Explanation:
Full incremental balance driven by RTO and change volume is the Db2 12 backup-strategy reference. Full-only, incremental-only, and skipping all fail recovery design. Source: Check Source
Question #8 - Locking and Concurrency
A Db2 12 admin at Oldspring Credit sees applications experiencing lock escalation unexpectedly.
Which Db2 12 concept explains the behavior?
A) Db2 never escalates locks
B) Lock escalation happens when a single resource acquires enough row/page locks to cross NUMLKTS (or LOCKMAX on the tablespace), escalating to a table-level lock that can block other transactions
C) Lock escalation is an application bug unrelated to Db2 limits
D) Lock escalation happens only at midnight
Show solution
Correct answers: B – Explanation:
NUMLKTS / LOCKMAX-driven lock escalation is the Db2 12 concurrency reference. ‘Never escalates’, ‘app bug’, and time-based mythology all misstate locking. Source: Check Source
Question #9 - Locking and Concurrency
A Db2 12 admin at Ravensmead Insurance must reduce contention between a long reader and short writers on the same table.
Which Db2 12 isolation-level adjustment fits?
A) Run both at ISOLATION(RR) to hold locks longer
B) Consider running the long reader with ISOLATION(UR) — uncommitted read — to avoid acquiring locks on the data it reads, accepting the possibility of dirty reads in the reporting use case
C) Ignore isolation and use RS for both with exclusive locks
D) Disable locking entirely
Show solution
Correct answers: B – Explanation:
UR for tolerant long readers is the Db2 12 contention reference. RR-for-both, RS-exclusive, and locking-off all fail concurrency tuning. Source: Check Source
Question #10 - Security Administration
A Db2 12 admin at Pebblewick Trust must implement row-level security so each branch sees only its customers.
Which Db2 12 security feature fits?
A) Configure RCAC row permissions so SELECT/UPDATE statements transparently filter rows by branch based on the session’s authorization ID
B) Rely on application-level filters and trust the UI
C) Grant every branch access to every row and hope
D) Remove the branch column entirely
Show solution
Correct answers: A – Explanation:
RCAC row permissions is the Db2 12 row-security reference. App-level filtering, universal grants, and column removal all fail row security. Source: Check Source
Get 401+ 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 C0005400 db2 v12 admin exam measures
- Run and schedule LOAD, REORG, RUNSTATS, COPY, and the broader utility suite to keep Db2 objects healthy and maintenance windows on schedule
- Tune and analyze bufferpool sizing, access-path analysis, and query-performance diagnosis to sustain query-response SLAs as data volumes and workloads evolve
- Back up and recover image copies, log-based recovery, PITR scenarios, and recovery trade-offs to recover from data loss and corruption within business-required RTOs
- Manage and resolve lock escalation, isolation levels, and contention troubleshooting to keep concurrent workloads running without locking each other out unnecessarily
- Grant and audit privileges, row and column access control, and authentication to enforce data-access policy consistently across applications and users
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 administrator db2 12 for z os C0005400 — 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
Db2 z/OS administrators remain in steady demand at banks, insurers, and agencies running mainframe databases:
- Db2 z/OS Database Administrator — $110,000–$150,000 per year, running Db2 estates at banks and insurers (Glassdoor salary data)
- Senior Mainframe DBA — $125,000–$165,000 per year, leading Db2 performance and upgrade work (Indeed salary data)
- Mainframe DBA Consultant — $130,000–$175,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.