Tivoli Storage Manager for Windows: Administrator's Reference

QUERY CONTENT (Query the Contents of a Storage Pool Volume)

Use this command to display information about files in a storage pool volume. You can use this command to identify files that the server has found to be damaged and files that have been backed up to a copy storage pool. This command is useful when a volume is damaged or before you:

Because this command can take a long time to run and the results can be very large, consider using the COUNT parameter to limit the number of files displayed.

Note:
Files that are cached in a disk volume and that are marked as damaged are not included in the results.

Privilege Class

Any administrator can issue this command.

Syntax

>>-Query CONtent--volume_name--+--------------------+----------->
                               '-NODE--=--node_name-'
 
>--+-------------------------------+--+------------------+------>
   '-FIlespace--=--file_space_name-'  '-COUnt--=--number-'
 
   .-Type--=--ANY--------------.  .-Format--=--Standard-----.
>--+---------------------------+--+-------------------------+--->
   '-Type--=--+-ANY----------+-'  '-Format--=--+-Standard-+-'
              +-Backup-------+                 '-Detailed-'
              +-Archive------+
              '-SPacemanaged-'
 
                                     (1)
   .-DAmaged--=--ANY-----.  .-COPied-------=--ANY-.
>--+---------------------+--+---------------------+------------->
   '-DAmaged--=--+-ANY-+-'  '-COPied--=--+-ANY-+--'
                 +-Yes-+                 +-Yes-+
                 '-No--'                 '-No--'
 
   .-NAMEType--=--SERVER------.
>--+--------------------------+--------------------------------->
   '-NAMEType--=--+-SERVER--+-'
                  +-UNIcode-+
                  '-FSID----'
 
   .-CODEType--=--BOTH-----------.
>--+-----------------------------+-----------------------------><
   '-CODEType--=--+-UNIcode----+-'
                  +-NONUNIcode-+
                  '-BOTH-------'
 
 

Notes:

  1. Use this parameter only for volumes in primary storage pools.

Parameters

volume_name (Required)
Specifies the volume to be queried.

NODE
Specifies the backup-archive client or the Tivoli Space Manager (HSM client) associated with the file space to query. This parameter is optional. You can use wildcard characters to specify this name. If you do not specify a name, all backup-archive and HSM clients are included.

FIlespace
Specifies the file space to query. This parameter is optional. You can use wildcard characters to specify this name. File space names are case-sensitive. If you do not specify a file space name, all file spaces are included.

For a server that has clients with Unicode support, you may need to have the server convert the file space name that you enter. For example, you may need to have the server convert the name you enter from the server's code page to Unicode. See the NAMETYPE parameter for details. If you do not specify a file space name or specify only a single wildcard character for the name, you can use the CODETYPE parameter to limit the operation to Unicode file spaces or non-Unicode file spaces.

COUnt
Specifies the number of files to be displayed. This parameter is optional. You can specify either a positive integer or a negative integer. If you specify a positive integer, n, the first n files are displayed. If you specify a negative integer, -n, the last n files are displayed in reverse order. You cannot specify COUNT=0. If you do not specify a value for this parameter, all files are displayed.

Type
Specifies the types of files to query. This parameter is optional. The default value is ANY. Possible values are:

ANY
Specifies that all types of files in the storage pool volume are queried: backup versions of files, archived copies of files, and files migrated from HSM client nodes.

Backup
Specifies that only backup files are queried.

Archive
Specifies that only archive files are queried.

SPacemanaged
Specifies that only space-managed files (files migrated from HSM clients) are queried.

Format
Specifies how the information is displayed. This parameter is optional. The default value is STANDARD. Possible values are:

Standard
Specifies that partial information is displayed. Unicode names are converted to the server code page.

Detailed
Specifies that complete information is displayed. Unicode names are displayed in hexadecimal.

DAmaged
Specifies criteria to restrict the query output based on whether files have been marked as damaged. For purposes of this criteria, the server examines only physical files (a file that may be a single logical file or an aggregate that consists of logical files). This parameter is optional. The default value is ANY. Possible values are:

ANY
Specifies that files are displayed regardless of whether the server has found the files to be damaged.

Yes
Specifies that only files that have been marked as damaged are displayed. These are files in which the server found errors when a user attempted to restore, retrieve, or recall the file, or when an AUDIT VOLUME command was run.

No
Specifies that only files not known to have been damaged are displayed.

