Just like with data locations, a database may have more than one work location. If this is the case, Ingres , by default, uses all of them for each sort operation. Let us see how these locations work in practice. More than one location can point to the same directory. A location can be used for storing different types of files.
Databases can share locations.
Every Ingres installation has a master database called iidbdb . Ingres stores information about users, locations and user databases in this database. You have to set the locations for iidbdb during installation. These variables determine the default locations for every user database as well, if you do not override them when creating those databases. See Creating and Destroying Databases for more information.