Warning: This only concerns DB2 for Windows databases.
This program is used to reorganize Adelia Studio environments.
Reorganizing an environment lets you:
rebuild the accesses,
reduce disk space requirements,
optimize the product's performance.
Access
To reorganize an Adelia Studio environment, execute the command Db2Reorg <EnvironmentName>, from a DB2 command prompt.
This option opens an MS-DOS command window showing the progress of the procedure.
The reorganization procedure can be broken down into two phases:
- Reorganization of the Adelia tables.
- Statistics gathering.