Grid routines
Grid routines are used to create and maintain the grid and to administer servers in the grid by propagating commands from a source server to all other servers in the grid.
- ifx_get_erstate() function
The ifx_get_erstate() function indicates whether replication is enabled for the transaction in which it is run. - ifx_grid_connect() procedure
The ifx_grid_connect() procedure opens a connection to the grid. Through an ifx_grid_connect() procedure, you can run routines and data definition language (DDL) commands on a source server, and then propagate the routines or commands to the other grid servers. - ifx_grid_copy() procedure
The ifx_grid_copy() procedure copies non-database, external files from a grid database server to other nodes in the same grid. - ifx_grid_disconnect() procedure
The ifx_grid_disconnect() procedure closes a connection to the grid. - ifx_grid_execute() procedure
The ifx_grid_execute() procedure propagates the execution of a routine or data manipulation language (DML) SQL statement to all servers in the grid. - ifx_grid_function() function
The ifx_grid_function() function propagates the execution of a function to all servers in the grid. - ifx_grid_procedure() procedure
The ifx_grid_procedure() procedure propagates the execution of a procedure to all servers in the grid. - ifx_grid_redo() procedure
The ifx_grid_redo() procedure reruns commands that were run through the grid and failed on one or more servers in the grid. - ifx_grid_release() function
The ifx_grid_release() function propagates deferred DDL statements that were run on the local grid server, but deferred from running on the other grid servers. - ifx_grid_remove() function
The ifx_grid_remove() function removes any DDL statements that are deferred from propagation to grid servers. - ifx_grid_purge() procedure
The ifx_grid_purge() procedure deletes metadata about commands that have been run through the grid. - ifx_gridquery_skipped_nodes() function
The ifx_gridquery_skipped_nodes() function returns the name of a server that was unavailable during a grid or shard query. - ifx_gridquery_skipped_node_count() function
The ifx_gridquery_skipped_node_count() function returns the number of servers that were unavailable during a grid or shard query. - ifx_node_id() function
The ifx_node_id() function returns the ID of the grid server on which the function is run. - ifx_node_name() function
The ifx_node_name() function returns the name of the grid server on which the function is run.
Parent topic: Appendixes