Re: Chunks and temp tables (INFORMIX5.03)

Zeljan Silje wrote: > When my aplication is making temp table (select ... insert into temp > ..), if it can not put than table in first (almost full) chunk, it makes > coredump (Informix dosn't use second-empty chunk). > Is it posible to "tell" Informix in which chunk to make temp tables or > is there some other way to resolve my problem? > You maybe able to use use "CREATE TEMP TABLE ... IN DBSPACE". What we have done is keep all DB's out of root so that we have plenty of room for temp tables during processing. Also watch out for /usr/tmp being used to create your temp tables because of aggregates. -- wilcoxon@pioneerplanet.infi.net ********************************************************************** ... this is only a test ... if this had been a real signature it would have been interesting **********************************************************************