1.1.1

cs.setString(1, "cluster-1-sender");
cs.execute();
SYS.STOP_GATEWAYSENDER
Stop a configured gateway sender process. To ensure that no queued events are lost, use
SYS.WAIT_FOR_SENDER_QUEUE_FLUSH before stopping the sender.
Syntax
SYS.STOP_GATEWAYSENDER(
IN GATEWAYSENDER_ID VARCHAR(128) NOT NULL)
See also SYS.WAIT_FOR_SENDER_QUEUE_FLUSH on page 623.
GATEWAYSENDER_ID
The name of the gateway sender to stop. 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 stops all primary and secondary senders with the name cluster-1-sender:
sqlf> call sys.stop_gatewaysender ('CLUSTER-1-SENDER');
This example executes the procedure from a Java client:
java.sql.Connection conn = getConnection();
CallableStatement cs = conn.prepareCall("CALL
SYS.STOP_GATEWAYSENDER(?)");
cs.setString(1, "cluster-1-sender");
cs.execute();
SYS.WAIT_FOR_SENDER_QUEUE_FLUSH
This procedure waits for the queue associated with a gateway sender or AsyncEventListener to empty all events
on all members that host the queue or listener (both primaries and secondaries). You can use this procedure
interactively or in SQL command scripts before stopping a gateway sender or AsyncEventListener, to ensure
that no queued events are lost.
Syntax
SYS.WAIT_FOR_SENDER_QUEUE_FLUSH(
IN ID VARCHAR(256),
IN IS_ASYNCLISTENER BOOLEAN,
IN MAX_WAIT_TIME INTEGER)
ID
The unique name of the gateway sender or AsyncEventListener. This corresponds to the ID
column value in ASYNCEVENTLISTENERS or the SENDER_ID column value in
GATEWAYSENDERS. This attribute cannot be null.
IS_ASYNCLISTENER
Specify "true" if the ID is an AsyncEventListener, or "false" if the ID is a gateway sender.
MAX_WAIT_TIME
623
SQL Language Reference