16.20 - 访问 Data Mover 命令行帮助 - Teradata Data Mover

Teradata® Data Mover 用户指南

Product
Teradata Data Mover
Release Number
16.20
Published
2021 年 11 月
Content Type
用户指南
Publication ID
B035-4101-107K-CHS
Language
中文 (简体)

您可以查看 Data Mover 命令行界面中所有可用命令的列表和简短说明,并显示这些命令的基本语法结构。

您还可以指定命令名称以查看有关该命令的更详细信息,包括语法示例以及与该命令关联的参数的列表和针对每个参数的说明。

  1. 在命令行中键入 datamove --help,并执行以下操作之一:
    选项 说明
    查看所有命令
    • Enter 键可查看所有命令的列表和简短说明。
    查看特定命令
    • 添加特定命令名称以查看有关特定命令的信息,包括其参数的列表。
    • Enter 键。

例如,要了解有关 create 命令的信息,请键入 datamove --help create 并按 Enter 键。将显示以下内容:

Data Mover Command Line 16.20.12.00
Connected to Daemon version 16.20.12.00
NAME:
create - Create Command
DESCRIPTION:
Creates a job on the DM Daemon based on the information from the arguments and the parameter file
EXAMPLE:
datamove create -job_name job1 -f parameters.xml
Parameters:
Parameter                       Example         Description
job_name                        job1            (optional)Name for the job, must be unique. Generated if unspecified
job_priority                    MEDIUM          (optional)Execution priority for job. HIGH/MEDIUM/LOW. Default is MEDIUM.
source_tdpid                    Checks          Source Teradata database
source_user                     TD_API_user     (optional)Source Teradata logon id
source_password                 123456789       (optional)Source Teradata logon password
source_logon_mechanism          NTLM            (optional)Mechanism to use when logging onto source system
source_logon_mechanism_data     joe@domain1     (optional)Additional parameters for the logon mechanism being used
source_account_id               account_id      (optional)Source Teradata logon account ID
target_tdpid                    Leo             Target Teradata database
target_user                     TD_API_user     (optional)Target Teradata logon id
target_password                 123456789       (optional)Target Teradata logon password
target_logon_mechanism          NTLM            (optional)Mechanism to use when logging onto target system
target_logon_mechanism_data     joe@domain1     (optional)Additional parameters for the logon mechanism being used
target_account_id               account_id      (optional)Target Teradata logon account ID
data_streams                    4               (optional)Number of data streams to use
source_sessions                 4               (optional)Number of session on the source
target_sessions                 4               (optional)Number of session on the target
max_agents_per_task             4               (optional)Max number of agents to use in parallel for each table/database/journal being moved
overwrite_existing_objects      true            (optional)Overwrites objects that already exist on the target
force_utility                   arc             (optional)Force DM to use a specific utility for all DM operations
log_level                       2               (optional)Log level to output a log file
online_archive                  true            (optional)Allows read/write access to the source tables while the tables are being copied
table                           DB1.TABLE       (optional)Table to be copied
response_timeout                60              (optional)Amount of time to wait for Daemon response in seconds
uowid                           uowid           (optional) Unit of work id to identify the job execution.
security_username               dmcl_admin      (optional) User ID of the super user. Only used if security management is enabled.
security_password               53cUr17y        (optional) Password for the super user. Only used if security management is enabled.
security_password_encrypted     052c7aabd1..    (optional) Encrypted password for the super user. Only used if security management is enabled.
query_band                      AppName=B;      (optional) QueryBand passed to the Database as a list of name=value pairs in a string.
source_hadoop_webhcat_url       http://sdll9119.labs.teradata.com:50111 (required) source hadoop system webcat url.
source_hadoop_oozie_url         http://tdh021m1.labs.teradata.com:11000 (required) source hadoop system oozie url.
source_hadoop_file_system_url   http://tdh021m2.labs.teradata.com:50070    (optional) source hadoop system file system url.
source_hive_user                hive            (required) hadoop hive user.
source_hive_password            hive            (required) hive user password.
source_hive_password_encrypted                  (optional) encrypted source hadoop system password.
source_hadoop_logon_mechanism   kerberos        (optional) source hadoop system security logon mechanism.
target_hadoop_webhcat_url       http://sdll9119.labs.teradata.com:50111 (required) target hadoop system webcat url.
target_hadoop_oozie_url http://tdh021m1.labs.teradata.com:11000 (required) target hadoop system oozie url.
target_hadoop_file_system_url   http://tdh021m2.labs.teradata.com:50070 (optional) target hadoop system file system url.
target_hive_user                hive            (required) target hadoop hive user.
target_hive_password            hive            (optional) target hadoop system user password.
target_hive_password_encrypted                  (optional) encrypted target hadoop system password.
target_hadoop_logon_mechanism   kerberos        (optional) target hadoop system security logon mechanism.
hadoop_file_option              rc              (optional) hadoop file transfer type.
hadoop_file_delimiter                           (optional) hadoop record delimiter.
hadoop_transfer_method          batch_insert    (optional) hadoop transfer method.
hadoop_transfer_batch_size      10              (optional) hadoop batch transfer size.
hadoop_number_mappers           1               (optional) number of hadoop mappers.
source_aster_system_name        10.25.32.100    (required) source aster system name.
source_aster_port               2406            (optional) port number for source aster system.
source_aster_user_name          beehive         (required) source aster system user name.
source_aster_user_password      beehive         (optional) source aster system user password.
source_aster_user_password_encrypted            (optional) source system encrypted user password.
target_aster_system_name        10.25.32.100     (required) target aster system name.
target_aster_port               2406            (optional) port number for target aster system.
target_aster_user_name          beehive         (required) target aster system user name.
target_aster_user_password      beehive         (optional) target aster system user password.
target_aster_user_password_encrypted            (optional) target system encrypted user password.
aster_query_timeout             60              (optional) aster query timeout duration.
aster_preserve_column_case      no              (optional) aster need to preserve column case.
aster_skip_error_records        no              (optional) aster needs to skip error records.
netrace                         21              (optional) cli netrace parameter value.
netrace_buf_len                 0               (optional) cli netrace_buf_len parameter value.
tpt_debug                       1               (optional) tptapi trace debug parameter value.
additional_arc_parameters       VBMASK=15       (optional) Specifies the additional ARC parameters that will be appended when executing each ARC task.
source_staging_database         db1             (optional) source staging database name
target_staging_database         db1             (optional) target staging database name
target_database                 db1             (optional) target database name
db_client_encryption            true            (optional) set if job need to encrypted during data transfer.