16.10 - ActionsV[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) ActionsTbl.ZoneName
Action VARCHAR(24) LATIN

NOT CASESPECIFIC

NOT NULL

X(24) ActionsTbl.Action
Origin CHAR(1) LATIN

NOT CASESPECIFIC

X(1) ActionsTbl.Origin
DatabaseName VARCHAR(128) UNICODE

NOT CASESPECIFIC

NOT NULL

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

NOT CASESPECIFIC

NOT NULL

X(128) ActionsTbl.TableName
SourceMap VARCHAR(128) UNICODE

NOT CASESPECIFIC

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

NOT CASESPECIFIC

X(128) ActionsTbl.DestinationMap
CoLocateName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionsTbl.CoLocateName
ActionSQLText VARCHAR(10000) UNICODE

NOT CASESPECIFIC

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

NOT CASESPECIFIC

NOT NULL

X(128) ActionsTbl.ActionListName
GroupOrder DECIMAL(10,2) zz9.99 ActionsTbl.GroupOrder
ActionOrder DECIMAL(10,2) zz9.99 ActionsTbl.ActionOrder
TableSize BIGINT -(19)9 ActionsTbl.TableSize
FractionOfPermDBFree| FLOAT -9.99999999999999E-999 ActionsTbl.FractionOfPermDBFree
UDICnt BIGINT -(19)9 ActionsTbl.UDICnt
QueryCnt BIGINT -(19)9 ActionsTbl.QueryCnt
PKJoinCnt BIGINT -(19)9 ActionsTbl.PKJoinCnt
LastAlterTimeStamp TIMESTAMP(6) WITH TIME ZONE NOT NULL YYYY-MM-DDBHH:MI:SS.S(6)Z ActionsTbl.LastAlterTimeStamp
LastAlterUID BYTE(4)

NOT NULL

X(8) ActionsTbl.LastAlterUID
Issues CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1) ActionsTbl.Issues
ActionsTblDescription VARCHAR(1024) UNICODE

NOT CASESPECIFIC

X(1024) ActionsTbl.ActionsTblDescription