FREECHN.EXE script

[Don Coleman]

> -----Original Message-----
> From: filepro-list-bounces+dcoleman=dgcreact.com at lists.celestial.com
> [mailto:filepro-list-bounces+dcoleman=dgcreact.com at lists.celestial.com] On
> Behalf Of Kenneth Brody
> Sent: Monday, July 02, 2007 1:13 PM
> To: Mike Schwartz
> Cc: filepro-list at lists.celestial.com
> Subject: RE: FREECHN.EXE script
> 
> Quoting Mike Schwartz (Wed, 27 Jun 2007 08:52:32 -0500):
> [...]
> > (If Ken or anybody says that I don't have to get all the users out of
> > the system to insure that nobody tries to update the file I'm rebuilding
> > the free chain on, then I've been going through a lot of extra trouble
> > all these years...)
> [...]
> 
> Hate to be the bearer of bad news, but...
> 
> The freechain can be rebuilt while people are in the file.  (Consider
> the fact that *clerk/*report rebuild it automatically if they detect
> a corruption.)  One of the first things that happens is the head of
> the freechain is locked.  This will prevent people from creating new
> records, or deleting existing records, while the freechain is being
> rebuilt.  However, existing records can be updated, and people who
> are already adding a record (ie: it's a new record, but it's off of
> the freechain) can continue on with their business.
> 
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list


Ken:

Since I guess I started this freechain issue I'll continue it.  If *clerk or
*report automatically rebuilds the freechain I was under the impression it
will take substantially longer for it to rebuild this way as opposed to
exiting the application which was automatically rebuilding the freechain and
running it manually.  Is this true?

Secondly, I tried today to manually rebuild the freechain on my problem file
while allowing people to continue working in the file.  I did exit the
application which triggered the automatic rebuild of the freechain and I
exited all applications would be adding or deleting records during the
rebuild (even though you've already stated fP will locked these functions
down).  I tried to manually run the freechain rebuild approx. 10 times over
a 5 minute period and kept getting an "Error reading file" message from fP.
When I had all users exit all fP app's and I disabled access to the filePro
network shared drive the freechain rebuild ran fine.

Any suggestions you can make?  The app. I run which will predictably cause a
freechain does a lookup to a mirror_file; copy mirror_file;write
mirror_file;delete.  Both files are rather large in terms of the number of
fields and possibly size.



Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302