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.

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 gfxd session.

Example

This command stops all primary and secondary senders with the name cluster-1-sender:
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();