Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to find who has locked the tablespace?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: How to find who has locked the tablespace?
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us