Database Administrator's Guide

DAT_MEMORY <bytes>

The memory allocated to the data cache, specified in bytes. Within the memory constraints of the hardware, there is no effective limit.

Default: 100 MB

Note: Prior to V11, the default value for both the standard FairCom DB Server and the FairCom DB SQL Server was 600 * PAGE_SIZE. Assuming a default page size of 8192, the default DAT_MEMORY would be 4915200.

See Also

• BUFR_MEMORY
• IDX_MEMORY
• TOT_MEMORY (deprecated - do not use)
• USR_MEMORY

PAGE_SIZE <bytes>

The number of bytes per buffer page (maximum 65536 bytes). Only the following values are accepted (all other values generate an error):

• 1024
• 2048
• 4096
• 8192
• 16384
• 32768
• 65536

To encourage compatibility across different FairCom DB environments, we suggest not modifying the PAGE_SIZE. However, if performance is of concern, this value may be modified to suit the characteristics of the operating system. Generally, this is a matter to discuss with the application programmer.

Default: 32768 in V12 and later (before V12, the default was 8192)

Warning: Changing the PAGE_SIZE is a maintenance task that should be done carefully and with a full reliable backup. Practice on a copy of your data and server folder until you are confident with the results. For procedures, see Adjusting PAGE_SIZE in the FairCom Installation Guide.

Note: A file created with a larger PAGE_SIZE cannot be opened by a server with a smaller PAGE_SIZE.