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.