Hi,

I am using DB2 V8.1 on windows.

I executed drop table stmt, it is hanging fro more than 45 mins.

I tried to figure out using Activity monitor , but could'nt find any monitoring task which can give me the process running under a particular user id.

can anyone tell me which monitoring task to use to find all the processes running under a particular user id.

Thx

I would do a:

db2 list applications show detail

If you application (command line session, etc) is waiting on a lock, it should tell you.

Just to make sure that you don't wait on locks forever, you should change the LOCKTIMEOUT from -1 to 30 seconds (or something reasonable).

db2 connnect to db-name
db2 update db cfg using LOCKTIMEOUT 30

Thx marcus ,

I am able to get a list of applications connected and their status.
But is a there a way to find out which sql statement is being exectued under each process or application.

I want to know what each process is doing.

Thx

You can do it with a GET SNAPSHOT using the APPLICATION APPLID appl-id and the DYNAMIC SQL options. See the Command Reference manual for details.

There is also nice tool that lets you see what is going on in real-time:

http://chuzhoi_files.tripod.com/

Thx Marcus

This is very good tool for monitoring performance, active connections, locks , sqls in cache etc..


Btu this is for windows only, Do we have something similar tool for Solaris?


thx

You can run the tool from Windows connected to a remote DB2 database on Solaris.