Teradata Database versions prior to 14.00 - 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
  • If Online Logging is requested on a table that is involved in a load operation (by FastLoad or MultLload), Teradata ARC displays the following DBS warning message:

    *** Warning 9136: Online archive logging cannot be enabled on one or more tables.

    Error code 9136 is returned by the DBS for one of the following conditions:

    • The table is a MultiLoad or FastLoad target table that was aborted in the apply phase
    • The table is an aborted multiload work table

      When Teradata ARC receives the 9136 error code, Online Logging is not enabled on the table and when Teradata ARC attempts to archive the table, the table will be skipped.

      Although the table is skipped, the table header will still be archived but no data is archived. When the table is restored from the archive file, only the table header is restored, resulting in an empty table after the restore or copy operation.

  • If Online Logging is requested for a table that is already enabled for logging, the Teradata Database will return an error and Teradata Archive/Recovery Utility will abort. An exception is when the NOSYNC option has been specified. In this case, the error will be ignored and the archive job will continue.
  • If the Teradata ARC user does not have the DUMP access right (or permission) on the table to be enabled for ONLINE ARCHIVE, Teradata ARC will display an error message and the Teradata Archive/Recovery Utility will abort. If the NOSYNC option is specified, the error will be ignored and the archive job will continue.
  • If the table we are trying to enable Online Logging on has a lock on it, Teradata ARC will be blocked. Teradata ARC will be blocked on that lock until it is freed up and Teradata ARC can obtain it.