Data collectors gather information from different sources and make the data available to Teradata Viewpoint portlets.
Teradata Database Data Collectors
Teradata Database Data Collector | Description | Portlets Using Data |
---|---|---|
Account Info | Queries the DBC.AccountInfo table in the database and collects a list of available account strings. The Queries portlets use this data to list the available account strings for the Change Priority function. The Workload Designer portlet uses this data to provide a list of available account strings when creating classification criteria. |
|
Alert Request |
|
|
AWT Info | Collects AMP worker task (AWT)-related information through the AMP Load (ampload) Teradata Database utility. For Teradata Database 14.0 or later, the collector executes the MONITOR AWT RESOURCE request of PM/API instead of AMP Load (ampload). If this collector is not enabled, the portlets do not display AWT information. The AWT Info collector is also required for alerts that depend on AWT information. |
|
Database Space | Queries the DBC.DataBaseSpace and DBC.DBase tables to collect database space usage metrics.
The Space Usage and Metric Heatmap portlets use the data collected by the Database Space collector. If this collector is not enabled, these portlets do not display current database space data. |
|
Dictionary | Collects and caches information from the Teradata Data Dictionary. If this collector is not enabled, the Query Group Setup and Workload Designer portlets do not display the most current usernames. The Dictionary collector is required to generate Database Space alerts. |
|
Disk Space | Obtains disk-space and database space usage data by querying the DBC.DiskSpace view of the DBC database. If this collector is not enabled, these portlets do not display the most current disk-space data. |
|
Collects the perm space data and skew percentage for the DBC.TransientJournal table. |
|
|
Elastic Limit | Collects the current system CPU limit set in the Schmon utility or Workload Designer portlet. This collector should be enabled only for Teradata Database systems leveraging Elastic Performance On Demand. |
|
Elastic Usage | Collects the overall node CPU usage from the DBC.ResUsageSPMA table. This collector should be enabled only for Teradata Database systems leveraging Elastic Performance On Demand. |
|
Lock Info | For Teradata Database 14.10 and later, this collector uses the data written to the DBC.DBQLXMLLockTbl table to capture lock information. For the Lock Info collector to run against Teradata Database 14.10 and later, DBQL query logging must be enabled with the WITH LOCK option. The Lock Viewer portlet displays updated lock data only for the period of time when the collector is enabled. For Teradata Database 14.0 and earlier, this collector uses the LockLogger database utility to capture a snapshot of lock information. For the Lock Info collector to run against Teradata Database14.0 and earlier, the LockLogger flag in DBSControl on the Teradata Database system must be set to TRUE. For more information, see Lock Info Collector. |
|
Query Count | Teradata Database query count and query log data are collected by querying the DBC.DBQLogTbl and DBC.DBQLSummaryTbl tables. Query logging in the Teradata Database must be enabled for a query to be counted. For more information, see Query Count Collector. |
|
Query Log | For Teradata Database 14.00 and later, collects DBQL data from the PDCRDATA.DBQLogTbl_Hst table. Up to 10 million rows of DBQL data is collected per day. When the number of DBQL rows exceeds 10 million, you can specify the name of a database view in the Monitored Systems portlet to load a subset of the query log data to ensure only the most important data is collected. |
|
Resource Usage | Collects node resource usage data from the DBC.ResUsageSPMA table and DBC.ResUsageIPMA table. Resource Usage collects vproc usage data from the DBC.ResUsageSVPR table. The recommended collection is the rate that this information is logged to these tables in the Teradata Database. You can set this rate in the Monitored Systems portlet by selecting Monitor Rates from the Setup list. |
|
Sessions | Collects snapshots of Teradata Database session data for each login from the Teradata Monitor partition by using the Teradata Performance Monitor API. For more information, see Sessions Collector. |
|
Stats Manager | Collects and retains statistic data used by Teradata Database system tables from the DBC.Dbase, DBC.TVM, DBC.Indexes, DBC.StatsTbl, TDStats.StatsTbl, TDStats.ObjectList, and TDStats.ExcludedTbl tables. |
|
System Config | Collects and retains Teradata Database system configuration data used by portlets and collectors. The collector retrieves the Teradata Database version from DBC.DBCInfo. This information is critical to ensure the proper functionality of several portlets and other data collectors. To gather physical system configuration data, the collector also uses the MONITOR PHYSICAL CONFIG request of the PM/API and executes STATUS PDE of the Vproc Manager console partition utility. This collector cannot be disabled. The sample rate and initial retention policy for this collector cannot be modified. For Teradata Database 14.0 or later, this collector does not call Vproc Manager console partition utility. |
|
System Stats | Collects system, node, and vproc statistics data by querying the Teradata Monitor partition using the PM/API. Physical and virtual resource statistics are collected from Teradata Database system memory at a configurable sample rate. Collecting system statistics data more frequently than the resource sample rate in Teradata Database results in duplicate data being collected and wasted resource usage on the Teradata Database. You can set this rate in the Monitored Systems portlet by selecting Monitor Rates from the Setup list. If this collector is not enabled, these portlets do not display system statistics data. The Workload Designer portlet uses node and vproc counts from this collector to assist with the creation of rulesets. The System Stats collector is required for system, node, vproc, and System Health alerting. |
|
Table Space | Collects and retains data about the space used by Teradata Database system tables from the DBC.Dbase, DBC.TVM, DBC.Indexes, and DBC.DataBaseSpace tables.
The Space Usage and Metric Heatmap portlets use the data collected by the Table Space collector. If this collector is not enabled, these portlets do not display the most current table space data. |
|
TASM Config | Obtains configuration information about the TDWM version and active ruleset in the Teradata Database from the TDWM database in Teradata. The TASM Config collector needs to be enabled to use Workload Designer for a new Teradata Database system. If the collector is not enabled, the TDWM version information is not collected, and the Teradata Database system does not appear in the list of available Teradata Database Systems in Workload Designer. |
|
TASM Distribution | Collects information about the average percentage of CPU consumption used by each workload for each node in the Teradata Database system. The TASM Distribution data collector executes schmon -M -p -P in the Teradata Console partition to collect information for the CPU Consumption graph in the Distribution view. For Teradata Database 14.0 and later, the collector executes the MONITOR WD request of PM/API instead of schmon. |
|
TASM Exception | Obtains TASM Exception data from the DBC.TDWMExceptionLog table. |
|
TASM State | Collects and retains system regulation data. You must enable both the TASM Config and TASM State collectors to be able to associate the active workload name with the session information displayed in these portlets. |
|
TASM Summary | Obtains data for each active workload in the Teradata Database. This collector sends queries to the Teradata Monitor partition using PM/API. |
|
Virtual Storage | Collects data on cylinder temperature and storage grade from space types managed by the Teradata Virtual Allocation Manager (TVAM) utility. This collector uses the GetTvsUdfViewpointSummary user-defined function, created by the Teradata Database DIP scripts, to collect this data. |
|
Teradata Aster Data Collectors
Teradata Aster Data Collector | Description | Portlets Using Data |
---|---|---|
Cluster Status | Collects cluster status and node status information for each node. |
|
Component Stats | Collects statistics for each node of the Teradata Aster system, such as CPU, disk I/O, net I/O, and memory use. |
|
Nodes | Collects detailed information for each node, including the node storage and node virtual worker information. |
|
Processes | Collects data about sessions logged into the system and processes. For active processes, detailed information about the statement and phases of the process is also collected. |
|
Rulesets | Collects the active ruleset information for the Teradata Aster system. |
|
Space Usage | Collects database, table, and node storage information. |
|
System Config | Collects the site ID and Aster Database version. |
|
Workloads | Collects workload policy and workload service class data. |
|
Teradata Hadoop Data Collectors
Teradata Hadoop Data Collector | Description | Portlets Using Data |
---|---|---|
HBase | Collects the number of region servers that are running and configured and the amount of time the master server has been running. |
|
HDFS | Collects the number of files and directories in HDFS, the space capacity not currently used by HDFS, datanode process information, and the amount of time a name node is running. |
|
MapReduce | For HDP 1.3, collects map and reduce jobs statistics, jobtracker information, the number of map slots occupied and reserved, the number of reduce slots occupied and reserved, and the number of tasktrackers running and configured. |
|
Services | Collects Hadoop services information. |
|
System Config | Collects the list of nodes that make up the Teradata Hadoop system and the site ID from the system. This data is used by portlets and other collectors, so this collector cannot be disabled or modified. |
|
System Stats | Collects system statistics data from Hadoop Services. |
|
YARN | For CDH and HDP 2.1 and later, collects YARN statistics, ResourceManager information, the amount of cluster memory allocated and reserved, the number of containers allocated and reserved, and the number of applications running and pending. |
|
Teradata Presto Data Collectors
Teradata Presto Data Collector | Description | Portlets Using Data |
---|---|---|
Queries | Collects information about queries run on a Teradata Presto system. |
|
Teradata QueryGrid Data Collectors
Teradata QueryGrid Data Collector | Description | Portlets Using Data |
---|---|---|
Issues | For Teradata QueryGrid 16.00 and later, collects Teradata QueryGrid issues. |
|
Queries | Collects information about queries run on a Teradata QueryGrid system. |
|
System Config | For Teradata QueryGrid 16.00 and later, collects and retains the latest snapshot of Teradata QueryGrid instances. This data is used by portlets and other collectors, so this collector cannot be disabled or modified. |
|