Carl Guse wrote:
>
> X-Mozilla-Status: 0001
> Message-ID: <35145A0C.41F6@inlink.com>
> Date: Sat, 21 Mar 1998 18:23:40 -0600
> From: Carl Guse <pivotal@inlink.com>
> Organization: Pivotal Development Solutions
> X-Mailer: Mozilla 2.01 (WinNT; I)
> MIME-Version: 1.0
> To: informix-ist@iiug.org
> Subject: Correct Answer
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I have a bet riding on the correct answer for this
> question:
>
> Can the location of temporary tables be
> configured?
Yes and no. The environment variable DBSPACETEMP specifies one or more
dbspaces into which to place temp tables. Inversions prior to 7.3,
though a temp table could be created in any of the listed dbspaces and
in general was done by each thread in a round robin fashion such that
if your connection created three temp tables and there are two spaces
in the list the third table goes in to the same space as the second.
Version 7.3 is supposed to be able to create temp tables fragmented
across all DBSPACETEMP spaces. So, in the sense that, if set,
DBSPACETEMP controls which dbspace(s) are used for temp tables, yes you
can control it. However, if more than one dbspace is specified you
cannot know which dbspace will contain a particular temp table.
Art S. Kagel