create_event_table - Teradata Data Mover

Purpose

The create_event_table command creates a table called TMSMEvent in the specified database.

Syntax

See http://schemas.teradata.com/unity/DataMover.xsd.

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

event_database

Name of the database on the Teradata server where the Event table is created.

db1

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.

system

Name of the Teradata system where the Event table will be installed. This can be the IP address or system alias.

tdsys1

user_name

Existing Teradata user for the Teradata system. This user creates the Event table and inserts events into it. Data Mover stores the user information. The user must have CREATE and INSERT permissions on the specified event_database.

dmuser1

user_password

Password for the Teradata user associated with the user_name.

dmuser1

use_existing_event_table

If an Event table already exists and this is set to true, Data Mover re-uses the existing table rather than create a new one.

false

XML File Example

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

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmCreateEventTable 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>
	<system>tdsys1</system>
	<user_name>tduser</user_name>
	<user_password>tdpass</user_password>
	<event_database>eventdb</event_database>
	<use_existing_event_table>false</use_existing_event_table>
</dmCreateEventTable>