CDB/Auto-Online Reorg reorganizes data much faster than alternative Reorg methods. Based on user-defined criteria, CDB/Auto-Online Reorg will automatically determine what tablespaces need to be reorged and dynamically allocate needed workspace.

Employing a patented no SORT process, CDB/Auto-Online Reorg allows continuous data availability in the following manner: CDB/Auto-Online Reorg reorganizes the tablespace and all indexes and creates a ""B"" copy of the original tablespace and indexes. CDB/Online-Reorg applies all inserts, updates and deletes made by DB2 during the reorg to the ""B"" copy. CDB/Auto-Online Reorg renames all original ""A"" datasets to a temporary name, all ""B"" datasets to ""A"", and deletes all original ""A"" datasets.

CDB/Auto-Online Reorg creates an Image Copy of the new ""A"" dataset. CDB/Auto-Online Reorg concurrently creates up to 4 IBM-compatible Image Copies, processes partitioned tablespaces in parallel, and optionally updates the DB2 catalog. It is completely non-destructive and will automatically restart in the event of a job failure without any JCL changes.