Consumption for Vantage Settings | Teradata Vantage - Consumption for Vantage Settings - Teradata Vantage on AWS

Teradata Vantageā„¢ on AWS Getting Started Guide

Product
Teradata Vantage on AWS
Release Number
2.3
Published
March 2022
Language
English (United States)
Last Update
2022-03-02
dita:mapPath
nol1623083013042.ditamap
dita:ditavalPath
kfh1623083985300.ditaval
dita:id
B700-4015
Product Category
Cloud

To enable Consumption usage metering, Teradata installs certain settings on the Advanced SQL Engine.

Changing these settings impacts collection and billing processes. Do not change the following settings for any reason without the knowledge and consent of the Teradata Operations team.
Setting Description
Resource Usage (ResUsage) Collects system-wide usage data to monitor resource levels so Teradata can perform necessary capacity planning activities on a Consumption system.
Database Query Logging (DBQL) Captures query/statement counts and response times. DBQL provides a series of predefined tables and views that store historical records of queries and their duration, performance, and target activities based on logging rules you specify.
User-defined logging rules must include UTILITYINFO and FEATUREINFO options, while excluding SUMMARY and THRESHOLD options.
Performance Data Collection Reporting (PDCR) Collects and reports Consumption data.
  • Enables new user VCMUSER, with SELECT grant access, to see the following views:
    • pdcrinfo.vcm_tables
    • PDCRINFO.VCM_MLEQueryLog
    • PDCRINFO.VCM_MLEResUsageCpu
    • pdcrinfo.vcm_table_cds_hst
    • pdcrinfo.vcm_sb_system_cds_hst
    • pdcrinfo.vcm_dbqlogtbl_hst
    • pdcrinfo.vcm_dbqlutilitytbl_hst
    • pdcrinfo.vcm_dbqlsummarytbl_hst
    • pdcrinfo.vcm_resusagespma
  • Uses a macro to collect Vantage Unit usage data.
Viewpoint Portlets Aggregates and consolidates Consumption telemetry and system health data. Infrastructure alerts monitor system capacity thresholds for the following portlets:
  • Data Mover
  • QueryGrid
  • Monitored Systems
  • Performance Data Collection1
  • Workload Management

1 Teradata is not responsible for updating credentials in this portlet if you change the PDCRAdmin password.