Ability to alter limit keys for materialized query tables
In Db2 11, you can alter limit keys for materialized query tables or tables that are referenced by materialized query tables.
In earlier versions of Db2, you cannot alter limit keys in materialized query tables or tables that are referenced by materialized query tables. You must unload the data, drop the table, re-create the table with the new partition limit key, and then reload the data.
In Db2 11, you can change the limit key for materialized query tables or tables that are referenced by materialized query tables just as you would for other tables. The only restriction is that the table must be in a partition-by-range table space or in a table space that partitioned (non-universal) with table-controlled partitioning. If this requirement is met, you can use an ALTER TABLE statement to change the limit key. In most cases, changing the limit key is a pending definition change. Changing the limit key has no impact to data availability.