SQL Language Reference / Procedures |
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. GemFire XD automatically calls this procedure before performing an ALTER TABLE statement on a table that is configured with event queues.
SYS.WAIT_FOR_SENDER_QUEUE_FLUSH( IN ID VARCHAR(256), IN IS_ASYNCLISTENER BOOLEAN, IN MAX_WAIT_TIME INTEGER )
gfxd> call sys.wait_for_sender_queue_flush ('CLUSTER-1-SENDER', 'false', 0);