Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Appendixes
Grid routinesGrid 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_grid_disconnect() procedureThe ifx_grid_disconnect() procedure closes a connection to the grid.

ifx_grid_disconnect() procedure

The ifx_grid_disconnect() procedure closes a connection to the grid.

Syntax

Usage

Use the ifx_grid_disconnect() procedure to disable the propagation of DDL statements and commands to servers in the grid, which was enabled by the ifx_grid_connect() procedure. If you do not use the ifx_grid_disconnect() procedure, propagation through the grid is stopped when the database is closed or the connection is closed.

You must run this routine as an authorized user on an authorized grid server, as specified by the cdr grid enable command.

Example

The following example shows how to close a connection to the grid after opening a connection:

EXECUTE PROCEDURE ifx_grid_connect('grid1');
EXECUTE PROCEDURE ifx_grid_disconnect();