I have already tried , -DIS UTIL(*) will give the info only if the utility program is accessing the DB.I want the command to display information about the normal application program that is locked the DB( along with User id).
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
This is probably not the answer you want, but if "any user" can run a job/transactoin that locks "the table", i'd seriously recommend the design be looked into. Running around trying to deal with "whoever locked it" is not a formula for success.
One of the main reasons to implement an application using a multi-user database engine is to prevent locking entire tables so that one user/process can run.
If there are some "single user" processes, they should be scheduled for times when the majority of the system/users are not active.