This course introduces the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.
- Program preparation and the use of packages part 1 Program preparation overview Execution time errors BIND actions Package status and REBIND Deleting a package Determining the table/view qualifier
- Online schema changes part 1 Changing data type Adding columns to a table Renaming columns in a table Renaming indexes Adding columns to indexes Versioning
- Online schema changes part 2 Pending online schema changes Dropping columns from a table Converting to UTS Other pending changes Impact of pending changes on immediate options Restrictions and considerations
- Partition management part 1 Adding partitions Rotating partitions
- Partition management part 2 Modifying limit keys Rebalancing partitions
- Stored procedures part 1 External stored procedures WLM-established application environments Altering and dropping a stored procedure Commands for stored procedures Execution privileges Catalog information
- LOAD and REBUILD INDEX LOAD with parallel index build LOAD partitions in parallel REBUILD INDEX Inline image copies and statistics LOAD SHRLEVEL CHANGE LOAD REPLACE SHRLEVEL REFERENCE
- REORG Performance features of REORG Online REORG Inline image copies and statistics Consideratons for PBG table spaces Online REORG with LOBs (optional)
- UNLOAD Overview Image copy specification Table-only input specification SHRLEVEL option Modes of operation
- Program preparation and the use of packages part 2 (optional) Table mirroring Package versioning Plan management Other REBIND PACKAGE options Application compatibility
- Stored procedures part 2 (optional) Native stored procedures Native procedure deployment
Who Can Benefit
This course is for administrators who need to augment their skills in administering a Db2 12 for z/OS database environment.
- Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
- Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements
- Basic skills administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.