IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to identify the user id that locked a DB2 DB?


IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Jul 12, 2007 2:29 pm
Reply with quote

Hi,

I have to identiy the user id and jobid that locked the DB2 Db.


Thanks and Regards,
Nagu
Back to top
View user's profile Send private message
raghunathns

Active User


Joined: 08 Dec 2005
Posts: 127
Location: rochester

PostPosted: Thu Jul 12, 2007 7:14 pm
Reply with quote

try db2 command

-Dis Util(*)

displays all utilities and who is running that.
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Jul 12, 2007 7:28 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 12, 2007 9:40 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> HomeWorks & Requests

 


Similar Topics
Topic Forum Replies
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts How to identify the transaction categ... IMS DB/DC 3
No new posts user exit in IBM Infosphere Optim DB2 8
No new posts Running a Job with the Default User ID JCL & VSAM 2
Search our Forums:

Back to Top