QUERY NODEDATA (Query client data in volumes)

Edit online

Use this command to display information about the data for one or more nodes in a sequential-access storage pool. The output from the QUERY NODEDATA command displays the name of the volume on which a node's data is written and the amount of space that is occupied by the data on that volume. This information is useful when you determine how to group nodes into collocated storage pools.

Privilege class

Any administrator can issue this command.

Restriction: You cannot use this command to display information for container storage pools.

Syntax

Parameters

node_name

Specifies the name of the client node for which you want to locate data. You can specify one or more names. If you specify multiple names, separate the names with commas; do not use intervening spaces. You can also use wildcard characters to specify multiple names. You must specify either a node name or collocation group name, but not both.

COLLOCGroup

Specifies the name of the collocation group for which you want to locate data. You must specify either a node name or collocation group name, but not both.

Important: If the amount of space that is needed to complete the query about a collocation group exceeds the SQL buffer limit, the QUERY NODEDATA command can fail. If the command fails for this reason, issue the QUERY COLLOCGROUP command to display a list of nodes in the group. Then, issue the QUERY NODEDATA command for each node in the group.

STGpool

Specifies the name of the sequential storage pool to query. This parameter is optional. You can use wildcard characters to specify the names. If a wildcard matches the name of a disk storage pool, the name of the disk storage pool is ignored. If you do not specify a value for this parameter, all sequential-access storage pools are queried.

VOLume

Specifies the volume that contains the data. This parameter is optional. You can use wildcard characters to specify multiple names. If you do not specify a value for this parameter, all volumes in the storage pool are queried.

FIlespace

Specifies the filespace name on the client node that you want to query. This parameter is optional and can be specified only if a node name is specified in the command. You can specify one or more filespace names for a specific client node. If you specify multiple filespace names, separate the names with commas and no intervening spaces. You can also use wildcard characters to specify multiple filespace names.

NAMEType

Specify how you want the server to interpret the filespace names that you enter. Specify this parameter when the server communicates with clients that have Unicode support. A backup-archive client with Unicode support is available only for Windows, Macintosh OS 9, Macintosh OS X, and NetWare systems. The filespace name cannot be a wildcard character when NAMETYPE is specified for a filespace collocation group. The default value is SERVER. You can specify one of the following values:

SERVER: The server uses the server code page to interpret the filespace names.

UNIcode: The server converts the filespace names from the server code page to the UTF-8 code page. Whether the name can be converted depends on the characters in the names and the server code page. Conversion might fail if the string includes characters that are not available in the server code page, or if the server cannot access system conversion routines.

FSID: The server interprets the filespace names by their filespace IDs (FSIDs).; Restriction: Ensure that you specify the FSID for the FILESPACE parameter value. Do not specify the filespace name.

CODEType

Specify how you want the server to interpret the filespace names that you enter. Use this parameter when you use a wildcard character for the filespace name. The default is BOTH. This setting ensures that filespaces are included, regardless of code page type. You can specify one of the following values:

BOTH: Include filespaces, regardless of code page type.

UNIcode: Include filespaces that are only in Unicode.

NONUNIcode: Include filespaces that are not in Unicode.

RETSet

Specifies the ID of a retention set that you want to query. The retention set ID is a unique numeric value. This parameter is optional. If you specify a retention set ID, the query obtains only items that are part of this retention set. If you do not specify a value for this parameter, all retention sets are queried.

Use wildcards to display node data for a sequential-access storage pool

Display information about the location of node data in a sequential-access storage pool. Use a wildcard character to indicate node names. See Field descriptions for field descriptions.

query nodedata e*

   Node Name   Volume Name                      Storage Pool  Physical
                                                Name          Space
                                                              Occupied
                                                              (MB)
   ---------   ------------------------------   ------------  --------
   EDU_J2      E:\tsm\server\00000117.BFS       EDU512        0.01
   EDU_J2      E:\tsm\server\00000122.BFS       EDU319        0.01
   EDU_J3      E:\tsm\server\00000116.BFS       EDU512        0.01
   EDU_J3      E:\tsm\server\00000120.BFS       EDU319        0.01
   EDU_J7      E:\tsm\server\00000118.BFS       EDU512        0.04
   EDU_J7      E:\tsm\server\00000123.BFS       EDU319        0.04
   EDU_JJ1     E:\tsm\server\00000116.BFS       EDU512        0.01
   EDU_JJ1     E:\tsm\server\00000121.BFS       EDU512        0.01

Display node data information for a specific collocation group

Display information about the location of node data in a sequential-access storage pool for a particular collocation group. In this example, nodes EDU_J3 and EDU_JJ1 are the only members that belong to collocation group, grp1, and have data in a sequential-access storage pool.

query nodedata collocgroup=grp1


   Node Name   Volume Name                      Storage Pool  Physical
                                                Name          Space
                                                              Occupied
                                                              (MB)
   ---------   ------------------------------   ------------  --------
   EDU_J3      E:\tsm\server\00000116.BFS       EDU512        0.01
   EDU_J3      E:\tsm\server\00000120.BFS       EDU319        0.01
   EDU_JJ1     E:\tsm\server\00000116.BFS       EDU512        0.01
   EDU_JJ1     E:\tsm\server\00000121.BFS       EDU512        0.01

If you specify a filespace collocation group, only the volumes of the filespaces that belong to the collocation group are displayed. If you specify a filespace collocation group and a volume, the filespace volumes within the collocation group that are also in the specified volume are displayed.

Field descriptions

Node Name: Specifies the name of the node.
Volume Name: Specifies the name of the volume that contains the node data.
Storage Pool Name: Specifies the name of the storage pool in which the volume is located.
Physical Space Occupied (MB): Specifies the amount of physical space that is occupied by the node's data. Physical space includes empty space within aggregates, from which files might be deleted or expired.

Related commands

Table 1. Commands related to QUERY NODEDATA
Command	Description
DEFINE COLLOCGROUP	Defines a collocation group.
DEFINE COLLOCMEMBER	Adds a client node or file space to a collocation group.
DEFINE STGPOOL	Defines a storage pool as a named collection of server storage media.
DELETE COLLOCGROUP	Deletes a collocation group.
DELETE COLLOCMEMBER	Deletes a client node or file space from a collocation group.
MOVE NODEDATA	Moves data for one or more nodes, or a single node with selected file spaces.
QUERY COLLOCGROUP	Displays information about collocation groups.
QUERY NODE	Displays partial or complete information about one or more clients.
QUERY STGPOOL	Displays information about storage pools.
REMOVE NODE	Removes a client from the list of registered nodes for a specific policy domain.
UPDATE COLLOCGROUP	Updates the description of a collocation group.
UPDATE STGPOOL	Changes the attributes of a storage pool.