RE: Determining Lock on Specific PF Record

Thanks all, the problem has been fixed.

It turned out to be that someone still had one of our RF scanners with
the record still locked on it.

However, all the users "insisted" they didn't have that record on their
scanner.  Whatever...

Thanks,

Brian.

-----Original Message-----
From: Brian Piotrowski 
Sent: Wednesday, January 11, 2006 9:01 AM
To: Midrange Systems Technical Discussion
Subject: 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
>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> 
>
>  
>