Detailed Course Outline
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 • Considerations 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