Alternative method for altering an index

You can minimize the potential for data outages by using the ALTER INDEX statement with the BUFFERPOOL option.

The BUFFERPOOL option is supported as a pending definition change. If pending changes do not exist at the table space level, you can materialize the pending changes by running one of the following utilities:
  • REORG INDEX with SHRLEVEL CHANGE or SHRLEVEL REFERENCE
  • REORG TABLESPACE with SHRLEVEL CHANGE or SHRLEVEL REFERENCE

If pending changes exist at the table space level, you can materialize the pending changes that are associated with the table space (including the pending changes for the index) by running REORG TABLESPACE with SHRLEVEL CHANGE or SHRLEVEL REFERENCE.