Online schema enhancements

Db2 11 improves system and application availability by allowing recovery to a point in time before materialization of pending definition changes.

DB2® 10 improved the availability of table spaces and indexes by allowing pending definition changes. Pending definition changes are changes that are made by ALTER statements, but are not yet materialized. Examples are changing segment size, data set size, buffer pool page size, and the MEMBER CLUSTER attribute. Users can defer materialization of the changes until a convenient time. Materialization is accomplished by running the REORG utility. However, in DB2 10, after the REORG utility was run on the objects, you could not recover those objects to a point in time before the changes were materialized.

In Db2 11 you can recover the following objects to a point in time before the pending definition changes were materialized:

  • partition-by-range table spaces
  • LOB or XML table spaces
The pending definition changes must meet the following criteria:
  • The changes were materialized in Db2 11 new-function mode.
  • The changes were not changes to the table space type or the hash organization.