create_event_table | Commands | Teradata Data Mover - 17.10 - create_event_table - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)

Purpose

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

Parameters

See Parameter Order.

dm.rest.endpoint
[Optional] Enter a Data Mover REST server URL to overwrite the default value specified in the commandline.properties file in order to connect to a different REST server (and therefore a different daemon) at runtime.
https://dm-server1:1443/datamover
event_database
Name of the database on the Teradata server to create the event table.
Example: db1
event_table_name
A unique label for the particular TMSMEvent table instance with a maximum of 128 characters. This label is used when performing an action, such as modifying or deleting an event table.
Example: event1
security_password
[Optional] Password for the super user or authorized Viewpoint user.
Example: 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.
Example: 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 to install the event table. This can be the IP address or system alias.
Example: 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.
Example: dmuser1
user_password
Password for the Teradata user associated with the user_name.
Example: 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.
Example: false

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 create_event_table command.
<?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>