-P correct use
Dennis Malen
dmalen at malen.com
Mon Jul 2 12:45:15 PDT 2007
Thanks Ken for the response.
We have decided to attempt to remove all the -P's when we are not posting.
In the reverse it was extremely easy to identify the processing where
the -P's should be added by using:
PFCHECKLOCK=ON
PFCHECKLOCKPOPUP=OFF
The fop.log is written to the /tmp directory. We were then apprised of which
processing had to be modified.
Is there anything that can be used in the reverse that would apprise us of
processing wherein the -P should be removed? We are currently reviewing
various processing on a hit or miss basis.
Thanks!
Dennis Malen
516.479.5912
----- Original Message -----
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Monday, July 02, 2007 11:45 AM
Subject: Re: -P correct use
> Quoting Dennis Malen (Fri, 22 Jun 2007 16:56:45 -0400):
>
>> If I execute a lookup to a file and do not post to that file and a -P is
>> used, will that corrupt anything.
>
> Nothing will get corrupted in this case. (Unlike modifying unprotected
> lookups, which can lead to corruption.)
>
>> After the recent clarification, we understand that if we post we must
>> have a -P. and should not have a -P if we are not posting.
>>
>> What happens if we have a -P and we are not posting. I have some old
>> processing that still has the -P. Is it imperative that the -P be
>> removed.
>
> While it's not imperative that you remove the unnecessary -P from
> lookups you will not be modifying, leaving them in can cause performance
> issues. Because you never write (and, therefore, unlock) the record, it
> will remain locked until you end processing, execute the lookup again,
> or move off the record via getnext/getprev. While the record is locked,
> any protected lookup to that record (whether the -P was needed or not)
> will wait, unless you also use the -W flag.
>
> --
> KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
>
>
>
More information about the Filepro-list
mailing list