Product Documentation

Configuring FairCom DBScaling Factors for Configuration Keyword Values

Database Administrator's Guide

Previous Topic

Next Topic

Scaling Factors for Configuration Keyword Values

The FairCom Server’s data and index cache configuration options support specifying a scaling factor used when interpreting cache memory sizes. The supported scaling factors are:

  • KB: interpret the specified value as a number of kilobytes.
  • MB: interpret the specified value as a number of megabytes.
  • GB: interpret the specified value as a number of gigabytes.

Example

DAT_MEMORY 100 MB

The following configuration keywords support scaling factors along with their limits.

Keyword

Limit

BUFR_MEMORY

1 GB

CHECKPOINT_INTERVAL

1 GB

CTSTATUS_SIZE

2 GB-1

DAT_MEMORY

2^32-1 cache pages on 64-bit systems and 4 GB-1 on 32-bit systems (although we allow up to 4 GB-1, the O/S might impose a lower limit; it will appear as c-tree error 10 when starting FairCom Server)

DISK_FULL_LIMIT

4 GB-1 for platforms without native 64-bit integer support; otherwise 2^63-1

DISK_FULL_VOLUME

4 GB-1 for platforms without native 64-bit integer support; otherwise 2^63-1

GUEST_MEMORY

2 GB-1

IDX_MEMORY

2^32-1 cache pages on 64-bit systems and 4 GB-1 on 32-bit systems (although we allow up to 4 GB-1, the O/S might impose a lower limit; it will appear as c-tree error 10 when starting FairCom Server)

LIST_MEMORY

1 MB

LMT_MEMORY

 

LOG_PAGE_SIZE

32 KB

LOG_SPACE

1 GB

MAX_USER_LOG_ENTRY_BYTES

 

MEMORY_FILE

2^63 - 1 bytes on 64-bit systems and 4 GB - 1 on 32-bit systems

MEMORY_MONITOR

 

MEMORY_TRACK

 

PAGE_SIZE

64 KB

PRIME_CACHE

2^63 - 1 bytes on 64-bit systems and 4 GB - 1 on 32-bit systems

PRIME_CACHE_BY_KEY

2^63 - 1 bytes on 64-bit systems and 4 GB - 1 on 32-bit systems

PRIME_INDEX

2^63 - 1 bytes on 64-bit systems and 4 GB - 1 on 32-bit systems

QUERY_MEMORY

 

SORT_MEMORY

4 TB - 1 for 64-bit FairCom DB;
4 GB - 1 for 32-bit FairCom DB

SPECIAL_CACHE_FILE

2^32-1 cache pages on 64-bit systems and 4 GB-1 on 32-bit systems

TOT_MEMORY (deprecated)

Note: TOT_MEMORY is a deprecated keyword. FairCom does not recommend setting a total memory limit.

USR_MEMORY

2 GB-1

The following keyword was not changed to support specifying a scaling factor:

XTDKSEG_SRC_SIZE

Note: An operating system might impose a lower limit on the amount of memory available to a process than the configuration option limits that the FairCom Server supports

TOCIndex