MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Lock in the Table

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
balaji.p.raman
Beginner


Joined: 27 Feb 2007
Posts: 10
Topics: 5
Location: India

PostPosted: Fri Aug 17, 2007 1:13 am    Post subject: Lock in the Table Reply with quote

Hi all,
I have been facing this problem for some time now. I am running an online transaction and it is abend with -911 Sqlcode. I am getting this error for more than one hour at times Sad
I think this might be because, someone might have had an exclusive lock on the table or something.
Since the region is an development one, it is possible that someone locked the table while running a debugger.

I would like to find out the user who has locked the table.
Is there any way to find out this? Question
_________________
Rgds,
Balaji
Back to top
View user's profile Send private message Yahoo Messenger
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Fri Aug 17, 2007 2:24 am    Post subject: Reply with quote

you can look at the Lock Contention Summary Report or the Long Accounting Report: Locking Activity
which are apart of Monitoring Performance from ISPF SC18-7975-04

The URL is for a PDF, you can just 'right-click' and 'Save AS ...' to avoid opening the PDF in your browser. It is about 4mg, so it takes a bit of time to load.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Fri Aug 17, 2007 7:34 am    Post subject: Reply with quote

balaji.p.raman,

Please search before posting. Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?p=36255#36255

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
balaji.p.raman
Beginner


Joined: 27 Feb 2007
Posts: 10
Topics: 5
Location: India

PostPosted: Tue Aug 21, 2007 9:45 am    Post subject: Reply with quote

Kolusu,
Oops! Since I was looking for words like LOCK, -911 etc and I couldn't find that particular post.
Sincere apologies!!



Anyway thanks a lot for your help!
_________________
Rgds,
Balaji
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group