Database Administrator's Guide

SUBSYSTEM SQL LATTE

Marks a section in the server configuration file ctsrvr.cfg to configure the LATTE sorting subsystem for FairCom DB SQL.

Configuration options are available in the server configuration file ctsrvr.cfg to configure the LATTE sorting subsystem for FairCom DB SQL. This subsystem is indicated as: SUBSYSTEM SQL LATTE. Keywords that affect this subsystem must be enclosed in curly braces as shown in the example below:

SUBSYSTEM SQL LATTE

{

SQL LATTE KEYWORD

}

This subsystem accepts the following keywords:

MAX_MEMORY - Maximum advisable memory per environment. Default: 64M
CACHE_BLK - Default number of blocks in the temporary cache of a table. Default: 8
MAX_STORE - The maximum number of swap files (128M each) LATTE can create. This setting can be 65535 at max. Default: 128
NONE - This option is used in conjunction with the tamper-proof settings file (.set). When specified, the entire SUBSYSTEM SQL LATTE cannot be overridden in the ctsrvr.cfg file.

Example

Notice that any keywords listed above must be in a section of the configuration file labeled SUBSYSTEM SQL LATTE and enclosed in curly braces. For example, include the following to set the maximum advisable memory per environment to 64MB:

SUBSYSTEM SQL LATTE

{

MAX_MEMORY 64M

}