Location of Files In Reorganizations

The following sets of files are involved in reorganizations and compactions.

• Original database files (.dat files)

• Reorganization work files (.reo files)

• Backups of the original database files (.bak files)

By default, the reorganization work files and the database backup files are located in the database directory. This requires significant free-space (at least double the size of the files being reorganized) to be maintained on the database volume.

Alternatively, you can use the following parameters in the JADE initialization file to manage the disk space requirements in a more-flexible way.

• ReorgWorkDirectory parameter in the [JadeReorg] section, which enables you to create reorganization work files on a volume other than the database volume.

• ReorgBackupDirectory parameter in the [JadeReorg] section, which enables you to locate the backup files on a volume other than the database volume.

  When a reorganization or compaction instantiates a file, it renames the database file (.dat) as a backup file (.bak), causing the file to move from the database directory to the directory specified in the ReorgBackupDirectory parameter and then renames the work file (.reo) to become the database file (.dat), causing that file to move from the directory specified in the ReorgWorkDirectory parameter to the database directory.

• UseDiskCacheForReorg parameter, which enables you to use database disk cache instead of .the default memory mapped files for output (.reo) files and input (.dat) files in large reorganizations.

  When this parameter is set to true, apply it to both the primary and secondary databases, if applicable.

The optional noReorgRecovery parameter in the command line of the JADE non‑GUI client (jadclient) or batch Schema Load utility (jadloadb) program specifies whether recovery is required if a reorganization fails. When you set this parameter to true, dat files are removed rather than saved as .bak files. This minimizes disk space requirements at the cost of not being able to recover from a failure during the reorganization. The default value of this parameter is false.