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 10.1.0A parameters generated 2012-03-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=all, 2=immediate,
                                        # 3=im. index, 4=im. all (0-4)
 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)
 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
 ServerType         3                   # Server type, 0=mimengine, 3=mimexper (0,3)

Example of MULTIDEFS File on OpenVMS

 
 -- MIMER version 10.1.0A parameters generated 2012-09-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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se