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.

Syntax


1  EXECUTE FUNCTION ifx_grid_release ( ' grid_name ' , ' tag ' ) ;
Element Purpose Restrictions
grid_name The name of the grid that a DDL statement is queued to propagates across Must be the name of an existing grid.
tag A character string to identify grid operations. Must be the same value as the tag argument that was included in the ifx_grid_connect() procedure with the defer argument.

Usage

If you deferred the propagation of DDL statements by running the ifx_grid_connect() procedure with the defer argument, DDL statements are run on the local server but deferred from propagating across the grid. Run the ifx_grid_release() function to propagate the DDL statements to the other grid servers. You can run the ifx_grid_release() command at any time after the grid session in which the statements were deferred.

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

Returns

The number of DDL statements that are released.

Example

The following example defers propagation of the ALTER operation across grid1:

database sales;

EXECUTE PROCEDURE ifx_grid_connect('grid1','tag1',4);

ALTER TABLE special_offers ADD (
	  local_restrictions	 varchar(255));

The following statement releases the queued ALTER operation:

EXECUTE FUNCTION ifx_grid_release('grid1','tag1');

The local_restrictions column is added to the special_offers table on the other grid servers.