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:
-
The number of the option to change. You will be prompted to enter a new value.
-
A
ora
to display the Advanced menu. -
P
orp
to display the Partition Database menu. -
B
orb
to create your database and return to the host command prompt. -
Q
orq
to exit without saving and return to the host command prompt.
Menu Options
The mkdbase main menu contains the following options:
1) Name The name of the database. Changing this option does the following:
-
Sets the name of the directory in which the database will be created (Folder option). This directory must not already exist.
-
Sets the database type (option 4) depending on the type of entry (if any) in the realfstab file.
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:
-
Partition Database Single File System
. Used if there is no entry in realfstab. -
Partition Database Multi File System
. Used if realfstab specifies a Multiple File Database. -
Partition Database Multi Partition
. Used if realfstab specifies a Multiple Partition Database.
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 |
DataCaseControl |
KeyCaseControl |
Case-insensitive |
Default |
|
---|---|---|---|---|---|---|---|
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
-
DataCaseControl and KeyCaseControl are database configuration parameters.
-
The default operating environment is applied to the SYSMAN account and any new accounts created on the database.
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 number of the option to change. You will be prompted to enter a new value.
-
R
orr
to save your changes and return to the main menu. -
Q
orq
to exit without saving and return to the host command prompt.
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 number of the option to change. You will be prompted to enter a new value.
-
R
orr
to save your changes and return to the main menu. -
Q
orq
to exit without saving and return to the host command prompt.
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.