Creating a Database

The New Database option enables you to create a new database in the D3 environment on the network. Complete these instructions to create a new database.

To create a database:

  1. Select New Database from the File menu or right-click the Databases node from the Domain Explorer and select the New Database option.

    The New database dialog box displays.

  2. Specify the configuration for the new database as described below:

    Database Name

    Specifies he name for the new database.

    NOTE— The maximum database name length is 50 characters and it is case insensitive.

    Server

    Specifies the server that will store the database. Either type the server name or click the Env. button to select the server from a list of available servers.

    This server will hold the Master Dictionary and, optionally, tables in the account. Tables can then be created (See Creating a Table). If not specified, the database is created on the MDS server.

    The server name can be either the network name of the computer, an alias defined in the registry of this server, or a Server Environment Variable.

    NOTE— The D3 File System Interface service must be started on the specified server.

    Path

    (Optional) Specifies the path where the database supporting host files is created. Either type the path or click the Env. button to select the server from a list of available paths.

    NOTE— It is usually better to leave this field blank and let the system locate the file. The registry on the specified server contains the name of the root of the D3 file system, and all files are located relative to the path. If specified, the name is any valid host file directory. If it does not exist, it is created automatically.

    The path can be any valid host file system path, or a Path Environment Variable.

    Case Insensitive

    (Optional) Specifies that any Dictionary file name that is created in the database will be case insensitive.

    MD Modulo

    Specifies the modulo of the Master Dictionary. The default should be sufficient for most cases. If the account will contain many tables, the modulo should be increased. Any prime number (not a multiple of 2 or 5) can be selected.

  3. Click Create.

    The new database is created and displays under the Databases node in the Domain Explorer.

    NOTE

    To be able to use a database from the VME, it is easier to create remote Q-pointers to the FSI database. Such a Q-pointer is created in the MDS file of the VME, and is formatted as follows:

    mds database

    001 QS

    002 fsi:database

    With the Q-pointer created, users can now log to this account. Make sure the Master Dictionary has been updated (use the TCL command update-md database).

See Also

Databases

Deleting a Database

Renaming a Database

Creating and Editing Synonyms