| Column Name
| Data Type
| Nullable
| Description
|
| NGNAME
| VARCHAR(18)
|
| The name of the nodegroup that contains the partition (or node).
|
| NODENUM
| SMALLINT
|
| The partition (or node) number of a partition contained in the
nodegroup. A valid partition number is between 0 and 999
inclusive.
|
| IN_USE
| CHAR(1)
|
| Status of the partition (or node).
A = The newly added partition is not in the partitioning map but the
containers for the table spaces in the nodegroup are created. The
partition is added to the partitioning map when a Redistribute Nodegroup
operation is successfully completed.
D = The partition will be dropped when a Redistribute Nodegroup
operation is completed.
T = The newly added partition is not in the partitioning map and it was
added using the WITHOUT TABLESPACES clause. Containers must be
specifically added to the table spaces for the nodegroup.
Y = The partition is in the partitioning map.
|