Data Mover Event Logging

UDA

Data Mover Event Logging

According to the manual Teradata Unity Data Mover - User Guide 14.10  (B035-4101-053K July 2013) p67

one can configure data mover to log events to an event table as well as to UEM

  What is the structure (Show table) of this table?

The manual doesn't say (not that I can find) as with data mover not yet installed I have no way of knowing what it would look like

Tags (3)
1 REPLY
N/A

Re: Data Mover Event Logging

Once you have DM installed, In datamover setup/ daemon setup there is an option to add event table logging.

Choose a database and apply and the below table will be created there.

Rglass

CREATE SET TABLE TMSMEVENT ,FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT,

DEFAULT MERGEBLOCKRATIO

(

ResourceId CHAR(72) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

ResourceType CHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

TDPID CHAR(72) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

UOWId CHAR(72) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

EventType CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

EventTS TIMESTAMP(6) NOT NULL,

EventDate DATE FORMAT 'YY/MM/DD',

CreatedTS TIMESTAMP(6) NOT NULL,

EventMsg VARCHAR(200) CHARACTER SET LATIN NOT CASESPECIFIC,

UOWHealthAmt FLOAT,

UOWHealthStr VARCHAR(500) CHARACTER SET LATIN NOT CASESPECIFIC,

AlertCode INTEGER,

SeverityLvl INTEGER NOT NULL,

EventSourceSystem CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

EventSourceUser CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

JobName VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

JobStep VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,

EventDML CHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

Optional1 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

Optional2 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

Optional3 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

StateCode INTEGER,

ApplicationId CHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,

AffectedDatabaseName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC,

AffectedTableName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC,

LogFile VARCHAR(500) CHARACTER SET LATIN NOT CASESPECIFIC,

UOWClass VARCHAR(72) CHARACTER SET LATIN NOT CASESPECIFIC,

UOWName CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

UOWDesc VARCHAR(200) CHARACTER SET LATIN NOT CASESPECIFIC,

UOWTS TIMESTAMP(6),

UOWFromTS TIMESTAMP(6),

UOWDate DATE FORMAT 'YY/MM/DD',

UOWSourceSystem CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

ModifiedTS TIMESTAMP(6),

MDA_VERSION INTEGER NOT NULL DEFAULT 101 )

PRIMARY INDEX Inversion_Entry_1 ( ResourceId ,ResourceType ,TDPID ,

UOWId ,EventType ,EventTS ,EventDML );