SQL Reference

SYSCAT.NODEGROUPDEF

Contains a row for each partition that is contained in a nodegroup.

Table 71. SYSCAT.NODEGROUPDEF Catalog View
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.


[ Top of Page | Previous Page | Next Page ]