Display Node Group command

 

The Display Node Group (DSPNODGRP) command displays the nodes (systems) in a node group.

It also displays the partitioning scheme for the node group (partitioning is discussed later in Partitioning with DB2^® Multisystem). The following example shows how to display a node group named GROUP1 as well as the partitioning scheme that is associated with the node group. This information is displayed to you at your workstation. You can find complete details on the DSPNODGRP command in the Control Language topic in the information center.

DSPNODGRP NODGRP(LIB1/GROUP1)

When you issue the DSPNODGRP command with a node group name specified, the Display Node Group display is shown. This display shows you the names of systems (listed in the relational database column) and the node number that is assigned to the system. This is a direct method for determining what system has what node number. Figure 1. Display Node Group: database to node number correlation in the node group display

Display Node Group
 
Node Group:   GROUP1         Library:   LIB1
 

Relational              Node

Database               Number
SYSTEMA                     1
SYSTEMB                     2
SYSTEMC                     3
 
 
 
 
 
 
 
 
 
 
 
 

BottomF3=Exit   F11=Partitioning Data   F12=Cancel   F17=Top   F18=Bottom  

To see the node number that is assigned to each partition number, use F11 (Partitioning Data) on the Display Node Group display. The next display shows you the node number that is assigned to each partition number. Mapping between the system and the node number (or node number to system) can be easily done by using the DSPNODGRP command. Figure 2. Display Node Group: partition number to node number correlation

                    Display Node Group
 
Node Group:   GROUP1         Library:   LIB1
 

Partition      Node
  Number      Number
     0           1
     1           2
     2           3
     3           1
     4           2
     5           3
     6           1
     7           2
     8           3
     9           1
    10           2
    11           3
    12           1
    13           2
    14           3

More...
F3=Exit   F11=Node Data   F12=Cancel   F17=Top   F18=Bottom  

The following example prints a list of the systems in the node group named GROUP2 as well as the associated partitioning scheme:

DSPNODGRP NODGRP(LIB1/GROUP2) OUTPUT(*PRINT)

 

Parent topic:

Node groups with DB2 Multisystem: Overview

 

Related concepts

Partitioning with DB2 Multisystem

 

Related reference

Control language