ActionsTbl | Teradata Vantage - ActionsTbl - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

The results of AnalyzeSP appear in TDMaps.ActionsTbl, with one row for every table that was analyzed for optimal map use. Tables are either marked as ALTER (meaning that Teradata recommends assigning the table to a new map) or EXCLUDE (meaning that the table is already assigned to a suitable map or does not meet the criteria for map reassignment). If DBQL step logging was considered in the analysis, tables are grouped by recommended proximity. Without DBQL input, tables are grouped by database. Within each grouping, the order is based on table size.

Teradata recommends that tables are assigned to the smallest sparse map possible. If the table is too large for a sparse map, Teradata recommends that the table is assigned to a contiguous map. ActionsTbl also describes issues that may prevent recommended map reassignments from occurring.

To examine the Advisor results, query ActionsTbl. For example:

SELECT Action, DatabaseName, TableName, GroupOrder
FROM TDMaps.ActionsTbl
WHERE ActionListName = 'MyMoveTableList'
ORDER BY 1, 4, 3, 2;

Result:

Action	   DatabaseName  TableName               GroupOrder
Alter         db2           JoinTab1                   1
Alter         db2           JoinTab2                   1
Alter         db2           OtherTab                   2
Alter         db1           LargeTab                   3
Alter         db1           MediumTab                  3
Exclude       db1           TinyTab                 NULL
Exclude       db2           SmallTab                NULL
Exclude       db3           SmallToMediumTab        NULL