Mimer SQL Documentation PREV NEXT

Mimer Developer Site

www.mimer.com/developer


5.1 Mimer SQL Specific Parameters and Commands


To set up and configure a Mimer SQL database, the parameters and commands below may be specified in a call to SQLConfigDataSource. If a parameter is not specified, the system uses an appropriate default.

You can find additional information about these parameters and commands through the help facility in the Mimer Administrator. Many of the parameters are also described in the Mimer SQL System Management Handbook.

The parameters and commands are divided into the following groups:

To create both a data source and a remote definition, you specify parameters from the two groups together. It is not possible to combine remote parameters with local parameters or commands.

5.1.1 Data Source Parameters

Data Source Parameter
Explanation
DSN
The ODBC data source name (required). It is recommended to use the same name as for the database
Description
A text describing the data source.
Database
The name of the Mimer SQL database (required).

5.1.2 Local Database Parameters

Local Database Parameter
Explanation
Database
The name of the Mimer SQL database (required).
Description
A text describing the database.
Directory
The database home directory (required).
Users
Maximum number of simultaneous connections allowed to the database server (recommended).
DBCheck
The type of check performed after an improper shutdown of the system. All Pages is strongly recommended. Data pages are checked in the background.
0 = Index Only
1 = All Pages
PriorityClass
The priority class of the server. Should be an integer in the range 0-3.
0 = Idle
1 = Normal
2 = High
3 = Real-time
Further information about priorities may be found in the Win32 documentation for the routine SetPriorityClass.
RequestThreads
An integer specifying the number of request threads in the database server. Each request thread can handle one concurrent application request.

If there are many long requests this parameter may have to be increased form the default.

RequestPriority
The priority class of the kernel threads. Should be an integer in the range 0-6.
0 = Idle
1 = Lowest
2 = BelowNormal
3 = Normal
4 = AboveNormal
5 = Highest
6 = TimeCritical
Further information about priorities may be found in the Win32 documentation for the routine SetThreadPriority.
BackgroundThreads
An integer specifying the number of background threads.

If there are many large transactions and/or shadowing is used, the number of threads may need to be increased.

Actually, it is more important to give the background threads sufficient priority rather than increase the number of threads.

The number of background threads determine how many databases are checked in parallel. Half of the threads are used for this.

BackgroundPriority
The priority class of the background threads. Should be an integer in the range 0-6. See RequestPriority for the specific values. It is recommended that this parameter is equal to or one higher than the value for RequestPriority.
StartupType
An integer value which is specified if the server is to be disabled, started manually or started automatically after a system reboot.
0 = Autostart
1 = Manual start
2 = Disabled

On Windows 98/ME, Autostart means that the database is started whenever accessed by an application.

AutoRestart
An integer value which is specified if the server is to be started manually or started automatically after a failure.
0 = Manual restart
1 = Automatic restart
Pages2K
An integer specifying the number of 2K pages in the bufferpool.
Pages16K
An integer specifying the number of 16K pages in the bufferpool.
Pages64K
An integer specifying the number of 64K pages in the bufferpool.
SQLPool
The initial size of the SQL-pool in bytes. The SQL-pool contains information about users logged in, compiled SQL statements and so on.
MaxSQLPool
If you want to limit the amount of memory the database server allocates, this parameter specifies the maximum number of bytes that the server allocates for the SQL-pool.
ActTrans
Maximum number of transactions that can be active in the database server including background threads processing.
Databanks
Maximum number of allowed databanks.
Tables
Maximum number of open tables allowed.
CommBuffSize
This is the size of local communication buffers (specified in bytes). If communication packages exceed this size, several calls are made to the database server. This may increase overhead.
The default size is 64K. Any buffer size specified is rounded up to the nearest 64K boundary.
TcpPort
This can be either a port number, such as 1360 or one of the strings <Name Server> or <Disabled>.
If <Name Server> is used, incoming TCP connections are handled by a separate TCP server process and then handed over to the correct database server.
NamedPipe
This is the name of the named pipe the database server uses to listen for incoming requests. The default is a named pipe with the same name as the database server.
As for TcpPort the strings <Name Server> or <Disabled> may also be used.
RmGuid
This is a unique identifier identifying the database server used for inter-operating with Microsoft Distributed Transaction Coordinator.
Do not specify RmGuid unless you are renaming a database server, in which case the original RmGuid should be kept.
DumpPath
This is a path to the directory under which database server dump directories and files will be placed. Typically these are placed below the database home directory.

5.1.3 Local Database Server Commands

Local Database Server Command
Explanation
Database
The name of the Mimer SQL database (required).
SDBGEN
The parameters to the command correspond to the command line arguments specified when using the system databank generation utility (SDBGEN).
This is further described in Defining a Database.
Upgrade
The parameters to the command is the SYSADM password and the name of the Mimer SQL database.
This is further described in Upgrading a Mimer SQL Installation.
DbServer
The DbServer command accepts the following strings: START, STOP, ENABLE and DISABLE.

5.1.4 Remote Database Parameters

Remote Database Parameter
Explanation
Database
The name of the Mimer SQL database on the remote host (required).
Description
A text describing the database.
Node
The name of the computer where the database is running. If this keyword is present, the definition for a remote Mimer SQL database is created (required).
Protocol
Specifies whether to use named pipes or TCP/IP. Should either be the string 'NamedPipes' or 'tcp'. 'tcp' is the default.
Service
The IP port number of the server for TCP/IP. The default is 1360.
For named pipes, this is the name of the pipe that the database server is waiting for incoming connections on.
The default for version 8 and version 9 servers is to listen on a pipe with the same name as the database. In previous versions, the default was MIMER. This means that you must know if the server is a version 7 or version 8 or 9 database server. The default for version 8 and 9 clients is to use the database name.
Interface
Not used on the Windows platform.

5.1.5 License Key Parameters

License Key Parameter
Explanation
LicenseKey
A string specifying a Mimer SQL license key.
InstallationNo
An integer specifying the installation number associated with a Mimer SQL license key.
The installation number is specified when adding or removing a license key.
Description
A text describing the license key.


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