SYS.SET_EVICTION_HEAP_PERCENTAGE_SG

Sets the percentage of heap space that triggers members of one or more SQLFire server groups to perform LRU eviction on tables that are configured for eviction.

This procedure sets the heap percentage for all members of one or more server groups, or for all data stores in the SQLFire cluster. You can optionally set the global heap percentage only for the local SQLFire data store by using SYS.SET_EVICTION_HEAP_PERCENTAGE. When the used heap reaches the percentage, SQLFire begins to evict rows, using a LRU algorithm, from tables that are configured for eviction. Create a Table with Eviction Settings describes the eviction process.

Syntax

SYS.SET_EVICTION_HEAP_PERCENTAGE_SG (
IN PERCENTAGE REAL NOT NULL
IN SERVER_GROUPS VARCHAR(32762)
}
PERCENTAGE
The percentage of used heap space that triggers eviction for data stores in the specified server group(s).
SERVER_GROUPS
A comma-separated list of server groups on which to apply the heap percentage setting. If you specify NULL, the command is distributed to all data stores (irrespective of defined server groups).

Example

This command triggers eviction on any member of the "overflows" server group when that member's heap reaches 85%:
call sys.set_eviction_heap_percentage_sg (85, 'overflows');
This command triggers eviction on all SQLFire data stores when that member's heap reaches 85%:
call sys.set_eviction_heap_percentage_sg (85, null);