16.20 - Adding or Editing a Teradata System - Data Stream Utility

Teradata® DSA - DSU Installation, Configuration, and Upgrade Guide

prodname
BAR
Data Stream Architecture
Data Stream Utility
vrm_release
16.20
created_date
September 2019
category
Configuration
Installation
featnum
B035-3153-127K
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. 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 NewSQL 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. [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.