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. You can use this parameter for Unicode-enabled Tivoli® Storage Manager clients using Windows, Macintosh OS 9, Macintosh OS X, and NetWare 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).

Example: Display a restartable restore session on a specific client node

Display detailed information about client node JAMES associated with file space DRIVE_F_R. See Field descriptions for field descriptions.

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\\

Field descriptions

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

Active: Specifies the restore session is actively restoring files to the client.
Restartable: Specifies the restore session failed and can be restarted from where it left off.

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 can be in a different code page or locale than the server. If they are, the names in the Operations Center and the administrative command-line interface might not be displayed correctly. Data is backed up and can be restored normally, but the file space name or file name might be displayed with a combination of invalid characters or blank spaces.

If the file space name is Unicode-enabled, Tivoli Storage Manager converts the name to the server code page for display. The success of the conversion depends on the operating system, the characters in the name, and the server code page. Conversion can be incomplete if the string includes characters that are not available in the server code page or if the server cannot access system conversion routines. If the conversion is incomplete, the name might contain question marks, blanks, unprintable characters, or ellipses (...).

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 1. Commands related to QUERY RESTORE
Command	Description
CANCEL RESTORE	Cancels a restartable restore session.