Command Reference

LIST NODEGROUPS

Lists all nodegroups associated with the current database.

Scope

This command can be issued from any node that is listed in $HOME/sqllib/db2nodes.cfg. It returns the same information from any of these nodes.

Authorization

For the system catalogs SYSCAT.NODEGROUPS and SYSCAT.NODEGROUPDEF, one of the following is required:

• sysadm or dbadm authority

• CONTROL privilege

• SELECT privilege.

Required Connection

Database

Command Syntax

>>-LIST NODEGROUPS----+--------------+-------------------------><
                      '-SHOW DETAIL--'
 

Command Parameters

SHOW DETAIL

Specifies that the output should include the following information:

• Partitioning map ID

• Node number

• In-use flag

Examples

Following is sample output from the LIST NODEGROUPS command:

NODEGROUP NAME ---------------------------- IBMCATGROUP IBMDEFAULTGROUP IBMTEMPGROUP 3 record(s) selected.

Following is sample output from the LIST NODEGROUPS SHOW DETAIL command:

NODEGROUP NAME PMAP_ID NODE NUMBER IN_USE ---------------------------- ------- ---------------------- ------ IBMCATGROUP 0 0 Y IBMDEFAULTGROUP 1 0 Y 2 record(s) selected.

The fields are identified as follows:

NODEGROUP NAME

The name of the nodegroup. The name is repeated for each node in the nodegroup.

PMAP_ID

The ID of the partitioning map. The ID is repeated for each node in the nodegroup.

NODE NUMBER

The number of the node.

IN_USE

One of four values:

Y

The node is being used by the nodegroup.

D

The node is going to be dropped from the nodegroup as a result of a REDISTRIBUTE NODEGROUP operation. When the operation completes, the node will not be included in reports from LIST NODEGROUPS.

A

The node has been added to the nodegroup but is not yet added to the partitioning map. The containers for the table spaces in the nodegroup have been added on this node. The value is changed to Y when the REDISTRIBUTE NODEGROUP operation completes successfully.

T

The node has been added to the nodegroup, but is not yet added to the partitioning map. The containers for the table spaces in the nodegroup have not been added on this node. Table space containers must be added on the new node for each table space in the node group. The value is changed to A when containers have successfully been added.

For more information, see the SQL Reference.

See Also

REDISTRIBUTE NODEGROUP.

[ DB2 List of Books | Search the DB2 Books ]