Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


The MULTIDEFS Parameter File


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

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 a VMS 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 8.2.2 parameters generated 2000-12-07 16:38
 Databanks          100                 # 40-1000     Max # of databanks
 Tables             4000                # 500-1000000 Max # of tables
 ActTrans           4000                # 500-1000000 Max # of active trans
 SQLPool            400                 # 10-2000000  Initial SQLPool size (kb)
 RequestThreads     8                   # 1-100       # of request threads
 BackgroundThreads  3                   # 1-100       # of background threads
 Users              10                  # 1-5000      Max # of logged in users
 DBCheck            1                   # 0-1         DB check (0=index, 1=full)
 Pages2K            5779                # 22-1000000  # of 2K bufferpool pages
 Pages16K           409                 # 22-1000000  # of 16K bufferpool pages
 Pages64K           91                  # 22-1000000  # of 64K bufferpool pages
 Oper                                   #             joe,joe@mimer.se,joe@upright.se
 DumpPath           .                   #             Path for dump directory
 TCPPort            inetd               #             TCP/IP port
 MaxSQLPool         30000               # 10-2000000  Max size of SQLPool (kb)
 MemLock            0                   # 0-1         Lock bpool in memory?
Example of MULTIDEFS File on VMS

 -- MIMER version 8.2.2 parameters generated 2000-12-07 16:38
 Databanks          100                 # 40-1000     Max # of databanks
 Tables             4000                # 500-1000000 Max # of tables
 ActTrans           4000                # 500-1000000 Max # of active trans
 SQLPool            400                 # 10-2000000  Initial SQLPool size (kb)
 RequestThreads     8                   # 1-100       # of request threads
 BackgroundThreads  3                   # 1-100       # of background threads
 Users              10                  # 1-5000      Max # of logged in users
 DBCheck            1                   # 0-1         DB check (0=index, 1=full)
 Pages2K            5779                # 22-1000000  # of 2K bufferpool pages
 Pages16K           409                 # 22-1000000  # of 16K bufferpool pages
 Pages64K           91                  # 22-1000000  # of 64K bufferpool pages
 Oper               OPER                #             Receivers for messages
 DumpPath           <>                  #             Path for dump directory
 TCPPort            1360                #             TCP/IP port
 MaxSQLPool         30000               # 10-2000000  Max size of SQLPool (kb)
 MemLock            0                   # 0-1         Lock bpool in memory?
 DECPort            example_database    #             Decnet network object
 ProcName           example_database    #             Process name prefix
 NetUsers           5000                # 1-5000      Max # of network users
 ServPrio           5                   # 0-16        VMS prio for server process
 Cleanup            60                  # 10-10000    Cleanup interval (seconds)
 


Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX