c-treeACE V11.0 Update Guide

Configuration Options for c-treeACE SQL LATTE Subsystem

Configuration options are available in the server configuration file ctsrvr.cfg to configure the LATTE sorting subsystem for c-treeACE 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

}