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