Note Check the solidDB Release Notes for any limitations that are associated with using a grid in the current release.
The statement CREATE GRID creates a solidDB grid and adds the current server as the initial node, see Creating a grid.
When the CREATE GRID statement is executed, the following steps are performed:
1 The server that is to become the initial node is validated to check that Grid.GridEnabled=Yes is set in the solid.ini file.
2 If the database already contains tables, these tables are converted to non-partitioned (shared) tables in the grid (and are replicated to all new nodes). However, there are a number of exceptions and caveats:
▪ Transient and temporary table types are not supported in a grid. An attempt to create a grid when the current database has existing transient or temporary tables fails with error 13634.
▪ Sequences are not supported in a grid. An attempt to create a grid when the current database has existing sequences fails with error 13634.
▪ If an existing table (of a type other than transient or temporary) contains functionality that is not supported in a grid, the table is retained in the database on the current server but is not replicated to new nodes. An attempt to create a grid table that has the same name as the existing table will fail.
▪ Tables that contain triggers are converted to non-partitioned tables in a grid but the behavior of the triggers in the grid might be unpredictable, see SQL limitations for partitioned tables.
3 As the only node in the grid, the node becomes the grid leader.
After the node is added, the Grid Availability Manager (GAM) is started, see Grid Availability Manager