Alert on DML Queries

Viewpoint
Teradata Employee

Alert on DML Queries

Dear Member

is there any mechanism/utility by which we can trigger an ALERT immediately via email or anything whenever a DML query is fired on any specific databases

3 REPLIES
Senior Apprentice

Re: Alert on DML Queries

There are no database level triggers.

If it's not neccessarily "immediatle" you might run a job extracting that info from the Access Log every few minutes.

Dieter

Enthusiast

Re: Alert on DML Queries

Hi ,

I have a qry . in that join is taking more time . its showing 10 m in plan. 

one of the join column is skewed with one value.

can u pls help me how can we make that join faster.

SELECT

COL1,

COL2,

TRIM(COL3) COL3,

FROM TABLE A

LEFT JOIN

(

SELECT

COL1,

COL2,

CAST(COL3 AS VARCHAR(50)) COL3

FROM TABLE B

)   TEST

ON TABLE A.COL3  =  TABLE B.COL3

TABLEA.COL3 IS SKEWED 

pls help me to solve this.

Thanks,

Suresh.

Teradata Employee

Re: Alert on DML Queries

You can fire such an alert quite easily using TASM.  Create an ALERT only Filter and add classifications (Query Characteristics: Only DML statements & Target: Include XXX Databases)