3. Using Alternate Locations : Locations and Areas : Default Locations
 
Share this page                  
Default Locations
During installation, default storage locations and underlying areas are established for each type of database file.
When you create a database, the Ingres default locations are assumed unless you specify alternate locations.
The following table shows the default locations and the Ingres 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 Ingres 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.
UNIX:
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.
VMS:
File Type
Structure
Data
[INGRES.DATA]
Checkpoint
[INGRES.CKP]
Journal
[INGRES.JNL]
Dump
[INGRES.DMP]
Work
[INGRES.WORK]
For example, using the default location for work files causes them to be stored in the ii_work:[INGRES.WORK] directory, where ii_work is the value displayed by the show logical command for the II_WORK environment variable.