Adding a NewSQL Engine - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
1.1
Published
July 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
qyu1559916244734.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4014
lifecycle
previous
Product Category
Analytical Ecosystem
Software
Teradata Vantage
Add a 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. From the Viewpoint portal page, select "".
  2. Open the Monitored Systems portlet.
  3. Next to Systems, select , then select Add Teradata System.
  4. Under General System Details, enter a system nickname, up to 30 characters.
  5. [Optional] Select the Enable system check box. After it is enabled, the system starts collecting data.
  6. Enter the TDPID of the Advanced SQL Engine if not shown.
  7. [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.
  8. Enter a login name and password. Specify an account string and authentication, add more logons, test the logon settings, and grant access to a 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.
  9. [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.
  10. [Optional] Under Authentication Options, specify which authentication mechanisms are available in the portlets.
  11. [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.
  12. Under Time Zone, select the time zone the system uses to log DBQL and ResUsage data.
  13. [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
  14. [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 in SLES 11.
  15. 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.