Mimer Packaging Parameters
This chapter explains the Mimer SQL specific parameters and commands, used in SQLConfigDataSource.
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:
- Data source parameters, see Data Source Parameters.
- Local database parameters, see Local Database Parameters.
- Local database server commands, see Local Database Server Commands.
- Remote database parameters, see Remote Database Parameters.
- License key parameters, see License Key Parameters.
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
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
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-timeFurther 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 = TimeCriticalFurther 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
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
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
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
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.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40