Query Backupset

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

This command displays the backup set name, generation date, retention (for a backup set on the IBM Storage 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.

Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X 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 Storage 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
Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsdescription Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X 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.
Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsscrolllines Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsClient user-options file (dsm.opt) or command line.
Windows operating systemsscrollprompt Windows operating systemsClient options file (dsm.opt) or command line.
Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsscrollprompt Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsClient user-options file (dsm.opt) or command line.

Examples

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

Command: query backupset -backupsetname=*

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

Command: query backupset -backupsetname=monthly_financial_data.12345678

Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsTask
Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X 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

Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X operating
systemsTask
Linux operating systemsOracle Solaris operating
systemsAIX operating systemsMac OS X 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