Administration Guide

SYSCAT.NODEGROUPDEF

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

Table 76. 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.

Column Name	Data Type	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 ]