Query Backup and Query Object Commands - Tivoli

Teradata Extension for Tivoli Storage Manager Administrator Guide

Product
Tivoli
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2019-03-22
dita:mapPath
beb1489436039198.ditamap
dita:ditavalPath
beb1489436039198.ditaval
dita:id
wkq1486409855180
Product Category
Teradata Tools and Utilities

The QUERY BACKUP and QUERY OBJECT commands print a formatted report about Teradata objects in storage that match an identified search pattern. The syntax is shown below.

QUERY OBJECTshows one record per storage object whereas the QUERY BACKUP command aggregates totals to have one record per Teradata backup generation.
QueRY BAckup  namepattern [ gen ][ formatstring ]
QueRY OBJect  namepattern [ gen ][ segnamepattern ][ formatstring ]

The node name context is established at session logon. Tivoli API limitations cause case-sensitive matching on the name patterns.

The optional gen field filters output to specific backup file generations. The default value of zero for the gen field restricts output to only the most recent generation of a backup. An asterisk (*) character in the gen field qualifies for all versions of the qualified backups. Relative generation numbers, such as -1 for the second-to-last most recent backup, can also be indicated.

The segname pattern refers to a segment number (F0000 through F9999). An asterisk (*) character in the segname pattern field returns all segments for a given object.

For example, QRY OBJ span* 2 *1 returns segment F0001 for generation 2 of all objects matching the span pattern.

If a format string is not specified in the command, the current default determined from the FORMAT command line option is used. For further explanation on format strings, see Format Specifiers.