ASYNCEVENTLISTENERS

Describes the configuration of AsyncEventListener implementations.

See CREATE ASYNCEVENTLISTENER for more information about individual columns.

Table 1. ASYNCEVENTLISTENERS system table
Column Name Type Length Nullable Contents
ID VARCHAR 128 No The unique identifier for the listener implementation.
LISTENER_CLASS VARCHAR 32672 No The fully qualified class name of the listener implementation.
SERVER_GROUPS VARCHAR 32672 No The server group(s) on which the listener is installed.
MANUAL_START BOOLEAN 1 No Specifies whether you need to manually start the listener with SYS.START_ASYNC_EVENT_LISTENER.
BATCH_CONFLATION BOOLEAN 1 No Indicates whether SQLFire should conflate messages for this listener.
BATCH_SIZE INTEGER 10 No The maximum number of messages that a batch can contain for this listener.
BATCH_TIME_INTERVAL INTEGER 10 No The maximum number of milliseconds that can elapse between sending batches to the listener.
IS_PERSISTENCE BOOLEAN 1 No Indicates whether SQLFire persists the listener event queue to disk for high availability.
DISK_STORE_NAME VARCHAR 32672 Yes The name of a disk store to use for persisting the listener event queue.
MAX_QUEUE_MEMORY INTEGER 10 No The maximum amount of memory in megabytes that the queue can consume before overflowing to disk.
ALERT_THRESHOLD INTEGER 10 No The maximum number of milliseconds that an event can remain in this queue before SQLFire logs an alert.
IS_STARTED BOOLEAN 1 No Indicates whether the listener is currently running. A 0 value indicates false, while a 1 value indicates true.