Skipping a Stat Collection - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

The SKIP STAT COLLECTION option has been added to the archive/restore/copy statements. The purpose of the SKIP STAT COLLECTION option is to skip the Stat Collection handling in those respective statements. For archive, it removes the logic to read and archive the DDL for recreating the Stat Collections. For restore/copy, it removes the logic to recreate the Stat Collections after restoring/copying the table data for the associated object.

When SKIP STAT COLLECTION is specified, the user must revert to the manual handling of Stat Collections that existed prior to Teradata Tools and Utilities 14.00. The user must manually make a copy of the Stat Collection DDL from the source system. After the table data has been restored/copied to the target system, the user must manually recreate the Stat Collections by re-executing the Stat Collection DDLs that were saved from the source system.

When specifying the SKIP STAT COLLECTION option:

  • If specified on archive, then the archive file will not have any Stat Collection information.
  • If specified on restore, then no Stat Collection information should restore.
  • If specified on copy, then no Stat Collection information should copy.
  • The following are examples of archive, restore, and copy scripts setting the SKIP STAT COLLECTION option. If you want arcmain to automatically archive/restore/copy the Stat Collection information, which is the default behavior, remove the line that designates SKIP STAT COLLECTION for the cases where it is not needed or desired.