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 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.