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