Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

The SINGLEDEFS Parameter File

The use of a SINGLEDEFS parameter file is optional.

When a single-user mode connection is established, the SQLPOOL and bufferpool data areas are dynamically created.

The SQLPOOL area will grow dynamically if more space is needed, see SQLPOOL.

UNIX + VMS: To change the size of the bufferpool in single-user mode a SINGLEDEFS file, similar to the MULTIDEFS file, should be created in the database home directory.
A template of this file, showing the default values for the relevant parameters, can be found in the examples directory which is located in the Mimer SQL installation directory.

 --  Parameters for single-user system
 Databanks        100   -- (40-1000)     Max number of databanks
 Tables           4000  -- (500-1000000) Max number of tables
 ActTrans         50    -- (10-1000000)  Max number of transactions
 Pages4K          8000  -- (22-1000000)  Size of 4k bufferpool region (pages)
 Pages32K         800   -- (22-1000000)  Size of 32k bufferpool region (pages)
 Pages128K        96    -- (22-1000000)  Size of 128k bufferpool region (pages)
Note: When changing parameters in the SINGLEDEFS file, always change the copy in the database home directory. Never change the template file in the examples directory.

Win: The use of a SINGLEDEFS is not supported on the Windows platform.

Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL Documentation TOC PREV NEXT INDEX