Data collectors gather information from different sources and make the data available to Teradata Viewpoint portlets.
Database Data Collectors
| 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 using the AMP Load (ampload) utility. 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. Only enable this collector for Teradata systems leveraging Elastic Performance On Demand. |
|
| Elastic Usage | Collects the overall node CPU usage from the DBC.ResUsageSPMA table. Only enable this collector for Teradata systems leveraging Elastic Performance On Demand. |
|
| Lock Info | 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 more information, see Lock Info Collector. |
|
| Query Count | Database query count and query log data are collected by querying the DBC.DBQLogTbl and DBC.DBQLSummaryTbl tables. Query logging in the database must be enabled for a query to be counted. For more information, see Query Count Collector. |
|
| Query Log | 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 make sure 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 database. You can set this rate in the Monitored Systems portlet by selecting Monitor Rates from the Setup list. |
|
| Sessions | Collects snapshots of 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 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 system configuration data used by portlets and collectors. The collector retrieves the database version from DBC.DBCInfo. This information is critical to provide 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. 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 system memory at a configurable sample rate. Collecting system statistics data more frequently than the resource sample rate in database results in duplicate data being collected and wasted resource usage on the 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 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 database from the TDWM database in Teradata. The TASM Config collector needs to be enabled to use Workload Designer for a new Teradata system. If the collector is not enabled, the TDWM version information is not collected, and the Teradata system does not appear in the list of available Teradata 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 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. 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 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 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 Machine Learning Engine Collectors
| Teradata Machine Learning Engine Collector | Description | Portlets Using Data |
|---|---|---|
| Cluster Status | Collects cluster status and information about Teradata Machine Learning Engine queen and workers. |
|
| Component Stats | Collects statistics on Teradata Machine Learning Engine queen and workers such as CPU, disk I/O, net I/O, and memory use. |
|
| Pods | Collects detailed information, including storage and 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. |
|
| System Config | Collects the site ID and system version. |
|
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 | (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 | (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 QueryGrid Data Collectors
| Teradata QueryGrid Data Collector | Description | Portlets Using Data |
|---|---|---|
| Issues | (Teradata QueryGrid™ 16.10 and later) Collects Teradata QueryGrid™ issues. |
|
| Queries | Collects information about queries run on a Teradata QueryGrid system. |
|
| System Config | (Teradata QueryGrid™ 16.10 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. |
|