Query Backupset

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

This command displays the backup set name, generation date, retention (for a backup set on a Tivoli Storage Manager server), and user-supplied description.

AIX operating systemsHP-UX operating systemsLinux operating systemsOracle Solaris operating systemsMac OS X operating systemsWindows operating systems

Supported Clients

This command is valid for all clients.

AIX operating systemsHP-UX operating systemsOracle Solaris operating systemsTape support is only available on AIX®, Solaris, and HP-UX.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-Query BACKUPSET--+---------+--BACKUPSETName=----------------->
                    '-options-'                   

>--+-backupsetname-+--+-----------------------+----------------><
   +-localfilename-+  '-LOCation=--+-server-+-'   
   '-tapedevice----'               +-file---+     
                                   '-tape---'     

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.

AIX operating systemsHP-UX operating systemsLinux operating systemsOracle Solaris 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 Tivoli Storage Manager 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 Tivoli. You must set -location=tape.
LOCation=
Specifies where Tivoli Storage Manager searches for the backup set. If you do not specify the location parameter, the client searches for backup sets on the Tivoli Storage Manager server.
server
Specifies that Tivoli Storage Manager searches for the backup set from the server. This location is the default.
file
Specifies that Tivoli Storage Manager searches for the backup set from a local file.
tape
Specifies that Tivoli Storage Manager searches for the backup set from a local tape device.
Table 1. Query Backupset command: Related options
Option Where to use
AIX operating systemsHP-UX operating systemsLinux operating systemsOracle Solaris operating systemsMac OS X operating systemsdescription AIX operating systemsHP-UX operating systemsLinux operating systemsOracle Solaris 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.
AIX operating systemsHP-UX operating systemsLinux operating systemsMac OS X operating systemsOracle Solaris operating systemsscrolllines AIX operating systemsHP-UX operating systemsLinux operating systemsMac OS X operating systemsOracle Solaris operating systemsClient user-options file (dsm.opt) or command line.
Windows operating systemsscrollprompt Windows operating systemsClient options file (dsm.opt) or command line.
AIX operating systemsHP-UX operating systemsLinux operating systemsMac OS X operating systemsOracle Solaris operating systemsscrollprompt AIX operating systemsHP-UX operating systemsLinux operating systemsMac OS X operating systemsOracle Solaris operating systemsClient user-options file (dsm.opt) or command line.

Examples

Task
Query all backup sets from the Tivoli Storage Manager server.

Command: query backupset -backupsetname=*

Task
Query a backup set that is called monthy_financial_data from the Tivoli Storage Manager server.

Command: query backupset -backupsetname=monthly_financial_data.12345678

AIX operating systemsHP-UX operating systemsLinux operating systemsMac OS X operating systemsOracle Solaris operating systemsTask
AIX operating systemsHP-UX operating systemsLinux operating systemsMac OS X operating systemsOracle Solaris 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

AIX operating systemsHP-UX operating systemsLinux operating systemsOracle Solaris operating systemsMac OS X operating systemsTask
AIX operating systemsHP-UX operating systemsLinux operating systemsOracle Solaris 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