Set Up Event Table | Teradata Data Mover - 17.11 - Setting Up the Event Table - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
  1. Run the create_event_table command in the command-line interface using parameters in the table below:
    Parameter Example Value Description
    event_table_name event1 Label that uniquely identifies the installation of the Event table.
    system tdsys1 Name of the Teradata system where the Event table will be installed. This can be the IP address or system alias.
    user_name dmuser1 Existing Teradata user for the Teradata system. User creates the Event table and inserts the events. Data Mover stores the user information. User must have CREATE and INSERT permissions on the specified event_database.
    user_password dmuser1pass Password for the Teradata user associated with the user_name.
    event_database db1 Name of the database on the Teradata server where the Event table is created.
    use_existing_event_table false 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:
    datamove create_event_table -event_table_name event1 -system dmdev
    -user_name user1 -user_password user1Pass -event_database db1

    In the example above, Data Mover creates table db1.TMSMEvent on the Teradata database system dmdev using Teradata user user1. This installation is referred to as event1.

    The create_event_table command creates a table called TMSMEvent in the specified event_database. If the table already exists in the specified database and its schema is current, Data Mover re-uses the table. If no table exists, Data Mover creates a new one.