16.10 - ActionHistoryV[X] - 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)
Database
TDMaps

This view contains the following columns:

View Column Data Type Format Source Table.Column
ZoneName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionHistoryTbl.ZoneName
JobNumber INTEGER -(10)9 ActionHistoryTbl.JobNumber
JobStartTime TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z ActionHistoryTbl.JobStartTime
Action VARCHAR(24) LATIN

NOT CASESPECIFIC

X(24) ActionHistoryTbl.Action
Status VARCHAR(24) LATIN

NOT CASESPECIFIC

X(24) ActionHistoryTbl.Status
DatabaseName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionHistoryTbl.DatabaseName
TableName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionHistoryTbl.TableName
GroupOrder DECIMAL(10,2) zz9.99 ActionHistoryTbl.GroupOrder
SourceMap VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionHistoryTbl.SourceMap
DestinationMap VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionHistoryTbl.DestinationMap
ActionSQLText VARCHAR(10000) UNICODE

NOT CASESPECIFIC

X(10000) ActionHistoryTbl.ActionSQLText
ActionListName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionHistoryTbl.ActionListName
TableSize BIGINT -(19)9 ActionHistoryTbl.TableSize
FractionOfPermDBFree FLOAT -9.99999999999999E-999 ActionHistoryTbl.FractionOfPermDBFree
Issues CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1) ActionHistoryTbl.Issues
PrevGroupsBytesPerSec DECIMAL(38,6) --(32).9(6) ActionHistoryTbl.PrevGroupsBytesPerSec
EstElapsedTimeInSecond DECIMAL(38,6) --(32).9(6) ActionHistoryTbl.EstElapsedTimeInSecond
ElapsedTime DECIMAL(38,6) --(32).9(6) ActionHistoryTbl.ElapsedTime
StartTime TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z ActionHistoryTbl.StartTime
EndTime TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z ActionHistoryTbl.EndTime
ErrorCode INTEGER --,---,---,--9 ActionHistoryTbl.ErrorCode
RunUID BYTE(4) X(8) ActionHistoryTbl.RunUID
ActionsTblDescription VARCHAR(1024) UNICODE

NOT CASESPECIFIC

X(1024) ActionHistoryTbl.ActionsTblDescription
Description VARCHAR(1024) UNICODE

NOT CASESPECIFIC

X(1024) ActionHistoryTbl.Description
WorkerId INTEGER -(10)9 ActionHistoryTbl.WorkerId
HostId INTEGER -(10)9 ActionHistoryTbl.HostId
SessionId INTEGER -(10)9 ActionHistoryTbl.SessionId