Environment variables for large index rebuilds

Barry Wiseman bwiseman at optonline.net
Thu Apr 24 08:52:37 PDT 2008


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





More information about the Filepro-list mailing list