(GRX) Too many Free chain Builds

[Kenneth Brody]

Quoting Chris Sellitto (Tue, 9 May 2006 15:04:52 -0400):

> To all,
>
> My question is in regard to Free chains, and what the acceptable daily
> occurrence should be?

Ideally:  zero.

Practically:  once in a blue moon.

> We have a Windows 200x server with approximately
> 80 Windows workstations running filePro 5.0.13 (we just downloaded the
> 5.0.14 upgrade which has yet to be installed).  I would say that the
> last several months, one of our files (which averages several thousand a
> day), generates a Free chain message (2-3 on average).

Something is wrong.

> Currently this
> file has over a million records in it, but we do archive it on a monthly
> basis (to about 250 thousand records).  My question is, what could cause
> this many Free chains to occur in one day, and is there action we could
> take to alleviate, or eliminate it?

Deleting records via unprotected lookups?

Network problems?

> Also could running dexpand to add several thousand records help?

Unlikely.

> Any suggestions would be greatly appreciated.

I don't recall if PFCHECKLOCK=ON checks upon deletion.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com