16.10 - Usage Notes - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Rows in the ActionHistoryV[X] views represent map related actions that are currently running or have completed. The ActionHistoryTbl is updated by the mover procedure. After the mover takes an action from the ActionsTbl, it inserts a row into ActionHistoryTbl and sets its status to In Progress. After the action completes, the mover updates the status to Complete. These views are security zone constrained. ActionHistoryVX returns only the objects to which the user has access.

ActionListName

ActionListName contains a named list of actions of which this action is a member. See related Advisor procedure parameter OutputActionList and Mover procedure parameter TableActionList.

ActionSQLText

The SQL text of the DDL statement executed to perform this action.

ActionsTblDescription

Comment providing further information for the action in ActionsTbl.

DatabaseName

Database to which the action applied.

Description

Additional information describing the completed or failed action.

ErrorCode

Teradata Database error code if a failure occurs. If there is no error, ErrorCode is zero or NULL.

EstElapsedTimeInSecond and ElapsedTime

EstElapsedTimeInSecond is the estimated elapsed time for executing the action. ElapsedTime is the actual elapsed time it took to execute the action.

FractionOfPermDBFree

The fraction of free permanent space the table takes in the database. ALTER TABLE MAP takes twice the space during the operation, and this value indicates the fraction of free space that will be used.

GroupOrder

GroupOrder is a common identifier of the group in which this action is a member.

JobNumber

An optional job number recorded by the mover procedures.

PrevGroupsBytesPerSec

PrevGroupsBytesPerSec indicates how many bytes per second were processed in the previous group of tables.

SourceMap and DestinationMap

SourceMap is the current map of the table prior to performing the recommended action. DestinationMap is the target map used to perform the specified action.

RunUID

User who executed this action.

TableName

Table, join index, or hash index on which the action applied.

TableSize

TableSize is the approximate size of table in bytes after the action completed.

ZoneName

The name of the zone associated with the object (DatabaseName, TableName).

HostId, SessionId, and WorkerId

The HostId is the host ID of the worker that wrote the row. The SessionId is the session ID of the worker that wrote the row.

The WorkerId is the ID of the worker that wrote the row:

Value Description
0 0 is the value of WorkerId for a serial move.
1 and above 1 and above indicates the number of parallel workers for a parallel move.

Possible Values for Action

Type of action to perform on the table.

Value Description
Alter Move existing table data to new destination map.

For example, use the ALTER statement to change the Action:

ALTER {TABLE | JOIN INDEX | HASH INDEX} <TableName>
MAP = <DestinationMap> [COLOCATE USING [<ColocateName>];
Exclude Do not perform any action on this table for the specified destination map.

Possible Values for Issues

Value Description
Y Y indicates there are issues with this action. For details about what the issues are, see the ActionsTblDescription column.
N N indicates there are no issues.

Possible Values for Status

Type of action to perform on the table.

Value Description
Aborted The action was aborted by a restart or abort.
Complete The action was successfully completed.
InProgress The action is currently running, was aborted, or a database restart occurred during the move.
Failed The action failed. See related column ErrorCode for details.
Stopped An already queued action was stopped prior to executing.
Skipped The action was skipped and not started because its estimated elapsed time was greater than the time remaining in the caller’s specified TimeLimit. If TableName is non-NULL, the individual table was skipped. If Tablename is NULL and GroupOrder is non-NULL, all of the tables within the specified group were skipped.