470,821 Members | 1,972 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Which SQL's are executing and what are they waiting on?

In some other databases (like Oracle and SQL Server), there is a view
that show all SQL's currently executing, who is executing the SQL, and
what the SQL is waiting on (wait on read, wait on lock, wait while
writing to backup transaction log, etc.). What, if any, command can do
this in UDB?

Thanks.

Feb 21 '06 #1
2 1220
Rick wrote:
In some other databases (like Oracle and SQL Server), there is a view
that show all SQL's currently executing, who is executing the SQL, and
what the SQL is waiting on (wait on read, wait on lock, wait while
writing to backup transaction log, etc.). What, if any, command can do
this in UDB?


Look into the GET SNAPSHOT command. You have a number of options there
from a DYNAMIC SQL SNAPSHOT, to a SNAPSHOT FOR ALL APPLICATIONS, that
will give you the information you are seeking.

Go to the online (web) Information Centre and search on GET SNAPSHOT and
you should fine much of the information you require.

Link: http://publib.boulder.ibm.com/infoce.../v8//index.jsp

Bob
Feb 21 '06 #2
Rick wrote:
In some other databases (like Oracle and SQL Server), there is a view
that show all SQL's currently executing, who is executing the SQL, and
what the SQL is waiting on (wait on read, wait on lock, wait while
writing to backup transaction log, etc.). What, if any, command can do
this in UDB?

Thanks.


Rick, there is a tool called db2top that does most of what you're asking
for. I think it's still in a beta/prototype phase, so your mileage may
vary, but here is the link: http://www.alphaworks.ibm.com/tech/db2top.

In addition, most of the DB2 snapshot monitor data is now accessible
through SQL (via table UDFs), so you might want to look into that as well.

Regards,
Miro
Feb 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Mortrek | last post: by
2 posts views Thread by Doug | last post: by
7 posts views Thread by Ronald S. Cook | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.