DISABLEREORGTABLE

The DISABLEREORGTABLE option specifies whether online table reorganization is disabled for table names that are specified in the tables list.

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

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DISABLEREORGTable----tablelist------------------------------><

Parameters

tablelist
Specifies a list of table names for which table reorganization is disabled. If you do not specify any table names with the option, or if the option is not in the options file, no tables are disabled.
Restriction: The following tables are already excluded from table reorganization processing and cannot be specified for this option:
  • STAGED_EXPIRING_OBJECTS
  • STAGED_OBJECT_IDS
  • BF_DEREFERENCED_CHUNKS
  • BF_QUEUED_CHUNKS

Example

DISABLEREORGTABLE BF_BITFILE_EXTENTS,REPLICATING_OBJECTS