Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


The MULTIDEFS Parameter File


Comments in MULTIDEFS are introduced by the character sequence --, or by the character ! or #.

A new MULTIDEFS file can be generated by using the command:

 mimcontrol -g
 

If the MULTIDEFS file is not found when starting a database server, the MIMCONTROL command will create a new file and fill it with the default values for all parameters.

UNIX: On a UNIX node, the MULTIDEFS file is located in the database home directory and is called multidefs.

VMS: On an OpenVMS node, the MULTIDEFS file is located in the database home directory and is called MULTIDEFS.DAT.

The actual default values used may vary and may depend on factors like machine type and the amount of physical memory available on the machine.

The following is an example of the MULTIDEFS parameter file which may be generated by MIMCONTROL:

Example of MULTIDEFS File on UNIX
 
 -- MIMER version 9.3.3 parameters generated 2006-06-06 15:08
 Databanks          100                 # Max # of databanks (20-1000)
 Tables             4000                # Max # of tables (500-1000000)
 ActTrans           30000               # Max # of active trans (500-1000000)
 SQLPool            1000                # Initial SQLPool (400-2000000 kb)
 RequestThreads     8                   # # of request threads (1-100)
 BackgroundThreads  3                   # # of background threads (1-100)
 IOThreads          2                   # # of I/O threads (1-64)
 Users              100                 # Max # of logged in users (1-5000)
 DBCheck            1                   # DB check, 0=index, 1=full (0-1)
 Pages2K            8406                # # of 2K bufferpool pages (11-1000000)
 Pages16K           815                 # # of 16K bufferpool pages (11-1000000)
 Pages64K           145                 # # of 64K bufferpool pages (0-1000000)
 Oper                                   # Receivers for messages
 DumpPath           .                   # Path for dump directory
 TCPPort            inetd               # TCP/IP port
 MaxSQLPool         216000              # SQLPool max size (2400-2000000 kb)
 MemLock            0                   # Lock bpool in memory, 0=No 1=Yes (0-1)
 BackgroundPriority 0                   # Thread priority, 0=Off, 1=On (0-1)
 AutoStart          1                   # Autostart, 0=No, 1=Yes (0-1)
 DumpScript         ./.dumper.sh %p     # Dump Script
Example of MULTIDEFS File on OpenVMS
 
 -- MIMER version 10.0.1B parameters generated 2008-02-27 15:40
 Databanks          100                 # Max # of databanks (20-1000)
 Tables             4000                # Max # of tables (500-1000000)
 ActTrans           4000                # Max # of active trans (500-1000000)
 SQLPool            1000                # Initial SQLPool (400-8388607 kb)
 RequestThreads     8                   # # of request threads (1-100)
 BackgroundThreads  3                   # # of background threads (1-100)
 Users              100                 # Max # of logged in users (1-5000)
 DBCheck            1                   # DB check, 0=index, 1=all, 2=immediate, 
3=im. index, 4=im. all (0-4)
 Pages2K            46625               # # of 2K bufferpool pages (11-8000000)
 Pages16K           4274                # # of 16K bufferpool pages (7-1000000)
 Pages64K           537                 # # of 64K bufferpool pages (0-260000)
 Oper               OPER                # Receivers for messages
 DumpPath           <>                  # Path for dump directory
 TCPPort            1360                # TCP/IP port
 MaxSQLPool         216000              # SQLPool max size (2400-16777215 kb)
 MemLock            0                   # Lock bpool in memory, 0=No 1=Yes (0-1)
 MiniDump           1                   # Small bufferpool dump (no page content), 
0=No 1=Yes (0-1)
 DECPort            MULTI               # Decnet network object
 ProcName           MULTI               # Process name prefix
 NetUsers           5000                # Max # of network users (1-5000)
 ServPrio           5                   # VMS prio for server process (0-16)
 Cleanup            60                  # Cleanup interval (10-10000 seconds)
 BPResident                             # Bufferpool resident area name
 

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