Editing Ingres (database) (section)

=== Installation paths ===
Some important paths must be assigned at the location where the installation was created. The paths will not change without reinstallation, so you should take care to choose them.

The paths are shown in the following table. Note that the "II_" prefix does not indicate that these paths are for the "II" installation. Each installation, regardless of its ID, will have its own set of these variables.

{| class="wikitable" border="1"
|-
! Name
! Purpose
|- 
|II_SYSTEM
|Setup binary files, utilities, text files used for configuration, etc.
|-
|II_DATABASE
|Location of installation master data.
|-
|II_CHECKPOINT
|Database backup location.
|-
|II_JOURNAL
|Location where database installation transactions are logged. The logs use the recovery system to provide point-of-failure recovery. Can be used for audit purposes.
|-
|II_DUMP
|Location where "dump" installation files are stored. They can be generated during "online" database backups and [ what? ] to restore.
|-
|II_WORK
|Used to store work files generated by the server when querying the database.
|}