There are several restrictions that apply to reorg
defrag.
- Tables must be data-only-locking (DOL) and have at least one index to use
reorg defrag. Sybase recommends that the table has a
unique index to efficiently accommodate the movement of the forwarded locations
during reorganization.
- You can run only one instance of reorg defrag at a time on a
table.
- When reorg defrag is in progress, DDLs cannot run on the
table, for example add/drop partition, create/drop index, add/modify/drop
columns. Also, other existing reorg subcommands like
rebuild/reclaim/compact/forwarded
rows cannot run when reorg defrag is in
progress.