Analyze - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
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.