1.1

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);
WAN Configuration Procedures
WAN configuration procedures start and stop gateway senders.
SYS.START_GATEWAYSENDER
Start a configured gateway sender process.
Syntax
SYS.START_GATEWAYSENDER(
IN GATEWAYSENDER_ID VARCHAR(128) NOT NULL)
GATEWAYSENDER_ID
The name of the gateway sender to start. This attribute cannot be null.
Note: You must specify the gateway sender name in all uppercase letters. Use
single quotes to specify the sender name when you call the procedure from an
interactive sqlf session.
Example
This command starts all primary and secondary senders with the name cluster-1-sender:
sqlf> call sys.start_gatewaysender ('CLUSTER-1-SENDER');
This example executes the procedure from a Java client:
java.sql.Connection conn = getConnection();
CallableStatement cs = conn.prepareCall("CALL
SYS.START_GATEWAYSENDER(?)");
cs.setString(1, "cluster-1-sender");
cs.execute();
SYS.STOP_GATEWAYSENDER
Stop a configured gateway sender process.
Syntax
SYS.STOP_GATEWAYSENDER(
IN GATEWAYSENDER_ID VARCHAR(128) NOT NULL)
GATEWAYSENDER_ID
The name of the gateway sender to stop. This attribute cannot be null.
603
SQL Language Reference