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_procedure() procedureThe ifx_grid_procedure() procedure propagates the execution of a procedure 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.

Syntax


Element	Purpose	Restrictions
`grid_name`	Name of the grid.	Must be the name of an existing grid.
`procedure_text`	The text format of the procedure to be run.	Bound data items cannot be included.
`tag`	A character string to identify grid operations.

Usage

Use the ifx_grid_procedure() procedure to run a procedure or SQL statement on a source server and propagate it so that it is also run on the other servers in the grid. You cannot run the ifx_grid_procedure() procedure from within a transaction.

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

Example

The following example runs a procedure named myloadprocedure():

EXECUTE PROCEDURE ifx_grid_procedure('grid1',
	'myloadprocedure(2000)', 'mytag');