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

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

Product
Teradata Data Mover
Release Number
16.20
Published
2021 年 11 月
Language
中文 (简体)
Last Update
2021-12-02
dita:mapPath
zh-CN/pgy1512683352051.ditamap
dita:ditavalPath
zh-CN/stp1591127384938.ditaval
dita:id
B035-4102
Product Category
Analytical Ecosystem
在使用配置了 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。
  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 provided to specify a different user.
    
    --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.