By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

How to Find which SQL Statement is executing

P: n/a
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

Sep 29 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Divakar" <di*********@gmail.comwrote in message
news:11*********************@c28g2000cwb.googlegro ups.com...
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
Did you turn the statement monitor on?
Sep 29 '06 #2

P: n/a
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

Mark A wrote:
"Divakar" <di*********@gmail.comwrote in message
news:11*********************@c28g2000cwb.googlegro ups.com...
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

Did you turn the statement monitor on?
Sep 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.