1.1.1

cs.setString(1, "MyID");
cs.execute();
SYS.STOP_ASYNC_EVENT_LISTENER
Stop a running AsyncEventListener configuration. To ensure that no queued events are lost, use
SYS.WAIT_FOR_SENDER_QUEUE_FLUSH before stopping the listener.
Syntax
SYS.STOP_ASYNC_EVENT_LISTENER (IN ID VARCHAR(128) NOT NULL)
See also SYS.WAIT_FOR_SENDER_QUEUE_FLUSH on page 623.
This procedure stops dispatching events to the callback listener class, and invokes the close() method of the
implementation so that the event listener can perform any necessary cleanup.
ID
The unique identifier of the AsyncEventListener configuration that you want to stop.
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 618. 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 192 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);
617
SQL Language Reference