1. 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
2. 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
3. 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
4. Partition management part 1
- Adding partitions
- Rotating partitions
5. Partition management part 2
- Modifying limit keys
- Rebalancing partitions
6. 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
7. 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
8. REORG
- Performance features of REORG
- Online REORG
- Inline image copies and statistics
- Considerations for PBG table spaces
- Online REORG with LOBs (optional)
9. UNLOAD
- Overview
- Image copy specification
- Table-only input specification
- SHRLEVEL option
- Modes of operation
10. Program preparation and the use of packages part 2 (optional)
- Table mirroring
- Package versioning
- Plan management
- Other REBIND PACKAGE options
- Application compatibility
11. Stored procedures part 2 (optional)
- Native stored procedures
- Native procedure deployment
- Installation preparation for DB2 10 for z/OS
- Installation CLIST
- Installing the DB2 10 subsystem
- Verification of DB2 10 with the sample applications
- Performing parameter update
- Migrating to DB2 11 conversion mode
- DB2 10 enabling-new-function and new-function modes
- Verification of DB2 11 with the sample applications
- 10-byte RBA and LRSN (new)