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.
Syntax
| Element | Purpose | Restrictions |
|---|---|---|
| grid_name | Name of the grid. | Must be the name of an existing grid. |
| command_ID | One or more ID numbers of the command to rerun on the grid. | Separate multiple ID numbers with a comma or specify
a range with a hyphen (-). Can be NULL. |
| source_server | The replication server from which the routine was run. | Can be NULL. |
| tag | A character string identifying the grid operations to rerun. | Must be an existing tag. Can be NULL. |
| target_server | The replication server on which to rerun the routine. | Can be NULL. |
Usage
Commands that you run through the grid might fail on one or more servers in the grid. Use the ifx_grid_redo() procedure to rerun commands that failed. For example, if you create a fragmented table through the grid and one of the grid servers does not have one of the dbspaces into which the table is fragmented, the command fails on that server. After you add the required dbspace to the server, run the ifx_grid_redo() procedure to create the fragmented table on that server.
You can specify from which source server the commands were run, the command ID, the target server on which the commands failed, or the identifying tag for commands that failed.
Use the force argument to rerun commands that succeeded.
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 reruns failed commands on every server in the grid on which those commands failed:
EXECUTE PROCEDURE ifx_grid_redo('grid1');The following example reruns the command with the ID of 21 that originated server cdr1 on server cdr4:
EXECUTE PROCEDURE ifx_grid_redo('grid1', 'cdr1', 'cdr4', NULL, '21');The following example reruns all commands that failed on server cdr4:
EXECUTE PROCEDURE ifx_grid_redo('grid1', NULL, 'cdr4');