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
>>-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