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.
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.