Re: Parallel index build....(how much tempspace)

Martin Fuerderer wrote: > Hi Norma Jean, <SNIP> > Another thing is the question whether this is about temp dbspaces > at all. As Art already pointed out, sorting needs temp space as well, > but that's in the file system (default /tmp), I believe. > Setting PSORT_DBTEMP allows you to specify a different location > for sorting temp space (in case your /tmp isn't that big and you have > more space available elsewhere). Martin, please check it out with John Miller or someone in engine development, but, IB that sort-work temp files ALWAYS go to DBSPACETEMP dbspaces UNLESS PSORT_DBTEMP is set, not /tmp. > Maybe you can find in some UNIX system log file a hint as to > whether a file system was 100% full at the times in question ? > > Unfortunately, from the messages you saw it is not clear which of > the two "types of temp space" were the problem ... > > TIA, > Martin <SNIP> Art S. Kagel sending to informix-list