Tivoli Storage Manager for HP-UX 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, you should 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--'
 
                              .-Type--=--ANY--------------.
>-----+-------------------+---+---------------------------+----->
      '-COUnt--=--number--'   '-Type--=--+-ANY----------+-'
                                         +-Backup-------+
                                         +-Archive------+
                                         '-SPacemanaged-'
 
      .-Format--=--Standard-----.   .-DAmaged--=--ANY-----.
>-----+-------------------------+---+---------------------+----->
      '-Format--=--+-Standard-+-'   '-DAmaged--=--+-ANY-+-'
                   '-Detailed-'                   +-Yes-+
                                                  '-No--'
 
               (1)
      .-COPied-------=--ANY--.
>-----+----------------------+---------------------------------><
      '-COPied--=--+-ANY-+---'
                   +-Yes-+
                   '-No--'
 

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.

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.

Detailed
Specifies that complete information is displayed.

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.

Examples

Task 1

Query the contents of the volume that is named /tsmstg/diskvol1.dsm. Limit the query to space-managed files from the PEGASUS client node.

Command:
query content /tsmstg/diskvol1.dsm node=pegasus
 type=spacemanaged

Output:
+--------------------------------------------------------------------------------+
|Node Name                Type Filespace  Client's Name for File                 |
|                              Name                                              |
|------------------------ ---- ---------- ----------------------                 |
|PEGASUS                  SpMg /home      /sunday/08                             |
|PEGASUS                  SpMg /home      /sunday/09                             |
|PEGASUS                  SpMg /home      /sunday/11                             |
|PEGASUS                  SpMg /home      /sunday/14                             |
+--------------------------------------------------------------------------------+

where:

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.

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

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.

Task 2

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

Command:
query content wpd001 node=dwe count=4 type=backup
 format=detailed
+--------------------------------------------------------------------------------+
|             Node Name: DWE                                                     |
|                  Type: Bkup                                                    |
|        Filespace Name: OS2                                                     |
|Client's Name for File: \ README                                                |
|           Aggregated?: No                                                      |
|           Stored Size: 27,089                                                  |
|        Segment Number: 1/1                                                     |
|          Cached Copy?: No                                                      |
|                                                                                |
|             Node Name: DWE                                                     |
|                  Type: Bkup                                                    |
|        Filespace Name: DRIVE_L_K:                                              |
|Client's Name for File: \COMMON\DSMCOMMN\ AB0CTCOM.ENT                          |
|           Aggregated?: 1/4                                                     |
|           Stored Size: 202,927                                                 |
|        Segment Number: 1/1                                                     |
|          Cached Copy?: No                                                      |
|                                                                                |
|             Node Name: DWE                                                     |
|                  Type: Bkup                                                    |
|        Filespace Name: DRIVE_L_K:                                              |
|Client's Name for File: \COMMON\DSMCOMMN\ AB0CTGLO.IDE                          |
|           Aggregated?: 2/4                                                     |
|           Stored Size: 202,927                                                 |
|        Segment Number: 1/1                                                     |
|          Cached Copy?: No                                                      |
|                                                                                |
|             Node Name: DWE                                                     |
|                  Type: Bkup                                                    |
|        Filespace Name: DRIVE_L_K:                                              |
|Client's Name for File: \COMMON\DSMCOMMN\ AB0CTTRD.IDE                          |
|           Aggregated?: 3/4                                                     |
|           Stored Size: 202,927                                                 |
|        Segment Number: 1/1                                                     |
|          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.

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

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 151. 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 ]