SQL Language Reference / Procedures |
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.
SYS.STOP_GATEWAYSENDER( IN GATEWAYSENDER_ID VARCHAR(128) NOT NULL)
See also SYS.WAIT_FOR_SENDER_QUEUE_FLUSH.
gfxd> 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();