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

Teradata® Data Mover 用户指南

Product
Teradata Data Mover
Release Number
17.20
Published
2022 年 9 月
Language
中文 (简体)
Last Update
2022-10-12
dita:mapPath
zh-CN/tsn1650877444606.ditamap
dita:ditavalPath
zh-CN/mpm1591127278842.ditaval
dita:id
B035-4101
Product Category
Analytical Ecosystem

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

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

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

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

Data Mover Command Line 17.06.00.00
Connected to Daemon version 17.06.00.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			        dsa             (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.
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.
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.