COPied
Specifies criteria to restrict the query output based on whether files have been backed up to a copy storage pool. This parameter is optional. The default value is ANY. Possible values are:

ANY
Specifies that files are displayed regardless of whether the files are backed up to a copy storage pool. Primary and cached file copies are displayed.

Yes
Specifies that the files displayed are only those for which at least one usable backup copy exists in a copy storage pool. A file is not displayed if its copy in the copy storage pool is known to have errors. Cached file copies are not displayed because these files are never restored.

Use COPIED=YES to identify primary files that can be restored using the RESTORE VOLUME or RESTORE STGPOOL command.

No
Specifies that the files displayed are only those for which no usable backup copies exist in a copy storage pool. Cached file copies are not displayed because these files are never restored.

Use COPIED=NO to identify primary files that cannot be restored using the RESTORE VOLUME or RESTORE STGPOOL command.

NAMEType
Specify how you want the server to interpret the file space names that you enter. This parameter is useful when the server has clients with Unicode support. A backup-archive client with Unicode support is currently available only for Windows NT and Windows 2000 operating systems. Use this parameter only when you specify a partly or fully qualified file space name.

The default value is SERVER. Possible values are:

SERVER
The server uses the server's code page to interpret the file space names.

UNIcode
The server converts the file space names from the server code page to the UTF-8 code page. The success of the conversion depends on the actual characters in the names and the server's code page. Conversion can fail if the string includes characters that are not available in the server code page, or if the server has a problem accessing system conversion routines.

FSID
The server interprets the file space names as their file space IDs (FSIDs).

CODEType
Specify how you want the server to interpret the file space names that you enter. Use this parameter only when you enter a single wildcard character for the file space name.

The default value is BOTH, which means that the file spaces are included regardless of code page type. Possible values are:

UNIcode
Include only file spaces that are in unicode.

NONUNIcode
Include only file spaces that are not in unicode.

BOTH
Include file spaces regardless of code page type.

Examples

Task 1

Query the contents of the volume that is named f:\tsmstg\diskvol1.dsm. Limit the query to files backed up from the PEGASUS client node.

Results of the command include all logical files that make up any aggregate that is on the volume, even if the aggregate is stored on more than this volume. For aggregates, the query does not determine which logical files are actually stored on the volume for which the query is performed.

Command:
query content f:\tsmstg\diskvol1.dsm node=pegasus
 type=backup

Output:
+--------------------------------------------------------------------------------+
|Node Name        Type  Filespace   FSID  Client's Name for File                 |
|                       Name                                                     |
|---------------  ----  ----------  ----  ----------------------                 |
|PEGASUS         Bkup  \\pegasus\e$   1   \UNI_TEST\ SM01.DAT                    |
|PEGASUS         Bkup  \\pegasus\e$   1   \UNI_TEST\ SM02.DAT                    |
|                                                                                |
+--------------------------------------------------------------------------------+

See Task 2 for parameter definitions.

Task 2

Query the contents of the tape volume named WPD001. Display only files backed up by the node MARK, and only the first four files on the volume. Display complete information.

Command:
query content wpd001 node=mark count=4 type=backup
 format=detailed
+--------------------------------------------------------------------------------+
|                         Node Name: MARK                                        |
|                              Type: Bkup                                        |
|                    Filespace Name: \\mark\e$                                   |
|        Hexadecimal Filespace Name:                                             |
|                              FSID: 1                                           |
|            Client's Name for File: \UNI_TEST\ SM01.DAT                         |
|Hexadecimal Client's Name for File:                                             |
|                       Aggregated?: 1/3                                         |
|                       Stored Size: 2,746                                       |
|                    Segment Number:                                             |
|                      Cached Copy?: No                                          |
|                                                                                |
|                         Node Name: MARK                                        |
|                              Type: Bkup                                        |
|                    Filespace Name: \\mark\e$                                   |
|        Hexadecimal Filespace Name:                                             |
|                              FSID: 1                                           |
|            Client's Name for File: \UNI_TEST\ SM02.DAT                         |
|Hexadecimal Client's Name for File:                                             |
|                       Aggregated?: 2/3                                         |
|                       Stored Size: 2,746                                       |
|                    Segment Number:                                             |
|                      Cached Copy?: No                                          |
|                                                                                |
|                         Node Name: MARK                                        |
|                              Type: Bkup                                        |
|                    Filespace Name: \\mark\e$                                   |
|        Hexadecimal Filespace Name:                                             |
|                              FSID: 1                                           |
|            Client's Name for File: \UNI_TEST\ SM03.DAT                         |
|Hexadecimal Client's Name for File:                                             |
|                       Aggregated?: 3/3                                         |
|                       Stored Size: 2,746                                       |
|                    Segment Number:                                             |
|                      Cached Copy?: No                                          |
|                                                                                |
|                         Node Name: MARK                                        |
|                              Type: Bkup                                        |
|                    Filespace Name: \\mark\f$                                   |
|        Hexadecimal Filespace Name: 5c5c6d61726b5c6624                          |
|                              FSID: 2                                           |
|            Client's Name for File: \UNI_TEST\ ELAP.REX                         |
|Hexadecimal Client's Name for File: 5c554e495f544553545c20454c41502e524558      |
|                       Aggregated?: 1/3                                         |
|                       Stored Size: 2,372                                       |
|                    Segment Number:                                             |
|                      Cached Copy?: No                                          |
+--------------------------------------------------------------------------------+

