Add a Teradata System - Adding the Teradata System - BAR - Data Stream Architecture

Teradata® DSA Quick Start Guide

Product
BAR
Data Stream Architecture
Release Number
17.05
Published
September 2020
Language
English (United States)
Last Update
2021-04-02
dita:mapPath
dba1599061168676.ditamap
dita:ditavalPath
gvl1576617752141.ditaval
dita:id
B035-3156
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
Prerequisite Before you can work with the DSC in the BAR Setup portlet, you must add and enable the Teradata System and the Dictionary collector in the Monitored Systems portlet. Under Setup select Data Collectors and enable the Dictionary collector.

If you are upgrading to SQL Engine 16.20 or later or Teradata Database 16.0 or later, run DIPBAR on the Teradata system before this procedure.

Follow these steps to configure and enable the target database system.
  • Nodes are configured through autodiscovery. You can view but not edit them.
  • [DSA 17.02 and later] There is no longer a preconfigured backup system, you just need to enable the Teradata system.
  1. Open the BAR Setup portlet.
  2. Under DSC Servers, select your DSC server.
  3. From the Categories list, select Systems and Nodes.
  4. Add the target system:
    1. Click "" next to Systems.
    2. Select Add Teradata System.
  5. Under Setup, select System Details and enter the following:
    Option Description
    System Name [Adding a new system] Choose the system from the drop-down list.
    Make a system available from the Monitored Systems portlet.
    SSL Communication [Optional] Select the Enable SSL over JMS Communication checkbox to enable SSL communication.
    You must add the TrustStore password created during SSL setup. You must stop and start DSMain in the database after enabling SSL communication.
    Default Stream Limits For Nodes Set the default limits for each node configured with the system.
    • For each node: maximum number of concurrent streams allowed per node. For example, 5 times the number of AMPs on the node.
    • For each job on a node: maximum number of concurrent streams allowed for each job on the node. Cannot exceed the number of AMPs on the node. If you enter a higher number, it is reduced to the number of AMPs on the node.
  6. Click Apply and enter the database credentials.
  7. Under Setup select Nodes to view the details for the nodes on this system.
  8. Restart DSMain on the destination system:
    1. From the primary distribution node (usually Node 1), run cnsterm 6.
    2. Enter start bardsmain –s -d dsc_name (this stops DSMain on the destination system).
      The -d dsc_name parameter applies to SQL Engine 16.20 or later / Teradata Database 16.10 or later.
    3. Enter start bardsmain (this starts DSMain).
    4. [SQL Engine 16.20 or later / Teradata Database 16.10 or later] Enter start bardsmain -j (this shows the status of the connections).
    The system is automatically enabled.