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.

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.

For example, on Windows, 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 this command: