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.

Linux: On a Linux 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 Linux
 -- MIMER version 11.0.2A Beta Test parameters generated 2018-09-14 09:37
 Databanks          100                 # Max # of databanks (20-1000)
 Tables             4000                # Max # of tables (500-1000000)
 ActTrans           20000               # 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)
 Pages4K            209261              # # of 4K bufferpool pages (11-33554432)
 Pages32K           18995               # # of 32K bufferpool pages (7-4194304)
 Pages128K          2206                # # of 128K bufferpool pages (0-1048576)
 DelayedCommit      0                   # Delayed commit off/on/disabled (0-2)
 DelayedCommitTimeout 100               # Delayed commit timeout in milliseconds
                                          (0-60000)
 Oper                                   # Receivers for messages
 DumpPath           .                   # Path for dump directory
 TCPPort            inetd               # 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)
 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 11.0.1A Beta Test parameters generated 2018-01-25 15:12
 Databanks          100                 # Max # of databanks (20-1000)
 Tables             4000                # Max # of tables (500-1000000)
 ActTrans           20000               # 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)
 Pages4K            46625               # # of 4K bufferpool pages (11-8000000)
 Pages32K           4274                # # of 32K bufferpool pages (7-1000000)
 Pages128K          537                 # # of 128K bufferpool pages (0-260000)
 DelayedCommit      0                   # Delayed commit off/on/disabled (0-2)
 DelayedCommitTimeout 100               # Delayed commit timeout in milliseconds
                                          (0-60000)
 EnablePasswords    1                   # Enable password login off/on (0-1)
 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)
 Encrypt            0                   # Encryption enabled, 0=No 1=Yes (0-1)
 EncryptKey                             #
 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
 Multithread        0                   # Kernel thread limit (0-64)

Mimer
Mimer Information Technology AB
Phone: +46 18 780 92 00
info@mimer.com
Mimer SQL Documentation TOC PREV NEXT INDEX