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

How to find who has locked the tablespace?
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
PostPosted: Thu Dec 03, 2009 7:52 pm
 Reply with quote
I am getting below error
Code:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: DSNT408I SQLCODE = -913, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR          TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000200, AND RESOURCE          NAME BDW300  .SDW310 ORA-02063:

This I got when Oracle system has tried to insert rows in DB2 table
Which is basically deadlock. But can anybody suggest me how to find who has(userid) locked table currently.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
PostPosted: Thu Dec 03, 2009 8:36 pm
 Reply with quote
Check you DB2 master log .. DBMSTR* .. you can get the details of the thread invoked from ORACLE and the current resource holding the tablespace in DB2.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
PostPosted: Fri Dec 04, 2009 2:34 pm
 Reply with quote
Thanks Ashimer, That helped.

I could see active thread in DBMSTR.
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 -> DB2

 

Similar Topics
Topic Forum Replies
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts force tablespace using LISTDEF input DB2 1
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Find the occurrence of Key Field (Par... DFSORT/ICETOOL 6
No new posts Find a record count/numeric is multip... COBOL Programming 1
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us