modify_event_table

Teradata Data Mover User Guide

brand
Analytical Ecosystem
prodname
Teradata Data Mover
vrm_release
16.10
category
User Guide
featnum
B035-4101-067K

Purpose

The modify_event_table command enables you to change the Teradata user name and password for an existing Event table.

Parameters

See Parameter Order.

broker.port
[Optional] You may enter a broker port to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.
61616
broker.url
[Optional] You may enter a broker URL to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.
dm-server1
change_user_name
Determines whether or not the user name is changed.
true
change_user_password
Determines whether or not the user password is changed.
event_table_name
Label that uniquely identifies the installation of the Event table.
event1
security_password
[Optional] Password for the super user or authorized Viewpoint user.
53cUr17y
Required if security management is enabled on the Data Mover daemon. Not a valid parameter if -security_password_encrypted is also specified.
security_password_encrypted
[Optional] Encrypted password for the super user.
052c7aabd14c7770141ac3c0137ab98ae0d3f0f7cddf588981206b010c0c1b2f
Required if security management is enabled on the Data Mover daemon. Not a valid parameter if -security_password is also specified.
security_username
[Optional] User ID of the super user or authorized Viewpoint user. The user ID of the super user is dmcl_admin and cannot be changed.
Required if security management is enabled on the Data Mover daemon.
user_name
Existing Teradata user name for Data Mover to use to access the Event table. The user requires INSERT permission for the TMSMEvent table..
dmuser1
user_password
Password for the Teradata user associated with the user_name.
dmuser1pass

Usage Notes

XML File Example

For the create_event_table command, type datamove create_event_table -f parameters.xml.

The following example is a parameters file for the modify_event_table command.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmModifyEventTable 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">
 <event_table_name>eventTable1</event_table_name>
 <change_user_name>true</change_user_name>
 <user_name>tduser2</user_name>
 <change_user_password>true</change_user_password>
 <user_password>tdpass2</user_password>
</dmModifyEventTable>