Adding or Editing a Teradata System - BAR - Data Stream Architecture - Follow these steps to enable a preconfigured repository backup system and configure and enable the target database system.

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
16.20
Published
November 2019
Language
English (United States)
Last Update
2019-11-27
dita:mapPath
xfr1514490991957.ditamap
dita:ditavalPath
3150_DSA_UG_1650-working-RR-new.ditaval
dita:id
B035-3150
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 Advanced 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 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. 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. 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. Do one of the following:
    Add a new target system
    1. Click "" next to Systems.
    2. Select Add Teradata System.
    Edit an existing system Select the name under Systems.
  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.
    System Selector [Optional] When editing a system, to change the system selector, click Update. The credentials to the system are verified before the update can occur.
    You must stop and start DSMain in the database after changing the system selector.
    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 Advanced SQL Engine 16.20 or later / Teradata Database 16.0 or later. The -d parameter only starts and stops the ActiveMQ connection. It will not affect any feature that requires DSMain to be completed restarted; for example GDO flag 553 (EnableBackupsforIncrementalRestore).
    3. Enter start bardsmain (this starts DSMain).
    4. [Advanced SQL 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.