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


where:

CATALOG
CTLG
Enables CATALOG at the table level for ARCHIVE, RESTORE/COPY and/or ANALYZE statements
CATALOGALLTABLES
CTLGALL
Synonyms for CATALOG
CATALOGOBJONLY
CTLGOBJ
Enables CATALOG at the object level for ARCHIVE, RESTORE/COPY and/or ANALYZE statements
CATALOGFILE
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
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
NOCTLG
Disables CATALOG for ARCHIVE, RESTORE/COPY and/or ANALYZE statements.
CATALOGFILENAME
CTLGFILE
Enables changing the file name for the catalog.
NOCATALOGFILE
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