View previous topic :: View next topic
|
Author |
Message |
Nagendran
New User
Joined: 24 Jan 2007 Posts: 89 Location: USA
|
|
|
|
Hi,
I have to identiy the user id and jobid that locked the DB2 Db.
Thanks and Regards,
Nagu |
|
Back to top |
|
|
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
try db2 command
-Dis Util(*)
displays all utilities and who is running that. |
|
Back to top |
|
|
Nagendran
New User
Joined: 24 Jan 2007 Posts: 89 Location: USA
|
|
|
|
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). |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
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. |
|
Back to top |
|
|
|