Query Backupset

The query backupset command queries a backup set from a local file, tape device (if applicable), or the IBM Spectrum Protect server.

This command displays the backup set name, generation date, retention (for a backup set on the IBM Spectrum Protect server), and user-supplied description.

Supported Clients

This command is valid for all clients.

Oracle Solaris operating systemsAIX operating systemsTape support is only available on AIX® and Oracle Solaris clients.

Syntax

Read syntax diagramSkip visual syntax diagramQuery BACKUPSEToptionsBACKUPSETName=backupsetnamelocalfilenametapedeviceLOCation=serverfiletape

Parameters

BACKUPSETName=
Specifies the name of a backup set you want to query. You can use wildcards to specify the backup set name. If you use wildcards or do not specify a backup set name, all backup sets that you own are displayed. This parameter is required.

Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsWhen a backup set is created, the server assigns root as the owner of the backup set. When querying a backup set on the server, a non-root user does not see the backup set listed, even if they know the backup set name and use it in the query.

The value of backupsetname depends on the location of the backup set, and corresponds to one of these three choices:

backupsetname
Specifies the name of the backup set from the server. If the location parameter is specified, you must set -location=server.
localfilename
Specifies the file name of the first backup set volume. You must set -location=file.
tapedevice
Specifies the name of the tape device that contains the backup set volume. You must use a Windows native device driver, not the device driver that is provided by IBM. You must set -location=tape.
LOCation=
Specifies where the backup-archive client searches for the backup set. If you do not specify the location parameter, the client searches for backup sets on the IBM Spectrum Protect server.
server
Specifies that the client searches for the backup set from the server. This location is the default.
file
Specifies that the client searches for the backup set from a local file.
tape
Specifies that the client searches for the backup set from a local tape device.
Table 1. Query Backupset command: Related options
Option Where to use
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsdescription Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsCommand line only.
Windows operating systemsdescription Windows operating systemsCommand line only.
Windows operating systemsscrolllines Windows operating systemsClient options file (dsm.opt) or command line.
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsscrolllines Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsClient user-options file (dsm.opt) or command line.
Windows operating systemsscrollprompt Windows operating systemsClient options file (dsm.opt) or command line.
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsscrollprompt Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsClient user-options file (dsm.opt) or command line.

Examples

Task
Query all backup sets from the IBM Spectrum Protect server.

Command: query backupset -backupsetname=*

Task
Query a backup set that is called monthy_financial_data from the IBM Spectrum Protect server.

Command: query backupset -backupsetname=monthly_financial_data.12345678

Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsTask
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsQuery the backup set in the file /home/budget/weekly_budget_data.ost.

Command: dsmc query backupset -backupsetname="/home/budget/weekly_budget_data.ost" -loc=file

Windows operating systemsTask
Windows operating systemsQuery the backup set in the filec:\budget\weekly_budget_data.ost.

Command: query backupset -backupsetname=c:\budget\weekly_budget_data.ost loc=file

Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsTask
Mac OS X operating systemsOracle Solaris operating systemsLinux operating systemsAIX operating systemsQuery the backup set from the /dev/rmt0 tape device.

Command: dsmc query backupset -backupsetname=/dev/rmt0 -loc=tape

Windows operating systemsTask
Windows operating systemsQuery the backup set from the \\.\tape0 tape device.

Command: dsmc query backupset -backupsetname=\\.\tape0 -loc=tape