REORG UTILITY IN DB2 is used to reorganize DB2 tables and indexes and there by improving their efficiency of access re-clusters data, resets free space to the amount specified in the ?create DDL? ,statement and deletes and redefines underlying VSAM datasets for stogroup defined objects.
The online REORG TABLESPACE utility reorganizes a table space to improve access performance and to reclaim fragmented space. In addition, the utility can reorganize a single partition or range of partitions of a partitioned table space. You can specify the degree of access to your data during reorganization, and you can collect inline statistics by using the STATISTICS keyword. If you specify REORG TABLESPACE UNLOAD EXTERNAL, the data is unloaded in a format that is acceptable to the LOAD utility of any DB2 subsystem. You can also delete rows during the REORG job by specifying the DISCARD option.