DBOPEN - Databank Open functionality

When DBOPEN is run in multi-user mode, the index pages of the databank are checked before databank access can proceed, but the bulk of the databank contents (contained in the data pages) is checked in the background, thus minimizing the delay.

Background Threads

The checking performed by DBOPEN is done by the background threads, see Number of Background Threads. Therefore, increasing the number of background threads will increase the efficiency of the checking.

The DBOPEN functionality should normally be run as soon as the database server has been started.

Syntax

Command-line Arguments


UNIX-style	VMS-style	Function
-m --multi	/MULTI	Connects to the database in multi-user mode.
-s --single	/SINGLE	Connects to the database in single-user mode.
-u username --username=username	/USERNAME=username	Specifies the username used when connecting to Mimer. To connect as OS_USER, give `-u ""`, `--username=""`, or `/USERNAME=""`.
-p password --password=password	/PASSWORD=password	Specifies the password used in connecting to Mimer. If the switch is omitted the user is prompted for a password, unless OS_USER is specified with the username switch, as described above. VMS: Note that in a Open VMS environment it might be necessary to enclose the password in quotation marks as the value otherwise is translated to upper case.
database	database	Specifies the name of the database to access.
-? --help	/HELP	Show help text.

If the optional database name is not specified, the default database will be accessed, see The Default Database.

If the username or password arguments are omitted, the program will prompt for these values.

If neither -s nor -m is specified for the optional mode flag, the way the database is accessed will be determined by the setting of the MIMER_MODE variable, see Specifying Single-user Mode Access, or, if this is not set, it will be accessed in multi-user mode.

UNIX: The UNIX-style command-line flags must be used on a UNIX machine.

VMS: Either the UNIX-style or the VMS-style command-line flags may be used on an OpenVMS machine - see the Mimer SQL VMS Guide for more details.

Win: The UNIX-style command-line flags can be used from a Command Prompt window.

Exit Codes

The DBOPEN program returns an error status to the operating system when an error is encountered. This may be useful when running it from scripts or in batch mode.