Re: How to find which program is loacking record

Have you checked the joblog where you got the error. It will usually tell
you what job has the record locked.



From:
Ashish Kulkarni <ashish.kulkarni13@xxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
06/10/2010 10:37 AM
Subject:
How to find which program is loacking record
Sent by:
<midrange-l-bounces@xxxxxxxxxxxx>



Hi
I am getting error when trying to update DB2 table (V6R1), how do i find
which program or user is locking a record,

I tried

WRKOBJLCK OBJ(LIB/FILE) OBJTYPE(*FILE)

I see most of the locks are of type *SHRRD, is there a way to find out
record level lock?

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.