SQL Reference
Contains a row for each partition that is contained in a nodegroup.
Table 67. 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 | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]