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: 19245
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 How to identify bad performers? Testing & Performance 8
No new posts Revoke USER in DB2 DB2 1
No new posts non-system user tasks in CICS CICS 1
No new posts Alter User LOGON Script Parameters CLIST & REXX 11
No new posts Revoke on DB2 to remove an user DB2 4
Search our Forums:

Back to Top