ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbmult_5.4.0.1/dspng.htm

123 lines
6.6 KiB
HTML
Raw Permalink Normal View History

2024-04-02 14:02:31 +00:00
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="security" content="public" />
<meta name="Robots" content="index,follow" />
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
<meta name="DC.Type" content="concept" />
<meta name="DC.Title" content="Display Node Group (DSPNODGRP) command" />
<meta name="abstract" content="The Display Node Group (DSPNODGRP) command displays the nodes (systems) in a node group." />
<meta name="description" content="The Display Node Group (DSPNODGRP) command displays the nodes (systems) in a node group." />
<meta name="DC.subject" content="node group, displaying, node, DSPNODGRP (Display Node Group) command, using, Display Node Group (DSPNODGRP) command, command, CL, DSPNODGRP (Display Node Group), Display Node Group (DSPNODGRP), node group, example, figure, Database to Node Number Correlation, Database to Node Number Correlation figure, Display Node Group display, Partition Number to Node Number Correlation figure, Display Node Group display, Partition Number to Node Number Correlation" />
<meta name="keywords" content="node group, displaying, node, DSPNODGRP (Display Node Group) command, using, Display Node Group (DSPNODGRP) command, command, CL, DSPNODGRP (Display Node Group), Display Node Group (DSPNODGRP), node group, example, figure, Database to Node Number Correlation, Database to Node Number Correlation figure, Display Node Group display, Partition Number to Node Number Correlation figure, Display Node Group display, Partition Number to Node Number Correlation" />
<meta name="DC.Relation" scheme="URI" content="rzaf3c2-gen4.htm" />
<meta name="DC.Relation" scheme="URI" content="ption.htm" />
<meta name="DC.Relation" scheme="URI" content="../rbam6/rbam6clmain.htm" />
<meta name="DC.Relation" scheme="URI" content="ption.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="dspng" />
<meta name="DC.Language" content="en-us" />
<!-- All rights reserved. Licensed Materials Property of IBM -->
<!-- US Government Users Restricted Rights -->
<!-- Use, duplication or disclosure restricted by -->
<!-- GSA ADP Schedule Contract with IBM Corp. -->
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
<link rel="stylesheet" type="text/css" href="./ic.css" />
<title>Display Node Group (DSPNODGRP) command</title>
</head>
<body id="dspng"><a name="dspng"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Display Node Group (DSPNODGRP) command</h1>
<div><p>The Display Node Group (DSPNODGRP) command displays the nodes (systems)
in a node group.</p>
<p>It also displays the partitioning scheme for the node group (partitioning
is discussed later in Partitioning with DB2<sup>®</sup> Multisystem).</p>
<div class="p">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. For complete details
on the DSPNODGRP command, see the Control Language topic in the information
center. <pre>DSPNODGRP NODGRP(LIB1/GROUP1)</pre>
</div>
<p>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.</p>
<div class="fignone"><span class="figcap">Figure 1. Display Node Group: database to node number correlation in the
node group display</span><pre class="screen"><strong>Display Node Group</strong>
Node Group: GROUP1 Library: LIB1
<strong>Relational</strong> <strong>Node</strong>
<strong>Database</strong> <strong>Number</strong>
SYSTEMA 1
SYSTEMB 2
SYSTEMC 3
<strong>Bottom</strong>F3=Exit F11=Partitioning Data F12=Cancel F17=Top F18=Bottom
</pre>
</div>
<p>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.</p>
<div class="fignone"><span class="figcap">Figure 2. Display Node Group: partition number to node number
correlation</span><pre class="screen"><strong> Display Node Group</strong>
Node Group: GROUP1 Library: LIB1
<strong>Partition</strong> <strong>Node</strong>
<strong>Number</strong> <strong>Number</strong>
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
<strong>More...</strong>
F3=Exit F11=Node Data F12=Cancel F17=Top F18=Bottom
</pre>
</div>
<div class="p">The following example prints a list of the systems in the node group named
GROUP2 as well as the associated partitioning scheme: <pre>DSPNODGRP NODGRP(LIB1/GROUP2) OUTPUT(*PRINT)</pre>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaf3c2-gen4.htm" title="To enable database files to be visible across a set of iSeries servers, you must first define the group of systems (node group) that you want the files on.">Introduction of node groups with DB2 Multisystem</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="ption.htm" title="Partitioning is the process of distributing a file across the nodes in a node group.">Partitioning with DB2 Multisystem</a></div>
</div>
<div class="relref"><strong>Related reference</strong><br />
<div><a href="../rbam6/rbam6clmain.htm">Control language</a></div>
</div>
</div>
</body>
</html>