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

[Rick]

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.

[Bob [IBM]]

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

[miro]

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