MVSFORUMS.com

balaji.p.raman · Posted: Fri Aug 17, 2007 1:13 am Post subject: Lock in the Table

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

dbzTHEdinosauer · Posted: Fri Aug 17, 2007 2:24 am Post subject:

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

kolusu · Posted: Fri Aug 17, 2007 7:34 am Post subject:

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

balaji.p.raman · Posted: Tue Aug 21, 2007 9:45 am Post subject:

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