4.1 Online schema changes and enhanced recovery options4.1.1 Scope of enhancements for online schema changes in DB2 114.1.2 How it works4.1.3 Effect of MODIFY RECOVERY4.1.4 Considerations for LOBs4.1.5 Restrictions for the window between PIT recovery and REORG4.1.6 More restrictions for PIT recovery after materializing REORG4.1.7 Determine if a table space is eligible for PIT recovery prior to REORG4.2 Automatic recovery of indexes from GRECP or LPL status4.2.1 RESTORE SYSTEM after two-pass LPL/GRECP recovery has occurred4.2.2 RECOVER INDEX after two-pass LPL/GRECP recovery has occurred4.3 Improved availability when altering limit keys4.3.1 Considerations for tables containing LOBs4.3.2 LOAD REPLACE4.3.3 RECOVER4.4 Work file database enhancements4.4.1 WFSTGUSE_AGENT_THRESHOLD subsystem parameter4.4.2 WFSTGUSE_SYSTEM_THRESHOLD subsystem parameter4.4.3 Systems programmer response to DSNI052I/DSNI053I4.5 Governing of parallel processing of utilities4.6 Compression dictionary availability for CDC tables4.7 DROP column support4.7.1 Changes to the catalog as a result of dropping a column4.7.2 Undo a DROP COLUMN4.7.3 Impact of DROP COLUMN on utilities4.7.4 Impact of DROP COLUMN on applications4.7.5 Restrictions for DROP COLUMN4.8 Defer define object enhancements4.9 Allow BIND, REBIND, and DDL to break-in persistent threads4.10 Idle thread break-in4.10.1 Improvements for DDF threads4.10.2 Improvements for non-DDF threads