QUERY RESTORE (Query restartable restore sessions)

Edit online

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

Privilege class

Any administrator can issue this command.

Syntax

Read syntax diagramSkip visual syntax diagramQueryRESTorenode_name file_space_nameFormat=StandardFormat=StandardDetailedNAMEType=SERVERNAMEType=SERVERUNIcodeFSID

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 IBM® Storage Protect 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, the name is converted 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.