Program preparation and the use of packages part 1
- Program preparation overview
- Package status and REBIND
Determining the table/view qualifier
- Online schema changes part 1
- Adding columns to a table
- Renaming columns in a table
- Adding columns to indexes
Versioning
- Online schema changes part 2
- Pending online schema changes
- Dropping columns from a table
- Impact of pending changes on immediate options
Restrictions and considerations
- Partition management part 1
Rotating partitions
- Partition management part 2
Rebalancing partitions
- External stored procedures
- WLM-established application environments
- Altering and dropping a stored procedure
- Commands for stored procedures
Catalog information
- LOAD with parallel index build
- LOAD partitions in parallel
- Inline image copies and statistics
LOAD REPLACE SHRLEVEL REFERENCE
- Performance features of REORG
- Consideratons for PBG table spaces
Online REORG with LOBs (optional)
- Table-only input specification
Modes of operation
- Program preparation and the use of packages part 2 (optional)
- Other REBIND PACKAGE options
Application compatibility
- Stored procedures part 2 (optional)
Native procedure deployment