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

Thanks Art. RTFM (Guide to SQL, Reference) says: ------------------- The database server creates implicit temporary tables for its own use while executing join operations, SELECT statements with the GROUP BY clause, SELECT statements with the ORDER BY clause, and index builds. When it creates these implicit temporary tables, the database server uses disk space for writing the temporary data, in the following order: 1. The operating-system directory or directories that the environment variable PSORT_DBTEMP specifies, if it is set. . 2. The dbspace or dbspaces that the environment variable DBSPACETEMP specifies, if it is set.3. The dbspace or dbspaces that the ONCONFIG parameter DBSPACETEMP specifies. 4. The operating-system file space in /tmp (UNIX) or %temp% (Windows). Important: If the DBSPACETEMP environment variable is set to an invalid value, the database server defaults to the root dbspace for explicit temporary tables and to /tmp for implicit temporary tables, not to the DBSPACETEMP configuration parameter. In this situation, the database server might fill /tmp to the limit and eventually bring down the database server or kill the file system. ------------------- That should be clear now. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management "Art S. Kagel" <KAGEL@bloomberg.net> wrote on 21.01.2005 15:51:51: > 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