ActionHistoryV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: TDMaps

Database: TDMaps

View Column Data Type Format Comment
ZoneName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Zone name
JobNumber INTEGER -(10)9 Job number specified by user calling ManageMoveTablesSP, which is optional
JobStartTime TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Starting time of Mover Manager
Action VARCHAR(24) LATIN NOT CASESPECIFIC X(24) Type of action to perform on the table
Status VARCHAR(24) LATIN NOT CASESPECIFIC X(24) Current status of the action
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Database on which the action applies
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Table on which the action applies
GroupOrder DECIMAL(18,2) --Z(15)9.99 Priority rank of an action within its group. Applicable only for rows whose Action value is 'Alter'
SourceMap VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The map of the table prior to performing the action
DestinationMap VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The target map used to perform the action
ActionSQLText VARCHAR(10000) UNICODE NOT CASESPECIFIC X(10000) The SQL text of the DDL statement that would perform this action
ActionListName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Named list of actions of which this action is a member of
TableSize BIGINT -(19)9 Approximate size of table in bytes
FractionOfPermDBFree FLOAT -9.99999999999999E-999 Fraction of PERM DB free
Issues CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) 'Y' or 'N'. If 'Y', it indicates there is something that administrator may want to check
PrevGroupsBytesPerSec DECIMAL(38,6) --(32).9(6) Previous Group bytes per second
EstElapsedTimeInSecond DECIMAL(38,6) --(32).9(6) Estimated elapsed time for executing action
ElapsedTime DECIMAL(38,6) --(32).9(6) Actual elapsed time for executing action
StartTime TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Action start timestamp
EndTime TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Action end timestamp
ErrorCode INTEGER --,---,---,--9 DBS Error code if failure occurred. Otherwise, zero or NULL
RunUID BYTE(4) X(8) User who executed this action
ActionsTblDescription VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) Advisor generated comment providing further explanation for the recommended action
Description VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) Additional info describing the completed or failed action
WorkerId INTEGER -(10)9 The ID of the worker who performs action on the table. 0 for serial worker. 1,2... for parallel workers
HostId INTEGER -(10)9 Host Id of the worker who performs action on the table
SessionId INTEGER -(10)9 Session Id of the worker who performs action on the table