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


where:

CATALOG or CTLG
Enables CATALOG at the table level for ARCHIVE, RESTORE/COPY and/or ANALYZE statements
CATALOGALLTABLES or CTLGALL
Synonyms for CATALOG
CATALOGOBJONLY or CTLGOBJ
Enables CATALOG at the object level for ARCHIVE, RESTORE/COPY and/or ANALYZE statements
CATALOGFILE or CTLGFILE
Enables CATALOG to write all catalog information to a file on the client machine.
The default file name for the catalog is 'CATALOG' on mainframe systems, and 'CATALOG_<uen>.CTG' on other systems, where <uen> is the Utility Event Number for the archive job.
OLDCATALOG or OLDCTLG
When specified, along with CATALOG, enables use of the multi-table implementation of CATALOG, instead of the single-table method which does not create a new table for each ARCHIVE.
NOCATALOG or NOCTLG
Disables CATALOG for ARCHIVE, RESTORE/COPY and/or ANALYZE statements.
CATALOGFILENAME or CTLGFILE
Enables changing the file name for the catalog.
NOCATALOGFILE or NOCTLGFILE
Disables CATALOGFILE so that catalog information is not created during ARCHIVE, and not used during RESTORE or COPY.

The following syntax is not supported:

  • CATALOGALL
  • CTLGALLTABLES
  • CATALOGOBJ
  • CTLGOBJONLY