This utility command can be used to re-organize tables and indexes either in online or in offline mode to improve storage efficiency, and reduce the I/O access cost. This utility can also be used to implement various compression algorithms for tables and indexes. The basic command syntax for REORG is this:
REORG TABLE [TableName] <INDEX [IndexName]> <ALLOW READ ACCESS | ALLOW NO ACCESS> <USE [TmpTSName]> <INDEXSCAN> <LONGLOBDATA <USE [LongTSName]>> <KEEPDICTIONARY | RESETDICTIONARY> <RECLAIM EXTENTS [ALLOW [WRITE | READ | NO] ACCESS]> Or REORG TABLE [TableName] <INDEX [IndexName]> INPLACE [ALLOW READ ACCESS | ALLOW NO ACCESS] [<TRUNCATE | NOTRUNCATE TABLE> | <CLEANUP OVERFLOWS>] [START | RESUME] | [STOP | PAUSE] Or REORG ...
