Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


DBOPEN - Databank Open functionality


Multi-user Mode

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

The overall syntax for DBOPEN is:

 dbopen [-s | -m] [-u[username]] [-p[password]] [database]

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 using OS_USER login, 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.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX