How to Find which SQL Statement is executing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Divakar - 29 Sep 2006 06:29 GMT

Hi,

How can we find which SQL statement is executing when "list application
show detail" shows "UOW Executing" against an application.

This topic was touched upon earlier by one of the member. That time
responses were to use SNAPSHOT Monitor and a tool called db2top which
is still under development.

I have tried "get snapshot for application applid <appid>" with UOW
Monitor ON but I did not get what statement is executing.

Anyone knows how to get it..

Regards,
Divakar

Reply to this Message

Mark A - 29 Sep 2006 07:09 GMT

> Hi,
>
[quoted text clipped - 12 lines]
> Regards,
> Divakar

Did you turn the statement monitor on?

Reply to this Message

Divakar - 29 Sep 2006 13:00 GMT

Hi Mark,

Thanks for reminding. I had forgotten about it.
Turned it STATEMENT on and now I can see the SQL Statement as well :)

Divakar

> > Hi,
> >
[quoted text clipped - 14 lines]
>
> Did you turn the statement monitor on?

Reply to this Message