The DISABLEREORGINDEX option specifies whether online index reorganization is disabled for tables that are listed.
To use the DISABLEREORGINDEX option, you must halt the server, update the options file, and then restart the server.
Syntax
.-Default list-.
>>-DISABLEREORGIndex--+-tablelist----+-------------------------><
Parameters
- tablelist
- Specifies a list of table names for which index reorganization
is disabled. If the option is not specified, the default list includes
the following tables:
- ARCHIVE_OBJECTS
- BACKUP_OBJECTS
- BF_AGGREGATED_BITFILES
- BF_BITFILE_EXTENTS
Restriction: The following tables are already excluded
from table reorganization processing and cannot be specified for this
option:
- STAGED_EXPIRING_OBJECTS
- STAGED_OBJECT_IDS
- REPLICATING_OBJECTS
- REPLICATED_OBJECTS
- BF_DEREFERENCED_CHUNKS
- BF_QUEUED_CHUNKS
Example
DISABLEREORGINDEX ARCHIVE_OBJECTS,BF_BITFILE_EXTENTS