mkdbase Menu Interface

The mkdbase menu interface, also known as interactive mode, is available only when creating a new database.

If run without any command line parameters or options, mkdbase prompts for the database name:

Database name:

When you respond to this prompt with a name (provided that the name is unknown) a menu similar to the following is displayed:

             mkdbase main menu
             ~~~~~~~~~~~~~~~~~
 1)               Name: mydb
 2)             Folder: mydb
 3)          Create in: C:/Cora/Dbase
 4)               Type: Partition Database Single File System
 5)               Size: 20000 frames
 6)             Unlock: No
 7)          Emulation: Reality
------------------------------------------
 8)          Hash Type: Hash-11 (Long IID)
 9)         Frame size: 1 KB
10) IID Case sensitive: Yes
Sub menus
 A) Advanced    P) Partition Database
Enter number to change or A/P or B - build, Q - quit:

At the prompt, enter one of the following:

Menu Options

The mkdbase main menu contains the following options:

1) Name The name of the database. Changing this option does the following:

2) Folder Sets the name of the directory in which the database will be created. This directory must not already exist. You can change this parameter to use a directory with a name different to that of the database.

Note that if you specified a path on the command line, this is the final element of this path.

3) Create in The path of the directory in which to create the database directory. The default is the directory from which you ran mkdbase (unless specified on the command line). This directory must exist.

4) Type One of the following, depending on the type of entry (if any) in the realfstab file:

If you attempt to change this option, a message about the realfstab file is displayed.

5) Size The size of the database (20000 frames minimum). Use the appropriate suffix to specify terabytes (T), gigabytes (G), megabytes (M) or frames (F). When you press RETURN, details of the number of frames and files, and their size is displayed.

If the database is specified in realfstab, this option cannot be changed.

6) Unlock Whether to unlock the new database; enter Y or N.

7) Emulation This option sets various options so that the database will be compatible with a particular type of MultiValue system. The following settings are available:

Setting

Hash type

Frame size

IID Case sensitive

DataCaseControl

KeyCaseControl

Case-insensitive
SYSTEM file

Default
operating
environment

Reality

Hash-11

1

Yes

0

0

0

REALITY

Reality Hash-10

Hash-10

1

Yes

0

0

0

REALITY

D3

Hash-10

4

No

1

1

1

D3

mvEnterprise

Hash-10

4

Yes

0

0

0

mvEnterprise

mvBase

Hash-10

2

Yes

0

0

0

mvBase

UniVerse

Hash-10

4

Yes

0

0

0

UniVerse

Note

8) Hash Type Sets the hash type for the database. Enter one of the following:

1 Hash-10 - compatible with most other MultiValue databases.

2 Hash-11 - the current Reality hashing algorithm.

9) Frame size The required size in kilobytes of the frames used within the database. Enter 1, 2, 4 or 8.

Note

  • It is recommended that, when migrating from another MultiValue system, you should, if possible, keep the same frame size as on the original database.

  • You can optimise your frame size by using the procedure described in File Structure.

  • If increasing the frame size would result in a database with fewer than 20000 frames, an error message is displayed. Set the size of the database (option 5) to an appropriate value before changing the frame size.

10) IID Case sensitive
Whether the database will support case-sensitivity as regards item-ids.

Advanced Menu

If you enter A at the main mkdbase menu, the following menu is displayed:

             Advanced sub menu
             ~~~~~~~~~~~~~~~~~
 1)           SYSTEM file modulo: 23
 2) Case insensitive SYSTEM file: No
               Owner only access: N/A
 4)                 Verbose mode: No
 5)            Run SYS-LOAD PROC: Yes

Enter number to change or R - return, Q - quit [R]:

At the prompt, enter one of the following:

The Advanced menu contains the following options:

1) SYSTEM file modulo
Sets the modulo (number of groups) of the SYSTEM file (default 11). If your database will have a large number of accounts, you may need to increase this value.

2) Case insensitive SYSTEM file
Enter Y to make the SYSTEM file case-insensitive as regards item-ids; otherwise enter N. Selecting this option makes account names case-insensitive.

3) Owner only access
Enter Y to prevent other UNIX users accessing the database; otherwise enter N. Not available on Windows.

4) Verbose mode Enter Y to create the database in verbose mode; otherwise enter N.

5) Run SYS-LOAD PROC
Enter N to prevent the SYS-LOAD Proc being run on the new database (this can speed up database creation); otherwise enter Y. Do not use except under the guidance of NEC Software Solutions.

Partition Database Menu

If you enter P at the main mkdbase menu, the following menu is displayed:

             Partition Database sub menu
             ~~~~~~~~~~~~~~~~~~~~~~~~~~~
 1)            Stripe size: 16 frames
 2)              Num Files: 10
 3)  Free space table size: 167 frames
 4)  Initialise free space: No
                 realfstab: /etc/realfstab
Enter number to change or R - return, Q - quit [R]:

At the prompt, enter one of the following:

The Advanced menu contains the following options:

1) Stripe size The stripe size in frames (default, 16). To turn striping off, set this parameter to 0. Striping is not available if the database type is Partition Database Single File System (the host filing system/storage hardware performs any striping required).

Caution

Do not use striping on both Reality and the host.

2) Num Files The number of host files making up the database. Only available if the database type is Partition Database Single File System.

3) Free space table size
The size of the free space table (default, 167). Do not change except under the guidance of NEC Software Solutions.

4) Initialise free space
Enter Y to initialise the free space table; otherwise enter N. Do not use except under the guidance of NEC Software Solutions.

realfstab Displays the path of the realfstab file. This cannot be changed.

See Also

mkdbase Command Line Interface, Using mkdbase, realfstab file.