Db2 12 z/OS DBA case studies
Db2 12 z/OS DBA · Put your knowledge to work in context.
The Db2 12 for z/OS Database Administrator credential validates the skills needed to administer Db2 for z/OS subsystems in production environments. It is aimed at experienced DBAs who design and maintain databases, tune SQL and subsystem performance, run utilities, manage backup and recovery, implement security, and support data sharing and high availability. The Db2 12 z/OS DBA case studies are 5 cases and about 3,358 words.
1Activating FL508 in a Three-Member Data Sharing Group
Subsystem DB2P is a three-member Db2 12 for z/OS data sharing group. All members are at function level FL504 and catalog level FL504.
677 words, about 3 min2Partitioned Secondary Index vs Non-Partitioned Index for Claims
CLAIMS is a 1.2-billion-row, 900-GB table in a Db2 12 subsystem. It is range-partitioned by claim month into 72 monthly partitions and has two indexes: a partitioning index on claim id and a 400-GB non-partitioned index on policy id.
710 words, about 4 min3Access Path Regression and REOPT Choice for a High-Volume OLTP Package
An OLTP package PKG ORDER runs 5,000 times per minute and uses host variables for order status and order date. Last week it averaged 3 ms; after a RUNSTATS on ORDERS, it averages 45 ms and the accounting trace shows more class 1 CPU but little class 3 wait.
678 words, about 3 min4Point-in-Time Recovery After a Committed Mass Delete
At 02:14 a production batch job committed a DELETE of 4.2 million rows from PAYMENTS, a 180-million-row table in a 1.4-TB Db2 12 subsystem. The job was supposed to delete one day of stale rows but omitted a predicate.
635 words, about 3 min5Statistics Strategy for a Skewed 400-GB Table
STATS is a 400-GB, 1.5-billion-row table with columns region, status, created date, and amount. One region accounts for 40% of rows; status has 12 values and is correlated with region.
658 words, about 3 min