Usage Notes - 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

The ANALYZE statement provides the following information about the specified databases:

  • Time and date the archive operation occurred.
  • Whether the archive is of all AMPs, clusters of AMPs, or specific AMPs.
  • The name of each database, the name of each object in each database, and the fallback status of the tables (if the LONG option is specified).
  • The number of bytes and rows in each table (if the LONG or VALIDATE option is specified).
  • If an archive file contains a selected partition archive of a table, the bounding condition used to select the archived partitions is displayed with an indication as to whether the bounding condition is well-defined.
  • Online logging information.
  • User-Defined Method (UDM) and User-Defined Type (UDT) information.
  • If the archive file contains Stat Collection DDL, the DDL can be displayed by specifying the DISPLAY LONG option.

The DISPLAY and VALIDATE options can both be specified in a single ANALYZE statement. The default is DISPLAY.