IBM CV880G - Db2 12 for z/OS Advanced Database Administration (Live Online Training) - Webinar von Cegos_Integrata GmbH

• 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

• 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

presentation, discussion, hands-on exercises

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.