Adding the Teradata System - BAR - Data Stream Architecture

Teradata® DSA Quick Start Guide

Product
BAR
Data Stream Architecture
Release Number
16.20
Published
June 2019
Language
English (United States)
Last Update
2019-06-28
dita:mapPath
sfj1538433118070.ditamap
dita:ditavalPath
3156_DSA_QS_1620.ditaval
dita:id
B035-3156
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
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 NewSQL 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 enable the preconfigured repository backup system and to configure and enable the target database system.
Nodes are configured through autodiscovery. You can view but not edit them.
  1. Open the BAR Setup portlet.
  2. Under DSC Servers, select your DSC server.
  3. From the Categories list, select Systems and Nodes.
  4. [Optional] Enable the preconfigured repository backup system.
    1. Under Systems, select the preconfigured DSC repository system, dscnameRepository.
    2. Under System Details, under System, select Update.
    3. Enter the database credentials and select OK.
    4. If repository system is SSL enabled, select Enable SSL over JMS Communication then Apply.
  5. [Optional] Using the following commands, restart DSMain on the repository system:
    1. From the DSC server, run cnsterm 6.
    2. Enter start bardsmain –s (this stops DSMain on the repository system).
    3. Enter start bardsmain (this starts DSMain).
    4. Use the break command to get out of cnsterm.
    The system is automatically enabled.
  6. Add the target system:
    1. Click next to Systems.
    2. Select Add Teradata System.
  7. 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.
  8. Click Apply and enter the database credentials.
  9. Under Setup select Nodes to view the details for the nodes on this system.
  10. 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 NewSQL Engine 16.20 or later / Teradata Database 16.0 or later.
    3. Enter start bardsmain (this starts DSMain).
    4. [NewSQL Engine 16.20 or later / Teradata Database 16.0 or later] Enter start bardsmain -j (this shows the status of the connections).
    The system is automatically enabled.