Environment Variables

www.mimer.com/developer

Environment Variables

The following table lists and explains the environment variables Mimer SQL uses in UNIX.
Variable

Explanation
 MIMER_DATABASE
Used to point out which database to access. If not set, the default database, set in /etc/sqlhosts, is used.
 MIMER_EXTEND
Used to change the number of pages to allocate when dynamically extending a databank file.

If not set, the default is 128 pages (each of 2048 bytes). The variable must be set for the process starting the dbserver program.
 MIMER_HISTLINES
Used to change the number of command lines to be stored in the recorded history for a BSQL session.

If not set, the default is 23.
 MIMER_HOME
Used on HP-UX when dynamically loading the Mimer single-user shared library.
 MIMER_KEYFILE
If set, the given string is treated as the name of the license key file (overriding the /etc/mimerkey file).
 MIMER_MAXASYNC
Used to change the number of asynchronous I/Os allowed to be operating at the same time.

If not set, the default is 40. The maximum limit is 128.

This variable must be set for the process starting the dbserver program.

Note: Does not apply to Linux.
 MIMER_MODE
Used to indicate the mode for which the database should be accessed, that is, 'SINGLE' or 'MULTI'.

Use single mode if accessing a database for which the dbserver program is not started. If not set, 'MULTI' is assumed.
 MIMER_NOEDIT
If set, the command line editing package for a BSQL session is disabled.
 MIMER_ODBCINI
If set, the given string is treated as the name of the file for ODBC Data Source lookup.

If not set, and if ODBCINI is not set, the home directory is searched for the .odbc.ini file (using the HOME environment variable).
 MIMER_PATH
Used when searching for sequential files, that is, ordinary text files (not databank files).
Variable

Explanation
 HOME
Used to locate the home directory from within various Mimer programs.
 LD_LIBRARY_PATH
Used on most platforms to locate shared libraries in runtime.
 LIBPATH
Used on AIX to locate shared libraries.
 ODBCINI 
Same as MIMER_ODBCINI.

Overrides MIMER_ODBCINI if set.
 PATH
Used to locate Mimer executables.
 SHELL
Used shell when temporarily entering the operating system shell prompt from within Mimer.

If not set, /bin/sh is used.
 SHLIB_PATH
Used on HP-UX to locate shared libraries.

Variable	Explanation
MIMER_DATABASE	Used to point out which database to access. If not set, the default database, set in /etc/sqlhosts, is used.
MIMER_EXTEND	Used to change the number of pages to allocate when dynamically extending a databank file. If not set, the default is 128 pages (each of 2048 bytes). The variable must be set for the process starting the dbserver program.
MIMER_HISTLINES	Used to change the number of command lines to be stored in the recorded history for a BSQL session. If not set, the default is 23.
MIMER_HOME	Used on HP-UX when dynamically loading the Mimer single-user shared library.
MIMER_KEYFILE	If set, the given string is treated as the name of the license key file (overriding the /etc/mimerkey file).
MIMER_MAXASYNC	Used to change the number of asynchronous I/Os allowed to be operating at the same time. If not set, the default is 40. The maximum limit is 128. This variable must be set for the process starting the dbserver program. Note: Does not apply to Linux.
MIMER_MODE	Used to indicate the mode for which the database should be accessed, that is, 'SINGLE' or 'MULTI'. Use single mode if accessing a database for which the dbserver program is not started. If not set, 'MULTI' is assumed.
MIMER_NOEDIT	If set, the command line editing package for a BSQL session is disabled.
MIMER_ODBCINI	If set, the given string is treated as the name of the file for ODBC Data Source lookup. If not set, and if ODBCINI is not set, the home directory is searched for the .odbc.ini file (using the HOME environment variable).
MIMER_PATH	Used when searching for sequential files, that is, ordinary text files (not databank files).

Variable	Explanation
HOME	Used to locate the home directory from within various Mimer programs.
LD_LIBRARY_PATH	Used on most platforms to locate shared libraries in runtime.
LIBPATH	Used on AIX to locate shared libraries.
ODBCINI	Same as MIMER_ODBCINI. Overrides MIMER_ODBCINI if set.
PATH	Used to locate Mimer executables.
SHELL	Used shell when temporarily entering the operating system shell prompt from within Mimer. If not set, /bin/sh is used.
SHLIB_PATH	Used on HP-UX to locate shared libraries.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se