Event Monitor

toms1981

Is anyone create an event monitor before?
I have created an event which will monitor on the statements and it's work fine for me.
But I couldn't see the value for those dynamic sql as it's only display ?
Anyone know how to get the value also???
Kindly pls advise.

coolalibaba

英语说不好就说中文好吧，这里不是老外论坛

psc2001

step
create event monitor
set state=1
flush event monitor
set state=0
db2evmon > file

attention: when your system runs many sql statements,please be careful  if the filesytem can put the so large file .(my system run event monitor for statements can create 2GB file log an hour)

toms1981

Belows are the steps to create an event monitor:

   1. Go to your RUN and enter db2cmd
   2. Connect to your database in the command prompt
          * db2 "connect to <DB NAME>"
   3. Create an event monitor, you may put any name for the <EVENT NAME>
          * db2 "create event monitor <EVENT NAME> for statements write to table"
   4. Turn on the monitor
          * db2 "set event monitor <EVENT NAME> state=1"
   5. Run any of your program or application which you want to monitor on the SQL.
   6. Turn off the monitor
          * db2 "set event monitor <EVENT NAME> state=0"
   7. View the executed SQL statement
          * db2 "select stmt_text from <SCHEMA NAME>.STMT_<EVENT NAME> order by sql_req_id"
   8. Terminate the connection
          * db2 "terminate"

This is how I did for the event monitor but I'm able to get the static and dynamic SQL but for dynamic SQL not able to get the value.

toms1981

原帖由 coolalibaba 于 2007-11-16 10:40 发表
英语说不好就说中文好吧，这里不是老外论坛

I'm from Malaysia where I don't know the term in Chinese therefore I forced to write in English.
Sorry about that...

coolalibaba

OK. no problem then. I misunderstood your question. I didn't hear there is any way to display the "?" in the event log or snapshot.

原帖由 toms1981 于 2007-11-21 18:51 发表


I'm from Malaysia where I don't know the term in Chinese therefore I forced to write in English.
Sorry about that...

whiterain

Belows are the steps to create an event monitor:

   1. Go to your RUN and enter db2cmd
   2. Connect to your database in the command prompt
          * db2 "connect to <DB NAME>"
   3. Create an event monitor, you may put any name for the <EVENT NAME>
          * db2 "create event monitor <EVENT NAME> for statements write to table"
   4. Turn on the monitor
          * db2 "set event monitor <EVENT NAME> state=1"
   5. Run any of your program or application which you want to monitor on the SQL.
   6. Turn off the monitor
          * db2 "set event monitor <EVENT NAME> state=0"
   7. View the executed SQL statement
          * db2 "select stmt_text from <SCHEMA NAME>.STMT_<EVENT NAME> order by sql_req_id"
   8. Terminate the connection
          * db2 "terminate"

This is how I did for the event monitor but I'm able to get the static and dynamic SQL but for dynamic SQL not able to get the value.

your function is right.i will have a test.if i have result,i will tell you,my msn : white_liu@hotmail.com