Recording Row Activity - TARA/ABU

Field

Description

Standard Fields

Event Number

A unique integer value assigned by the Teradata Database to each recorded event

Teradata Archive/Recovery Utility assigns event numbers in ascending order. For example, events that occur earlier in time have smaller numbers. The event number (not the date and time stamp) is the most accurate way to determine the chronology of events.

Date and Time

The value of the Teradata Database time‑of‑day clock when the event is recorded

Earlier events can have later time stamps than later events. Therefore, do not use this value to determine the chronology of checkpoint events. Instead, use event numbers.

User Name

Logon ID for the user who initiated the event

Event Type

A text string identifying the event

The event types are:

Database Name

The name of the database affected by the activity

If multiple databases are affected, a row is recorded for each database.

Object Type

A single character that defines the type of object involved

The character values and their meanings are:

Total database

Data table

Journal table

Object Identifier

A four byte field containing either a database ID or the uniqueness portion of a table identifier

This field further defines the object involved in the event. These fields are derived from the DBASE and TVM dictionary tables and are maintained by the Teradata Database.

All-AMPs Flag

The value “A” means the following:

Restart Count

If the event is restarted and the online AMP configuration has changed, this column increases by one.

If the event was completed without a configuration change, this field contains a zero.

Operation in Progress

This field contains a Y when the Teradata ARC operation specified is not complete.

Operations that terminate abnormally and are not restarted are left with Y. When the specified Teradata ARC operation completes, this field contains an N.

Optional Fields

Dataset Name

The client file name specified for an archive or recovery activity

Table Name

The table name specified for an archive or recovery activity

Contains one row for each table affected unless all tables are affected

If all rows are affected, BTEQ shows a question mark. This indicates a NULL field.

Checkpoint Name

The label given to the checkpoint

Linking Event Number

The number assigned to some other event that influenced the current event

The termination point for a rollback is a linking event number.

Journal Used

A single character indicating which journal table the event used:

Current journal table

Restored portion of the journal table

Saved portion of the journal table

Journal Saved

Y or N to indicate that the CHECKPOINT statement did (or did not) contain the SAVE option

Index Present

Y or N to indicate whether the archive included the index option

Dup Archive Set

Y or N to indicate if this is a duplicate file created by an archive request

If two files are created by a single archive request, two event rows are generated. One has the flag set to Y to indicate that it is a duplicate. The other has a value of N to indicate that it is the primary copy.

Lock Mode

A single character to identify the HUT lock that is applied by an archive operation:

The operation executed under either an access lock or a group read lock.

The operation executed under a read lock.