Analyze - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

A CATALOG table can be generated offline using an ANALYZE statement that contains the CATALOG keyword, however, the ANALYZE statement does not recognize CATALOG specified as a runtime parameter. Tapes are scanned and the CATALOG rows are inserted into the CATALOG table for the database header records and the table header records in the tape set. After the CATALOG table is generated, it can be used in restore/copy operations.

Specifying CATALOG as a keyword in an ANALYZE statement is useful when a subset of objects must be restored or copied from a recataloged table set multiple times. However, for one-time operations, use a RESTORE or COPY statement without specifying CATALOG as a runtime parameter; catalog generation using an ANALYZE statement requires scanning the entire tape set anyway.