在使用配置了 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_dsainputs 和 dsa_configsys 脚本位于 /opt/teradata/datamover/support 目录下。
- 从 DSC 主机运行 hostname -i 以验证是否可以从 TPA 节点访问解析的 IP。
- 在以下服务器之一上运行 build_dsainputs,具体取决于使用的 DSA 配置:
DSA 配置 服务器 捆绑 DSA Data Mover 服务器 外部 DSA 外部 DSC 服务器 将 build_dsainputs 脚本复制到外部 DSC 服务器并从那里运行。该脚本可以复制到任何目录并从任何目录运行。
- 配置源系统和目标系统,然后使用 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.