Create an Area in Windows
An area must be created before you can define an alternate location for a new database.
Note: If you use the extenddb command with the –aarea_dir flag, the area is created for you. You do not have to create the directory path below the ingres root directory.
To create an area in Windows, follow these steps:
1. Change location to the drive and directory where you create the new directory structure. For example, to create the new directory structure on the D: drive under the \otherplace directory, issue the following commands at the command prompt:
D:
cd \otherplace
2. Create a new subdirectory. For example, to make a subdirectory named new_area, issue the following command at the command prompt:
mkdir new_area
3. Create subdirectories for the types of database files that use the new area. For example, to create a subdirectory for data files in new_area, issue these commands at the command prompt:
mkdir new_area\ingres
mkdir new_area\ingres\data
mkdir new_area\ingres\data\default
To make subdirectories for checkpoint, journal, dump, or work files, substitute ckp, jnl, dmp, or work for data when issuing these commands.
In these steps, you created the area D:\otherplace\new_area, which you can now specify as the Area when defining a new location using the CREATE LOCATION operation. The subdirectories you created in Step 3 determine which Usage Types you can use in CREATE LOCATION and ALTER LOCATION statements (or equivalent dialogs in Director or VDBA). For example, creating ingres\data\default allows you to enable Database as a Usage Type, and creating ingres\work\default allows you to enable Work as a Usage Type.