Contains a row for each nodegroup.
Table 77. SYSCAT.NODEGROUPS Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
NGNAME | VARCHAR(18) |
| Name of the nodegroup. |
DEFINER | CHAR(8) |
| Authorization ID of the nodegroup definer. |
PMAP_ID | SMALLINT |
| Identifier of the partitioning map in SYSCAT.PARTITIONMAPS. |
REBALANCE_PMAP_ID | SMALLINT |
| Identifier of the partitioning map currently being used for redistribution. Value is -1 if redistribution is currently not in progress. |
CREATE_TIME | TIMESTAMP |
| Creation time of nodegroup. |
REMARKS | VARCHAR(254) | Yes | User-provided comment. |