DISABLEREORGCLEANUPINDEX

The DISABLEREORGCLEANUPINDEX option specifies whether online index reorganization is disabled for the BF_BITFILE_EXTENTS table, when the DB2® CLEANUP PAGES ALL parameter is used on the REORG INDEXES/TABLE command.

You can use the DISABLEREORGCLEANUPINDEX option to prevent the following scenarios:

The active log becoming full
Busy servers from stopping

To use the DISABLEREORGCLEANUPINDEX option, you must halt the server, update the options file, and then restart the server.

Syntax


>>-DISABLEREORGCleanupindex----tablelist-----------------------><

Parameters

tablelist: Specifies the table for which index reorganization cleanup is disabled. If the option is not specified, all tables are included in the index reorganization cleanup. Only the BF_BITFILE_EXTENTS table can be specified on this parameter.

DISABLEREORGCLEANUPINDEX BF_BITFILE_EXTENTS