Tivoli Storage Manager for Windows: Administrator's Reference

QUERY RESTORE (Query Restartable Restore Sessions)

Use this command to display information about the restartable restore sessions.

Privilege Class

Any administrator can issue this command.

Syntax

>>-Query--RESTore--+-----------+--+-----------------+----------->
                   '-node_name-'  '-file_space_name-'
 
   .-Format--=--Standard-----.  .-NAMEType--=--SERVER------.
>--+-------------------------+--+--------------------------+---><
   '-Format--=--+-Standard-+-'  '-NAMEType--=--+-SERVER--+-'
                '-Detailed-'                   +-UNIcode-+
                                               '-FSID----'
 
 

Parameters

node_name
Specifies the client node to be queried. This parameter is optional. If you do not specify a value, all client nodes with restartable restore sessions are displayed. You must specify a value for this parameter if you specify a file space name.

file_space_name
Specifies the file space to be queried. This parameter is optional. If you do not specify a value, all file spaces are matched for the specified node.

For a server that has clients with support for Unicode, 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.

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.

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 support for Unicode. A backup-archive client with support for Unicode is currently available only for Windows NT and Windows 2000 operating systems.

Use this parameter only when you enter 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 name entered from the server code page to the UTF-8 code page. The success of the conversion depends on the actual characters in the name 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).

Examples

Task

Display detailed information about client node JAMES associated with file space DRIVE_F_R.

Command:
query restore james drive_f_r format=detailed
+--------------------------------------------------------------------------------+
|    Sess Number: -1                                                             |
|  Restore State: Restartable                                                    |
|Elapsed Minutes: 2                                                              |
|      Node Name: JAMES                                                          |
|           FSID: 1                                                              |
| Filespace Name: DRIVE_F_R:                                                     |
|      File Spec: /RESTORE/TESTDIRF\\                                            |
|                                                                                |
|                                                                                |
+--------------------------------------------------------------------------------+

where:

Sess Number
Specifies the session number for the restartable restore session. The number for active restore sessions is the same number displayed on the QUERY SESSION command. For restore sessions in the restartable state, a negative number is displayed for the session number. Any session number displayed in the QUERY RESTORE output may be specified from the QUERY RESTORE output.

Restore State

Elapsed Minutes
Specifies the number of minutes since the restore session started. Any restartable restore session with an elapsed time greater than the RESTOREINTERVAL server option can be automatically deleted from the database when needed or during expiration processing. If the elapsed time is less than the RESTOREINTERVAL, you can delete this entry (and unlock the filespace) only by issuing the CANCEL RESTORE command lowering the RESTOREINTERVAL value.

Node Name
Specifies the node associated with the restartable restore session.

FSID
Specifies the file space ID of the file space.

Filespace Name
Specifies the file space associated with the restartable restore session.

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.

File Spec
Specifies the file specification used on the restore operation. The same file specification must be specified if a failed restore operation is to be restarted from where it stopped.

Related Commands

Table 205. Commands Related to QUERY RESTORE

Command Description
CANCEL RESTORE Cancels a restartable restore session.


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