Vector 6.0 | Create a Database in an Alternate Location

User Guide > User Guide > Using Alternate Locations > Create a Database in an Alternate Location

Was this helpful?

Create a Database in an Alternate Location

You can create a database in a location other than II_DATABASE by using the ‑d flag on the createdb command. This location becomes the new default location for this database.

To create a database in a location other than the default

1. Create the location. For example:

CREATE LOCATION db_vw WITH AREA = '\disk2\vw_extra', USAGE = DATABASE;

2. Issue a createdb command. For example:

createdb inventory -ddb_vw

In this example, the inventory database is created in a new default location db_vw. The location was defined previously with CREATE LOCATION statement. The checkpoint files for the database are created in II_CHECKPOINT because no checkpoint location was specified.

Last modified date: 11/09/2022