Could anyone tell me which table gives (or how to find out) the statistics of active-connection by a user; any tables being locked by user?

Oracle equivalent : v$locked_object, v$session etc..

Thanks for your help.

Best way I have found is to use this freeware monitor:

http://chuzhoi_files.tripod.com/index.html

Andy

db2 list applications show detail

for connected users

db2 get snapshot for locks or tabes on database db-name

for locks and tables.

HTH

dollar

If you have V8 , then you can use the following table functions

SNAPSHOT_LOCK
SNAPSHOT_TABLE

Refer the db2 manuals or 'google' for these terms

Cheers
Sathyaram

Holy cows,

That is some nice piece of freeware, Andy

Thanks for pointing to it...............