save_configuration - 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

用途

save_configuration 命令可使用 -f 参数将配置文件(由 list_configuration 命令创建)中的信息保存到 Data Mover 守护程序中。

参数

请参阅参数顺序

dm.rest.endpoint
[可选] 输入 Data Mover REST 服务器 URL 以覆盖 commandline.properties 文件中指定的缺省值,以便在运行时连接到不同的 REST 服务器(进而连接到不同的守护程序)。
https://dm-server1:1443/datamover
filename.xml
配置 XML 文件的名称。
示例: configuration.xml
配置文件的缺省名称为 configuration.xml
security_password
[可选] 超级用户或授权 Viewpoint 用户的密码。
示例: 53cUr17y
如果 Data Mover 守护程序上已启用安全管理功能,则必须提供此参数。如果同时指定了 -security_password_encrypted,则此参数无效。
security_password_encrypted
[可选] 超级用户的加密密码。
示例: 052c7aabd14c7770141ac3c0137ab98ae0d3f0f7cddf588981206b010c0c1b2f
如果 Data Mover 守护程序上已启用安全管理功能,则必须提供此参数。如果同时指定了 -security_password,则此参数无效。
security_username
[可选] 超级用户或授权 Viewpoint 用户的用户 ID。超级用户的用户 ID 为 dmcl_admin 且不能更改。
如果 Data Mover 守护程序上已启用安全管理功能,则必须提供此参数。

XML 文件示例

对于 save_configuration 命令,请键入 datamove save_configuration -f configuration.xml

