How to find the Users/jobs using a particular table

ABaluchamy · New User Joined: 29 Dec 2006 Posts: 34 Location: INDIA

Hi,

Let me know how to find the Users/jobs using a particular table or resource currenlty. From the past discussions i came to DB2MON will do this. But i'm getting Command not found while going with DB2MON.

pls give me the steps to proceed with DB2MON or an alternate one.

Thanks in advance.

-Anand

kanak · Moderator Joined: 12 Mar 2005 Posts: 252 Location: India

if you are using SPUFI as ur tool to access then in that there is option for command...there you can try to give -DIS DATABASE(DATABASE NAME).
It will show the details of that particular table withh all the database available for the with all the required info. There option are available to check which job is using this table.

At the same time you can try with Platinum also ( if the same is present in ur shop). There in frnt of table name in browse or View mode(Option 1 or 3)...give the command DISPUSE. It will show the details of the job using or any ID who has locked the table.

Hope this helps you.