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