Procedures

GemFire XD provides built-in system procedures to help you manage the distributed system. For example, you can use system procedures to export or import data, install required JAR files, and install listener implementations.

Note: If you enable SQL authorization, you must use the GRANT command to grant normal users permission to use these procedures.

GemFire XD procedures are available for the following categories of distributed system operations:

Table 1. GemFire XD built-in procedures
Category	Procedures
Callback configuration	ADD_LISTENER ATTACH_LOADER ATTACH_WRITER REMOVE_LISTENER REMOVE_LOADER REMOVE_WRITER START_ASYNC_EVENT_LISTENER STOP_ASYNC_EVENT_LISTENER WAIT_FOR_SENDER_QUEUE_FLUSH
Data export and import	EXPORT_QUERY EXPORT_TABLE IMPORT_DATA IMPORT_DATA_EX IMPORT_DATA_LOBS_FROM_EXTFILE IMPORT_TABLE IMPORT_TABLE_EX IMPORT_TABLE_LOBS_FROM_EXTFILE
Disk store and HDFS store management	DISKSTORE_FSYNC HDFS_FLUSH_QUEUE SYS.HDFS_FORCE_COMPACTION
Heap and off-heap configuration	SET_CRITICIAL_HEAP_PERCENTAGE SET_CRITICIAL_HEAP_PERCENTAGE_SG SET_CRITICIAL_OFFHEAP_PERCENTAGE SET_CRITICIAL_OFFHEAP_PERCENTAGE_SG SET_EVICTION_HEAP_PERCENTAGE SET_EVICTION_HEAP_PERCENTAGE_SG SET_EVICTION_OFFHEAP_PERCENTAGE SET_EVICTION_OFFHEAP_PERCENTAGE_SG See also the functions: GET_CRITICIAL_HEAP_PERCENTAGE GET_CRITICIAL_OFFHEAP_PERCENTAGE GET_EVICTION_HEAP_PERCENTAGE GET_EVICTION_OFFHEAP_PERCENTAGE
JAR installation and management	INSTALL_JAR REMOVE_JAR REPLACE_JAR
Partitioned table bucket management	CREATE_ALL_BUCKETS REBALANCE_ALL_BUCKETS
Statement and statistics management	CANCEL_STATEMENT EMPTY_STATEMENT_CACHE SET_EXPLAIN_CONNECTION SET_STATISTICS_TIMING SET_GLOBAL_STATEMENT_STATISTICS SET_QUERYSTATS
Troubleshooting	DUMP_STACKS SET_TRACE_FLAG
User credentials	CHANGE_PASSWORD CREATE_USER SHOW_USERS
WAN configuration	ATTACH_GATEWAY_EVENT_ERROR_HANDLER INCREMENT_TABLE_VERSION REMOVE_GATEWAY_EVENT_ERROR_HANDLER START_GATEWAYSENDER STOP_GATEWAYSENDER WAIT_FOR_SENDER_QUEUE_FLUSH See also the function: GET_TABLE_VERSION.