Node Name
The node to which the file belongs.

Type
The type of file: archive (Arch), backup (Bkup), or space-managed (SpMg).

Filespace Name
The file space to which the file belongs.

File space names and file names that can be in a different code page or locale than the server do not display correctly on the administrator's Web interface or the administrative command-line interface. The data itself is backed up and can be restored properly, but the file space or file name may display with a combination of invalid characters or blank spaces.

If the file space name is Unicode enabled, the name is converted to the server's code page for display. The results of the conversion for characters not supported by the current code page depends on the operating system. For names that TSM is able to partially convert, you may see question marks (??), blanks, unprintable characters, or "...". These characters indicate to the administrator that files do exist. If the conversion is not successful, the name is displayed as "...". Conversion can fail if the string includes characters that are not available in the server code page, or if the server has a problem accessing system conversion routines.

Hexadecimal Filespace Name
The file space to which the file belongs. If the file space name is in Unicode, the name is displayed in hexadecimal format.

FSID
The file space ID (FSID) for the file space. The server assigns a unique FSID when a file space is first stored on the server.

Client's Name for File
The client's name for the file.

File space names and file names that can be in a different code page or locale than the server do not display correctly on the administrator's Web interface or the administrative command-line interface. The data itself is backed up and can be restored properly, but the file space or file name may display with a combination of invalid characters or blank spaces. The results of the conversion for characters not supported by the current code page depends on the operating system. For names that TSM is able to partially convert, you may see question marks (??), blanks, unprintable characters, or "...". These characters indicate to the administrator that files do exist.

Hexadecimal Client's Name for File
The client's name for the file displayed in hexadecimal format.

Aggregated?
Whether the file is a logical file that is stored as part of an aggregate. If the file is part of an aggregate, the sequence of this file within the aggregate and the total number of logical files in the aggregate are displayed.

Results of the command include all logical files that make up any aggregate that is on the volume, even if the aggregate is stored on more than this volume. The query does not determine which logical files are actually stored on the volume for which the query is performed.

Stored Size
The size of the physical file, in bytes. If the file is a logical file that is stored as part of an aggregate, this value indicates the size of the entire aggregate.

Segment Number
For volumes in sequential-access storage pools, specifies whether the physical file (either a single logical file or an aggregate of logical files) is stored across multiple volumes. For example, if the logical file is stored in an aggregate that spans two volumes, the segment number indicates 1/2 (the first part of the physical file is stored on the volume) or 2/2 (the second part of the physical file is stored on the volume). If the segment number is 1/1, the physical file is completely stored on the volume. For volumes in random-access storage pools, no value is displayed for this field.

Cached Copy?
Whether the physical file is a cached copy of a file migrated to the next storage pool. If the file is part of an aggregate, this value pertains to the aggregate.

Related Commands

Table 170. Commands Related to QUERY CONTENT

Command Description
BACKUP STGPOOL Backs up a primary storage pool to a copy storage pool.
DEFINE VOLUME Assigns a volume to be used for storage within a specified storage pool.
DELETE VOLUME Deletes a volume from a storage pool.
RESTORE STGPOOL Restores files to a primary storage pool from copy storage pools.
RESTORE VOLUME Restores files stored on specified volumes in a primary storage pool from copy storage pools.
UPDATE VOLUME Updates the attributes of storage pool volumes.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]