IBM Db2 13 z/OS DBA Professional case studies
IBM Db2 13 z/OS DBA Professional · Put your knowledge to work in context.
The IBM Db2 13 z/OS DBA Professional credential is intended for database administrators who manage Db2 13 for z/OS environments. However, as of the retrieval date (2026-11-05), the official IBM Training page for this certification returns a 'Certification not found' message, indicating that the certification does not exist or is not available. Consequently, no exam details such as question count, duration, passing score, fee, or domain weights can be confirmed. Candidates interested in Db2 13 z/OS administration should monitor IBM Training for updates. The IBM Db2 13 z/OS DBA Professional case studies are 5 cases and about 2,827 words.
1Adding Range Partitions to a Near-Full PBR Table Space
Your shop runs Db2 13 for z/OS with a 4K-page PBR table space SALES.FACT on TRANS DATE. It has MAXPARTITIONS 240, DSSIZE 8G, 240 partitions, and the last partition is defined ENDING AT ('2025-12-31') with no MAXVALUE.
668 words, about 3 min2Static Package Regression After Statistics Refresh
An online banking query joins ACCT and TXN on ACCT ID, filters TXN.STATUS = :hv and TXN.POST DATE between :start and :end, and orders by POST DATE. It is static SQL in a CICS package bound with REOPT(NONE).
567 words, about 3 min3Recovery After LOAD REPLACE LOG NO
At 02:15 a batch job loads 40 million rows into SALES.ORDERS with LOAD REPLACE LOG NO, then runs an update that abends at 02:47. The table space is PBR with 36 partitions; the load used SHRLEVEL NONE and ENFORCE CONSTRAINTS.
535 words, about 3 min4Dynamic SQL Authorization After Plan-to-Package Migration
Your company is migrating a CICS/COBOL transaction from a plan to a package. The transaction uses both static SQL and dynamic SQL built from user-entered account filters.
519 words, about 3 min5Splitting an Oversized REORG SHRLEVEL CHANGE Job
Your Db2 13 subsystem has a 1.4 TB PBR table space with 200 partitions. Partitions 1-150 are read-only history; partitions 151-200 are active and receive 70% of updates.
538 words, about 3 min