Fwd: RE: Parallel index build....(how much tempspace)

Completeness is always desirable. I'll never complain. Art S. Kagel ----- Original Message ----- From: Martin Fuerderer <MARTINFU@de.ibm.com> At: 1/24 7:04 No battle here !! Art's OK and I'm happy he usually has good ideas and answers where I don't. I just had omitted some stuff, but as his comment wasn't the whole truth either, I thought the complete thing is what's needed here. I should have done the RTFM myself before letting loose my comments in the first place ... Cheers, Martin -- "Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> wrote on 21.01.2005 18:59:36: > > Dude.... You're RTFM'ing Art?.... Wow...... The battle of the > titans.. ;) > > > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Martin Fuerderer > Sent: Friday, January 21, 2005 10:02 AM > To: Art S. Kagel > Cc: informix-list@iiug.org > Subject: 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 > ============================================================ > The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader > of this message is not the intended recipient, or an employee > or agent responsible for delivering this message to the > intended recipient, you are hereby notified that any reproduction, > dissemination or distribution of this communication is strictly > prohibited. If you have received this communication in error, > please notify us immediately by replying to the message and > deleting it from your computer. Thank you. Tellabs > ============================================================ sending to informix-list