Was this helpful?
Default Locations
During installation, default storage locations and underlying areas are established for each type of database file.
When you create a database, the default locations are assumed unless you specify alternate locations.
The following table shows the default locations and the Actian X environment variables that identify the areas to which the locations are mapped:
File Type
Location Name
Area
Data
ii_database
II_DATABASE
Checkpoint
ii_checkpoint
II_CHECKPOINT
Journal
ii_journal
II_JOURNAL
Dump
ii_dump
II_DUMP
Work
ii_work
II_WORK
In each case, the Actian X environment variable points to a specific disk volume or directory that has a particular structure, which is shown in the following tables.
Windows:
File Type
Structure
Data
ingres\data\default
Checkpoint
ingres\ckp\default
Journal
ingres\jnl\default
Dump
ingres\dmp\default
Work
ingres\work\default
For example, using the default location for data files causes them to be stored in the ii_database\ingres\data\default directory, where ii_database is the value displayed by the ingprenv command for the II_DATABASE environment variable.
Linux:
File Type
Structure
Data
ingres/data/default
Checkpoint
ingres/ckp/default
Journal
ingres/jnl/default
Dump
ingres/dmp/default
Work
ingres/work/default
For example, using the default location for dump files causes them to be stored in the ii_dump/ingres/dmp/default directory, where ii_dump is the value displayed by the ingprenv command for the II_DUMP environment variable.
Last modified date: 11/09/2022