10. Using Alternate Locations : 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 default locations are assumed unless you specify alternate locations.
The following table shows the default locations and the Vector 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
HDFS Data
ii_hdfsdata
II_HDFSDATA
HDFS Backup
ii_hdfsbackup
II_HDFSBACKUP
HDFS Work
ii_hdfswork
II_HDFSWORK
In each case, the Vector environment variable points to a specific disk volume or directory that has a particular structure, which is shown in the following table.
File Type
Structure on Linux
Structure on Windows
Data
ingres/data/default
ingres\data\default
Checkpoint
ingres/ckp/default
ingres\ckp\default
Journal
ingres/jnl/default
ingres\jnl\default
Dump
ingres/dmp/default
ingres\dmp\default
Work
ingres/work/default
ingres\work\default
HDFS
ingres/data/vectorwise
N/A
For example using the default location for work files causes them to be stored in the ii_work/ingres/work/default directory, where ii_work is the value for the II_WORK environment variable, which is displayed using the command:
ingprenv II_WORK