1.0

on page 572. 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 on page 180 describes the
eviction process.
Syntax
SYS.SET_EVICTION_HEAP_PERCENTAGE (
IN PERCENTAGE REAL NOT NULL
}
PERCENTAGE
The percentage of used heap space that triggers eviction for all SQLFire data stores.
Example
This command triggers eviction on any SQLFire member when the member's heap reaches
90%:
call sys.set_eviction_heap_percentage (90);
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. You can optionally set
the global heap percentage for SQLFire data stores by using SYS.SET_EVICTION_HEAP_PERCENTAGE on
page 571. 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 on page 180 describes the
eviction process.
Syntax
SYS.SET_EVICTION_HEAP_PERCENTAGE_SG (
IN PERCENTAGE REAL NOT NULL
IN SERVER_GROUPS VARCHAR() NOT NULL
}
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.
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 (85, "overflows");
WAN Configuration Procedures
WAN configuration procedures start and stop gateway senders.
SYS.START_GATEWAYSENDER
Start a configured gateway sender process.
vFabric SQLFire User's Guide572
vFabric SQLFire Reference