Environment variables for large index rebuilds

Nancy Palmquist nlp at vss3.com
Fri May 2 09:28:53 PDT 2008


Barry Wiseman wrote:
> This weekend I will be rebuilding all indexes in a large system.  These 
> folks have long been in the habit of laying time bombs for themselves by 
> rebuilding indexes on a non-idle system (don't ask!).
> 
> Hundreds of these indexes are large (>10Mb), many dozens are quite large 
> (>100Mb, with record sizes ~4K and file sizes ~1M records).  They are 
> mostly post-4.5, multi-key indexes.
> 
> This is a SunOS system, I don't know what the hardware is but it's no 
> great speed demon.  The customer has scheduled 24 hours of downtime for 
> me this weekend, and I'm concerned it may not be enough.
> 
> Reading the online manual, I see there are several variables I'm not 
> familiar with.  As usual, the descriptions shed not much light.  Which 
> of the following will be my friend on this project?  I'm sure the 
> tweaking of dxmaint in this manner is very much a black art, but any 
> guidelines on useful values will be much appreciated.
> 
> PFBIXBUILD
> PFBIXNODESIZE
> PFMAXTEMP
> PFMAXTFIL
> PFNUMIXBUILD
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
Barry,

You do not say if they use 4.8, 5.0 or 5.6 now.  That would make a difference.

I used those variables in 4.8 but they do not seem very necessary any more.  But 
in my config I have set so maybe they make a difference.

PFBIXNODESIZE=24
PFBIXBUILD=2
PFNUMIXBUILD=20480
PFNUMIXBUF=500

Stuff works great so they might help.  (My customer is using 5.0 on this system 
on Linux)

Don't have the MAX ones at all.

Nancy
-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com


More information about the Filepro-list mailing list