Purpose
The create_event_table command creates a table called TMSMEvent in the specified database.
Syntax
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.
- event_database
- Name of the database on the Teradata server to create the event table.
- 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.
- security_password
- [Optional] Password for the super user or authorized Viewpoint user.
- security_password_encrypted
- [Optional] Encrypted password for the super user.
- 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.
- system
- Name of the Teradata system to install the event table. This can be the IP address or system alias.
- 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.
- user_password
- Password for the Teradata user associated with the user_name.
- 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.
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>