RE: Determining Lock on Specific PF Record

Thanks, Jerry.

I did check the physical locks on the file, but there's nothing showing
up - according to the system, no users have the record locked.  But this
still persists to be a problem - we can't even print the record without
the "cannot allocate" error message showing up.

It would be really nice if I could run a command that would show me a
specific lock on a record in our table.

I went into Navigator and looked at the Database Transactions, but it
didn't provide any useful information.

Thanks,

Brian.

-----Original Message-----
From: Jerry Adams [mailto:jerry@xxxxxxxxxxxxxxx] 
Sent: Wednesday, January 11, 2006 8:52 AM
To: Midrange Systems Technical Discussion
Subject: Re: Determining Lock on Specific PF Record

WRKOBJLCK or WRKACTJOB option 5, option 12 should do it.  Anyway, that's

what I use.



        * Jerry C. Adams
*iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.893.8633x152
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Brian Piotrowski wrote:

>Hi All,
>
> 
>
>Is there an easy way to determine who has a lock on a specific record
>(or set of records) in a Physical File?  We have a problem in one of
our
>records where when we try to update it the system tells me that it is
>unable to allocate a record in the PF.  However, there are other users
>who are currently updating other records in the same PF without issues.
>
> 
>
>Thanks,
>
>
>Brian.
>
> 
>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>Brian Piotrowski
>
>Specialist - I.T.
>
>Simcoe Parts Service, Inc.
>
>PH: 705-435-7814
>
>FX: 705-435-6746
>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> 
>
>  
>