1.0

cs.setString(2, “table”);
cs.execute();
SYS.START_ASYNC_EVENT_LISTENER
Start an installed AsyncEventListener configuration.
Syntax
SYS.START_ASYNC_EVENT_LISTENER (
IN ID VARCHAR(128) NOT NULL
)
ID
The unique identifier of the AsyncEventListener configuration that you want to start.
Example
After executing this procedure, SQLFire assigns a thread to service the queue of the "MyID"
event listener, dispatching events to the callback class:
java.sql.Connection conn = getConnection();
CallableStatement cs = conn.prepareCall("call
SYS.START_ASYNC_EVENT_LISTENER( ? )");
cs.setString(1, "MyID");
cs.execute();
SYS.STOP_ASYNC_EVENT_LISTENER
Stop a running AsyncEventListener configuration.
Syntax
SYS.STOP_ASYNC_EVENT_LISTENER (IN ID VARCHAR(128) NOT NULL)
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 host to perform LRU eviction on tables
that are configured for eviction.
This procedure sets the heap percentage for all data stores in the SQLFire cluster. You can optionally set the
heap percentage for one or more named server groups using SYS.SET_EVICTION_HEAP_PERCENTAGE_SG
571
SQL Language Reference