Regd Mail Alert needed for DB2 DML statements on my Data Base -- Need inputs

Hi,

Why on earth do you need mail alert on DML statements ?

A simple batch program that updates your database will flood your mailbox.
I suggest you look at the audit and/or performance monitoring procedures instead depending
on your requirements.

Monitor procedures that you can use
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/c0053963.html

Regards,
     Tomas Helgi

Hi All

If I use MON_GET_TABLE table function , does this affect  the performance of my Application or Data Base ?


https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0053945.html

No, the performance impact on the database is minimal compared to the impact of the applications.

Regards,
  Tomas Helgi

Hi All

I am extracting the data with below function.  I read in IBM documentation as it will extract the metrics since DB activation.

MON_GET_TABLE table function

Is there any way that I can get the metrics on daily basis,

Hi,

Take a look at this Developerworks article. It explains how you can use the MON_GET_TABLE function or any other monitor functions found in the links I provided in my earlier comment.
By collecting the performance data in a separate schema or database as shown in this article and using a script (cron script on unix/powershell on windows) on a daily basis you can easily calculate using SQL the daily delta of the metrics you are collecting and put it in one report mailed to you on a daily basis. :)  

Regards,
      Tomas Helgi