470,636 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

Finding running SQL

Is there a way to find the running SQL associated with a db2 connection?

Nov 18 '06 #1
3 1297
db2freak wrote:
Is there a way to find the running SQL associated with a db2 connection?
db2pd would be one on DB2 for LUW

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Nov 18 '06 #2
"db2freak" <po*******@gmail.comwrote in message
news:11*********************@h54g2000cwb.googlegro ups.com...
Is there a way to find the running SQL associated with a db2 connection?
You can do it with a snapshot, but try this free DB2 Monitor software for a
much easier way:
http://chuzhoi_files.tripod.com/
Nov 19 '06 #3
Try db2top ; http://www.alphaworks.ibm.com/tech/db2top

Mark A a écrit :
"db2freak" <po*******@gmail.comwrote in message
news:11*********************@h54g2000cwb.googlegro ups.com...
Is there a way to find the running SQL associated with a db2 connection?

You can do it with a snapshot, but try this free DB2 Monitor software fora
much easier way:
http://chuzhoi_files.tripod.com/
Nov 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Fuzzyman | last post: by
3 posts views Thread by runes | last post: by
3 posts views Thread by Tim | last post: by
15 posts views Thread by Twan Kennis | last post: by
8 posts views Thread by Rick Strahl [MVP] | last post: by
4 posts views Thread by UJ | last post: by
17 posts views Thread by NetworkElf | last post: by
21 posts views Thread by Tom Gur | last post: by
2 posts views Thread by Karthik Gurusamy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.