DISABLEREORGINDEX

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

Read syntax diagramSkip visual syntax diagram
                      .-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