ifx_grid_purge() procedure
The ifx_grid_purge() procedure deletes metadata about commands that have been run through 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 purge. | Separate multiple ID numbers with a comma or specify
a range with a hyphen (-). Can be NULL. |
| source_server | The replication server on which the routine originated. | Can be NULL. |
| tag | A character string identifying the grid operations to purge. | Must be an existing tag. Can be NULL. |
| target_server | The replication server on which the routine was run. | Can be NULL. |
Usage
Use the ifx_grid_purge() procedure to delete the history of commands successfully run from the grid. Accumulated command history can significantly increase the size of the syscdr database.
Use the force argument to delete the history of all commands, including those that failed.
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 deletes the history for commands that ran successfully:
EXECUTE PROCEDURE ifx_grid_purge('grid1');The following example deletes the history for commands, including those that failed:
EXECUTE PROCEDURE ifx_grid_purge('grid1', NULL, NULL, NULL, NULL, 'force');The following example deletes the command history with the ID of 21 that originated server cdr1 and ran on server cdr4:
EXECUTE PROCEDURE ifx_grid_purge('grid1', 'cdr1', 'cdr4', NULL, '21');The following example deletes all commands that ran successfully on server cdr4:
EXECUTE PROCEDURE ifx_grid_purge('grid1', NULL, 'cdr4');