solidDB Help : solidDB reference : SQL: Statements : ALTER GRID
  
ALTER GRID
Note Check the solidDB Release Notes for any limitations that are associated with using this statement with a grid in the current release.
ALTER GRID [grid‑name] [node‑element]
node‑element::= {ADD NODE [name‑element] connect‑info |
   DROP NODE name‑element [post‑drop‑task] |
   SET NODE name‑element {ONLINE | OFFLINE}}
name‑element::= NAME node‑name
connect‑info::= CONNECT TO connect‑string
post‑drop‑task::= {KEEP | SHUTDOWN | RECYCLE}
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the ALTER GRID statement to make changes to a specified grid.
Parameters, clauses, keywords, and variables
▪ ADD NODE: Adds a node to the grid, see Adding a node to a grid.
▪ DROP NODE: Removes a node from the grid, see Removing a node from a grid. You can include one of the following tasks:
– KEEP: Leaves the server running.
– SHUTDOWN: Shuts down the server. This is the default option.
– RECYCLE: Restarts the server as a new grid node (by using the -x gridnode command line option).
Note The node controller must be active for the RECYCLE option to work, see Node controller.
▪ SET NODE .. OFFLINE: Disconnects a node temporarily from a grid. Before you run this statement, you must disable the Grid Availability Manager (GAM) and leave the GAM disabled for the period that the node is disconnected. If the GAM is active, it will attempt to set the node online again. For more details, see Disconnecting a node from the grid temporarily.
▪ SET NODE .. ONLINE: Reconnects a previously disconnected node back to a grid. After you run this statement, enable the GAM again, see Reconnecting a node to the grid.
Examples
ALTER GRID ADD NODE CONNECT TO 'tcp -i 192.168.34.21 2323'
ALTER GRID ADD NODE NAME node2 CONNECT TO 'tcp 2323':
ALTER GRID DROP NODE NAME node7 RECYCLE;
ALTER GRID DROP NODE NAME node3 KEEP;
ALTER GRID DROP NODE NAME node4 SHUTDOWN;
ALTER GRID SET NODE NAME GNODE_2 OFFLINE;
ALTER GRID SET NODE NAME GNODE_2 ONLINE;
Go up to
SQL: Statements