Grid maintenance

You can adjust grid membership, change user or server authorization to run grid routines, and delete grid-routine history from the syscdr database.

To see information about the grid, such as, which servers can run grid routines and the status of routines that are run on the grid servers, run the cdr list grid command.

If you remove a server from your replication domain, remove the server from your grid. The following example removes a replication server named gserv1 from the grid grid_1:

cdr change grid grid_1 --delete gserv1

You cannot drop a replicated column through a grid. To drop a replicated column, you must manually remaster the replicate and then drop the column.

You cannot rename a replicated database. You must manually rename the database on each participant server by using the cdr remaster command.

To change which users can run routines on the grid or which servers are authorized to run grid routines, run the cdr enable grid and cdr disable grid commands. For example, to change the authorized server from gserv1 to gserv2 and authorize the user srini, run the following commands:

cdr disable grid --grid=grid1 --node=gserv1
cdr enable grid --grid=grid1 --node=gserv2 --user=srini

To delete the history of grid routines, run the ifx_grid_purge() procedure. You must occasionally purge information about completed grid routines to prevent the syscdr database from growing too large.