Purpose
The create_event_table command creates a table called TMSMEvent in the specified database.
Parameters
- event_table_name
- Label that uniquely identifies the installation of the Event table.
- system
- Name of the Teradata system where the Event table will be installed. 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.
- 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.
- security_password
- [Optional] Password for the super user or authorized Viewpoint user.
- security_password_encrypted
- [Optional] Encrypted password for the super user.
- event_database
- Name of the database on the Teradata server where the Event table is created.
- 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.
- 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.
- 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.
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>