17.11 - 配置源系统和目标系统 - Teradata Data Mover

Teradata® Data Mover 安装、配置和升级指南(适用于客户)

Product
Teradata Data Mover
Release Number
17.11
Published
2021 年 10 月
Content Type
安装
管理
配置
Publication ID
B035-4102-091K-CHS
Language
中文 (简体)
Last Update
2021-11-08
在使用配置了 DSA 的 Data Mover 时,请使用 dsa_configsys 工具配置源 Teradata 系统和目标 Teradata 系统。如果在该配置中提供了 -h-u 选项,则 dsa_configsys 会在源系统和目标系统上重新启动 DSMAIN。如果未提供 -h-u 选项,则必须在使用 DSA 之前,使用 cnsterm 手动重新启动 DSMAIN。
配置源系统和目标系统时必须考虑以下情况:
  • DSC 主机必须解析为在源系统和目标系统上每个 TPA 节点都可以访问的 IP。
  • 每个 TPA 节点必须解析同一系统上所有节点的 COP 条目。
  • 使用 -u 选项指定的用户必须是“root”或拥有 sudo 访问权限的用户,才能运行 Teradata cnsterm 实用程序。
  • 必须使用 -t 选项指定 TDPID。
build_dsainputsdsa_configsys 脚本位于 /opt/teradata/datamover/support 目录下。
  1. 从 DSC 主机运行 hostname -i 以验证是否可以从 TPA 节点访问解析的 IP。
  2. 在以下服务器之一上运行 build_dsainputs,具体取决于使用的 DSA 配置:
    DSA 配置 服务器
    捆绑 DSA Data Mover 服务器
    外部 DSA 外部 DSC 服务器

    build_dsainputs 脚本复制到外部 DSC 服务器并从那里运行。该脚本可以复制到任何目录并从任何目录运行。

  3. 配置源系统和目标系统,然后使用 dsa_configsys 重新启动 DSMAIN。
    以下示例使用 dsa_configsys 来配置 TDPID sdt05126 并重新启动 DSMAIN:
    # ./dsa_configsys -t sdt05126 -p dbc -h sdt05126 -u root
    {"validationlist":null,"status":"CONFIG_TERADATA_SYSTEM_SUCCESSFUL","systemName":"sdt05126","tdpId":"sdt05126","valid":true,"links":[]}
    sdt05126 successfully configured.
    ---------------------------------------------------------------------------------
    Preparing to stop/start DSMain.
    
    There may be a delay of 30 seconds or more after each operation.
    
    PLEASE ALLOW BOTH OPERATIONS TO COMPLETE.
    
    If prompted .. please enter the password for user root on sdt05126:
    
     _______
        |                                |              |
        |    ___     __     ____         |    ____    __|__    ____
        |   /      |/  \    ____|    ____|    ____|     |      ____|
        |   ---    |       /    |   /    |   /    |     |     /    |
        |   \___   |       \____|   \____|   \____|     |__   \____|
     
        Release 15.10.03.05 Version 15.10.03.05
        DSA DSMain Utility
     
    
        This program is used to start or stop DSMain    
    
     
        **  DSMain is not running  **
    
    
     _______
        |                                |              |
        |    ___     __     ____         |    ____    __|__    ____
        |   /      |/  \    ____|    ____|    ____|     |      ____|
        |   ---    |       /    |   /    |   /    |     |     /    |
        |   \___   |       \____|   \____|   \____|     |__   \____|
    
        Release 15.10.03.05 Version 15.10.03.05
        DSA DSMain Utility
     
        This program is used to start or stop DSMain    
    
        DSMain started.    
    
    ---------------------------------------------------------------------------------
    
    Restart of DSMain Complete.
    
    Verifying that sdt05126 has registered with ActiveMQ .. please wait.
    
    sdt05126 has been successfully configured and has registered with ActiveMQ.
    要检查系统是否已配置 DSA,请使用 -t 以及 -p 选项和 --verify 选项。
    以下示例显示了在未提供任何参数时显示的 dsa_configsys 用法信息:
    ---------------------------------------------------------------------------------
    dsa_configsys                                                                   
    
    Usage: dsa_configsys -t <TDPID> [-U <db_user>] -p <db_user password> [--verify] [ -h <host>  -u <linux userid> [-i <identity_file>] ] | -?
    
    Description:
       This script will configure a TD system for DSA (similar to the 'dsc 
       config_systems' command). After the TD system is configured DSMain must be 
        re-started on the system. This script will restart DSMain if the -h 
        option is specified.
    
       Run this script locally on the DSC server for which the TD systems are 
       being configured.
    
       -t The TDPID of the system to configure. The TDPID must exactly match the 
          definition from the Data Mover <source_tdpid> and <target_tdpid> job XML. 
          For example: if the <source_tdpid> in the job XML is 
          prodsys.labs.td.com then it must be specified as prodsys.labs.td.com
          for this option.
    
       -U (Optional) Use this option to specify a user other than 'dbc'. This user 
          must have adequate permission for DB 'sysbar' to replace a macro (TD 
          version < 16.00) or insert a row in table sysbar.dsaconnectionstbl 
          (TD version >= 16.00).
    
       -p Password for user 'dbc' on the system specified above with the -t 
          option. Optionally, the -U option can be added to specify a different 
          user. Password must be enclosed by single quotes.
    
       --verify (Optional) Use this option along with -t and -p to check whether a 
                system has been configured in DSA. If the system is configured 
                then no additional configuration is needed with dsa_configsys.
    
       -h (Optional) If the user specifies the -h option followed by the TD system 
          host (SMP) or one of the TD system hosts (MPP) then dsa_configsys will 
          ssh into that host to restart DSMain (stop/start).
    
       -u Required when using the -h option, specify a user that has sudo 
          permissions to run TD cnsterm commands on the host (e.g. root, ec2-user, 
          azureuser).
    
       -i (Optional) Specify an identity file that includes the private key.
    
          Examples:
             ./dsa_configsys -t devsys -p dbc -h devsys -u root
             Configure SMP system 'devsys' and restart DSMain.
    
             ./dsa_configsys -t prodsys.labs.td.com -p dbc -h prodsys1 -i 
             my_identityfile -u ec2-user
             Configure MPP system 'prodsys' and restart DSMain. Note that 
             'prodsys1' resolves to the first node of the MPP system.
    
             ./dsa_configsys -t prodsys -p dbc --verify
             Check if 'prodsys' has been configured in DSA.
    
       -? Displays usage help.