下面是在 save_configuration 命令中使用的示例 configuration.xml 文件。更新 configuration.xml 文件中的配置设置时,唯一可供编辑的区域是 <value> 元素所包含的数字或文本。<description> 元素中的文本仅提供附加信息。不要更改 key 元素所包含的文本。
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmSaveConfiguration xmlns="http://schemas.teradata.com/dataMover/v2009" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/unity/DataMover.xsd">
    <property>
        <key>agentCollector.agentHeartbeatWaitMillis</key>
        <value>600000</value>
        <description>Purpose: To set the amount of time to wait for an Agent heartbeat before assuming it has gone out of service in milliseconds. Default: 600000.</description>
    </property>
    <property>
        <key>databaseQueryService.useBaseViewsOnly</key>
        <value>true</value>
        <description>Purpose: Set all data dictionary queries on Teradata source and target systems to use the base views instead of X or VX views. Default: true.</description>
    </property>
    <property>
        <key>different.session.charsets.enabled</key>
        <value>false</value>
        <description>Purpose: Whether or not the different session charsets feature is supported. Default value false means not allowed.</description>
    </property>
    <property>
        <key>event.table.default</key>
        <value>NULL</value>
        <description>Purpose: Messages will be saved to this event table, unless the messages come from a different event table or the Job Definition explicitly overrides this parameter. Default: NULL.</description>
    </property>
    <property>
        <key>job.default.queryband</key>
        <value>ApplicationName=DM;Version=15.10;</value>
        <description>Purpose: Provide a set of name/value pairs for the default query_band feature.</description>
    </property>
    <property>
        <key>job.default.queryband.enabled</key>
        <value>false</value>
        <description>Purpose: Enable/Disable the default queryband feature. Default value: false</description>
    </property>
			<property>
        <key>job.databaseClientEncryption</key>
        <value>false</value>
        <description>Purpose: When set to true, utilities such as JDBC and TPTAPI will initiate encrypted sessions to both the source and target database systems. Default: false. Note: There is a performance hit trade-off for the gain of encryption.</description>
    </property>
			<property>
        <key>job.force.direction</key>
        <value>false</value>
        <description>Purpose: To force direction of data movement from source to target system.</description>
    </property>
    <property>
        <key>job.never.target.system</key>
        <value>false</value>
        <description>Purpose: Prevent certain database systems from ever being a target system in a Data Mover job. Default: false.</description>
    </property>
    <property>
        <key>job.noFallback</key>
        <value>false</value>
        <description>Configures whether the fallback settings on tables created as part of movement jobs are disabled. While this is enabled, fallback settings on target tables are scrubbed and disabled. When this is disabled, fallback settings will be set based on the source table. Default is false.</description>
    </property>
    <property>
        <key>job.onlineArchive</key>
        <value>false</value>
        <description>Purpose: When set to true, online archiving is utilized for objects that merit the use of DSA. Default: false. Note: There a is a performance hit trade-off for the gain of object availability.</description>
    </property>
    <property>
        <key>job.overwriteExistingObjects</key>
        <value>false</value>
        <description>Purpose: When set to true, objects that already exist on the target database system are overwritten. Default: false.</description>
    </property>
    <property>
        <key>job.useSecurityMgmt</key>
        <value>false</value>
        <description>Purpose: When set to true, some Data Mover commands will require the admin username and password to be specified when executing the command.  Refer to the User Guide for a complete list of commands affected by this parameter. Default: false</description>
    </property>
    <property>
        <key>job.useSyncService</key>
        <value>false</value>
        <description>Purpose: To record any changes to the Data Mover repository tables (inserts/updates/deletes) in an audit log table. The value must be set to true in order to use the Sync service. Default: false.</description>
    </property>
    <property>
        <key>job.useUserIdPool</key>
        <value>false</value>
        <description>Purpose: Use a target user from the pool of users. This enables running multiple DSA tasks at the same time.</description>
    </property>
    <property>
        <key>repository.purge.definition.enabled/key>
        <value>false</value>
        <description>Purpose: Enable/Disable the repository purge job definition feature. Default value: false.</description>
    </property>
    <property>
        <key>repository.purge.enabled</key>
        <value>true</value>
        <description>Purpose: Enable/Disable the repository purge feature.</description>
    </property>
    <property>
        <key>repository.purge.history.unit</key>
        <value>days</value>
        <description>Purpose: The unit for job history data to kept in the repository before purging should occur. The current supported values are days, weeks, months, and years. Default value: days.</description>
    </property>
    <property>
        <key>repository.purge.history.unitcount</key>
        <value>60</value>
        <description>Purpose: The number of units for job history data to kept in the repository before purging should occur. This value is combined with the value for repository.purge.history.unit to determine the amount of time before purging should occur for old jobs (for example, 60 days, 3 years, or 10 months). Default value: 60. The value of -1 will disable the purging by time.</description>
    </property>
    <property>
        <key>repository.purge.hour</key>
        <value>1</value>
        <description>Purpose: The hour when the daily repository purging should start. Default value 1 means 1am.</description>
    </property>
    <property>
        <key>repository.purge.minute</key>
        <value>0</value>
        <description>Purpose: The minute when the daily repository purging should start. Default value 0.</description>
    </property>
    <property>
        <key>repository.purge.percent</key>
        <value>50</value>
        <description>Purpose: The percentage of repository permspace that needs to be available to determine when purging should occur. Default value 50 means the repository should be purged when more than 50% of the available permspace is in use. The value of -1 will disable the purging by percentage.</description>
    </property>
    <property>
        <key>skip.FLML.tables</key>
        <value>true</value>
        <description>If enabled (true) and the table is being Fast/Multi Loaded, the daemon marks it as COMPLETED WITH WARNINGS. If disabled (false) and the table is being Fast/Multi Loaded, the daemon marks the table movement as FAILED. Default is false.</description>
    </property>
    <property>
        <key>system.default.database.enabled</key>
        <value>false</value>
        <description>Purpose: Enable/Disable the default target/staging databases at the system level. Default value false means disabled.</description>
    </property>
    <property>
        <key>target.system.load.slots</key>
        <value>5</value>
        <description>Purpose: Controls maximum number of load slots that Data Mover can use at one time on target Teradata systems. Default: 5.</description>
    </property>
    <property>
        <key>tmsm.frequency.bytes</key>
        <value>2147483647</value>
        <description>Purpose: Controls frequency of sending messages when using byte-based utilities (for example, TPTAPI). Default: 2147483647 bytes.</description>
    </property>
    <property>
        <key>tmsm.mode</key>
        <value>NONE</value>
        <description>Purpose: Controls how Data Mover directs messages. When set to BOTH, messages will be written to the TDI event tables. Default: NONE.</description>
    </property>
</dmSaveConfiguration>