KEEP LOGGING Keyword - 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

The KEEP LOGGING keyword overrides automatic termination of:

  • an ALL AMPs online archive that was initiated with the ONLINE option
  • a cluster online archive that was initiated with LOGGING ONLINE ARCHIVE ON

When KEEP LOGGING is used, the online archive process continues after the archive process completes. Changed rows continue to be logged into the change log. Use this keyword with caution: online logging continues until it is terminated manually with LOGGING ONLINE ARCHIVE OFF. If online logging is not terminated, there is a possibility that the logs could fill all available perm space.

If any table is still enabled for Online Logging either after the archive is finished or due to a graceful abnormal termination of Teradata ARC, a warning message appears that indicates one or more tables are still enabled for online logging. For more details, see section Archiving Online.