Db2 12 z/OS DBA study guide
Db2 12 z/OS DBA · Work through your exam, one topic at a time.
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 study guide has 8 sections and about 2,289 words.
01Db2 Architecture, Subsystems, and Installation/Migration
This domain tests how a Db2 12 subsystem is assembled and how it is installed, migrated, and advanced to a new function level. A Db2 subsystem runs in several z/OS address spaces: MSTR for system services, logging, and restart; DBM1 for buffer pools, EDM pool, and SQL work; DIST for DDF; IRLM for locks; and SSPE for stored procedures.
318 words, about 2 min02Database Design, Objects, and Schema Management
This domain covers physical design in Db2 12: table spaces, indexes, compression, temporal and generated objects, and schema changes a DBA can make online. Universal table spaces are partition-by-range (PARTITION BY RANGE, NUMPARTS) or partition-by-growth (MAXPARTITIONS).
297 words, about 1 min03SQL and Application Performance for DBAs
This domain tests access-path reasoning and the bind and SQL choices that change performance. Stage 1 predicates are evaluated by Db2; stage 2 predicates are passed later.
277 words, about 1 min04Db2 Utilities and Data Movement
This domain covers COPY, REORG, RUNSTATS, LOAD, UNLOAD, CHECK, and the utility control statements that make them safe and efficient. COPY produces full or incremental image copies.
290 words, about 1 min05Backup, Recovery, and Log Management
This domain tests how Db2 12 protects data with image copies, logs, and point-in-time recovery, including data sharing recovery. Logs include active and archive logs, dual logging, and two BSDS copies.
297 words, about 1 min06Performance Monitoring, Tuning, and Statistics
This domain tests how to measure Db2 12 behavior and feed the optimizer with good statistics. Sources include Db2 statistics and accounting traces, SMF records, RMF, the Db2 performance monitor, and real-time statistics.
273 words, about 1 min07Security, Authorization, and Auditing
This domain covers Db2 12 authorities, privileges, row and column access control, and audit facilities. Authentication is usually RACF or an equivalent SAF product; Db2 uses primary and secondary auth IDs.
270 words, about 1 min08Availability, Data Sharing, and Operations Management
This domain tests running Db2 12 continuously: data sharing, restart, maintenance, and online operations. A data sharing group has members sharing a catalog and coupling-facility structures: SCA, lock structure, and group buffer pools.
267 words, about 1 min