ANALYZE - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

The ANALYZE statement reads an archive tape and displays information about its content.

 

where:

 

Syntax Element

Description

ALL *

Analyzes all databases in the archive file

CATALOG

Generates/rebuilds the CATALOG table in the CATALOG database

See CATALOG in Chapter 4: “Runtime Parameters”.

(dbname)

Name of the database to analyze

(dbname1) TO (dbname2)

List of alphabetically client databases

The delimiting database names need not identify actual databases. Database DBC is not included as part of the range.

DISPLAY

Displays information about the identified databases

FILE

Analyzes a file

LONG

Displays the names of all objects within the specified databases

name

Name of the archive data set to analyze

VALIDATE

Reads each archive record for the specified database to check that each block on the file can be read

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.