Add an Advanced SQL Engine | Teradata Viewpoint - Adding an Advanced SQL Engine - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Add an Advanced SQL Engine to the Monitored System portlet to begin collecting data. Your system may be set up for you. Follow these steps if your Advanced SQL Engine is not set up.
  1. Next to Systems, select "", then select Add Teradata System.
  2. Under General System Details, enter a system nickname, up to 30 characters.
  3. [Optional] Select the Enable system check box.
    After it is enabled, the system starts collecting data.
  4. Enter the TDPID of the Advanced SQL Engine if not shown.
  5. [Optional] Enter the site ID assigned by Teradata Customer Services.
    After enabling a system, the Site ID becomes read-only if Viewpoint detects a value for the system.
    A site ID is required when using Elastic Performance on Demand.
  6. Enter a login name and password.
    Specify an account string and authentication, add more logons, test the logon settings, and grant access to an Advanced SQL Engine. Add any logins used for Viewpoint data collection to the system-level bypass. To define system-level bypass settings, use the Workload Designer portlet.
  7. [Optional] Click Test to verify that the login settings are correct.
    If the operation is successful, "" appears. If the operation fails, "" appears. If you receive an error, verify that the login credentials are valid and the host can be reached.
  8. [Optional] Under Authentication Options, specify which authentication mechanisms are available in the portlets.
  9. [Optional] Under Character Set, select default character sets and enter a JDBC Flag value:
    • Select a character set from the Session list.
    • Select a character set from the Monitor list.
    • Enter a JDBC Flag value.
  10. Under Time Zone, select the time zone the system uses to log DBQL and ResUsage data.
  11. [Optional] Under Collectors, select Enable Data Collectors (Configure in Data Collectors) to begin collecting data.
    The data collectors can be enabled and configured individually in Data Collectors.
    Portlet Data Collectors
    Elastic Performance Elastic Limit and Elastic Usage
    TVS Monitor Virtual Storage
    Stats Manager Stats Manager
    Query Log Query Log data collectors for historical DBQL data
  12. [Optional] Under Enhanced TASM Functions, select Enable this option if your Teradata has license entitlement to TASM.
    The workload management features are available with your TASM license on SLES11 or higher.
  13. Select Apply.
    If the operation is successful, "" appears. If the operation fails, "" appears. If you receive an error, verify that the settings are correct and try again.