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.2.1 parameters generated 2003-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 9.2.1 parameters generated 2003-06-26 13:18
 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-2000000 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=full (0-1)
 Pages2K            22443               # # of 2K bufferpool pages (11-1000000)
 Pages16K           2086                # # of 16K bufferpool pages (11-1000000)
 Pages64K           289                 # # of 64K bufferpool pages (0-1000000)
 Oper               OPER                # Receivers for messages
 DumpPath           <>                  # Path for dump directory
 TCPPort            1360                # TCP/IP port
 MaxSQLPool         216000              # SQLPool max size (2400-2000000 kb)
 MemLock            0                   # Lock bpool in memory, 0=No 1=Yes (0-1)
 DECPort            MYDB                # Decnet network object
 ProcName           MYDB                # 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)

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se