1.1

Example
This procedure stops the event listener configuration, "MyID:"
java.sql.Connection conn = getConnection();
CallableStatement cs = conn.prepareCall("call
SYS.STOP_ASYNC_EVENT_LISTENER( ? )");
cs.setString(1, "MyID");
cs.execute();
Heap Eviction Configuration Procedures
Procedures to set the percentage that triggers table eviction.
SYS.SET_EVICTION_HEAP_PERCENTAGE
Sets the default percentage of heap space that triggers a SQLFire data store to perform LRU eviction on tables
that are configured for eviction. This procedure executes only on the local SQLFire data store member
This procedure sets the heap percentage for the local SQLFire data store. You can optionally set the heap
percentage for one or more named server groups, or for all data stores, using
SYS.SET_EVICTION_HEAP_PERCENTAGE_SG on page 602. 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 188 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 local 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, 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 on page 602. 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 188 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).
vFabric SQLFire User's Guide602
vFabric SQLFire Reference