Specifies the maximum number of databank files that the database server can have open at any one time. Specifies the maximum number of tables that can be accessed simultaneously by the database server. Specifies the maximum number of transactions that can be active in the database server. Initial size of the SQLPool area in K bytes. This area contains information about each session, i.e. opened tables and databanks, compiled SQL programs, etc. The SQLPool area will expand automatically if it is too small, but it will not be larger than MaxSQLPool. The number of threads in the database server that can serve client requests. The number of background threads in the database server. The maximum number of users that are allowed to connect to the database server. This parameter should not exceed the number of users specified in the Mimer SQL license key.This number is also used to calculate the size of the shared memory region used for local database server communication. About 70 Kbytes of shared memory will be allocated for each user. A number which specifies whether a full check (1) or only an index page check (0) should be performed when a databank is opened which previously was not closed properly.A full databank check (involving index and data pages) provides for more secure operations, but may take much longer to execute than an index page check.When a full check is done, however, the data pages are checked in the background so there is a minimal negative effect on performance.Databank checks can be avoided by always shutting down the database server properly with the MIMCONTROL command, especially prior to shutting down the machine. The number of 2 Kbytes pages in the bufferpool area containing pages from the databank files. The default value of this parameter is 12.5% of the total RAM memory in the machine. The number of 16 Kbytes pages in the bufferpool area containing pages from the databank files. The default value of this parameter is 8.33% of the total RAM memory in the machine. The number of 64 Kbytes pages in the bufferpool area containing pages from the databank files. The default value of this parameter is 5% of the total RAM memory in the machine. This parameter gives a list of host system users, i.e. operators, that should receive e-mail notification of serious problems with the database server.This will enable that notification messages are sent to the central operator, i.e. processes that have set:
This parameter may specify an alternate path for the dump directories. The default is to create dump directories under the database home directory. Specifies how the database server should handle incoming TCP/IP connection requests. If this parameter is set to - (a single dash), the TCP/IP capability will be disabled for the database server.UNIX: On UNIX, the TCPPort parameter is, by default, set to inetd which means that the TCP/IP port server program, mimtcp, will be used for establishing a connection to any Mimer SQL version 8 database server. In this case clients may connect to the port to which mimtcp listens, usually 1360, and the handshake will be passed over to the requested Mimer SQL database server.
The maximum size (in kilobytes) of the SQLPool. The SQLPool memory area grows dynamically, but the size will never exceed this parameter. Use this parameter to control the maximum virtual size (maximum page file usage) for the database server process. A number which specifies whether the bufferpool and communication buffers should be locked in memory (1) or not locked in memory (0). UNIX: If the database server goes into an erroneous and unrecoverable state, it will produce dumps of the current internal database structures before it goes down. If this situation occurs, it is of great importance for the error detection process to get a UNIX kernel stack trace from the location where the error was located.
VMS: Specifies the DECNET network object that the database server listens to. Each database server must use a unique network object. The default value is the database name.
VMS: This parameter specifies the process name prefix for the database server. (The last part of the process name is always Srv).
VMS: This parameter specifies the number of users who can access the database through a network connection.
The value used by the system will be the minimum of this parameter and the Users parameter. The default value is 5000.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40