Re: temporary tables and informix hang

Des wrote: > > Our users recently reported that their informix system (7.?) was having > problems. A transaction had hung. They reported messages to the effect > that /tmp was full. This was where they were creating temp tables. /tmp > itself still appeared to be 40 % free. They reckoned that an onstat -u > showed a 'b' flag in position 3. (This doesn't appear in the manual as a > valid flag in that position) > Now I'm being asked where should temp tables go - /tmp or a dbspace - > any ideas ? Also we seem to have a session variable of DBTEMP in use - is > this the same as DBTEMPSPACE as documented ? > Any advice on the hang or placement of temp tables and why would be useful. Informix does not place temp tables in /tmp, at least Online and IDS do not (I don't remember SE's behavior well enough), and you do not specify what version of Informix 7.? you are using. IDS places temp tables in the following hierarchy: Logged temp tables (including implicit and explicit temp tables without the WITHOUT LOG clause): DBSPACETEMP - if any of the listed DBSPACES is NOT a tempdbspace ROOTDBS - otherwise Unlogged temp tables: DBSPACETEMP - if set to one or more DBSPACE. ROOTDBS - if DBSPACETEMP is not set. Temporary sort-work files during sorting: PSORT_DBTEMP - if set to a list of filesystems or directories DBSPACETEMP - if PSORT_DBTEMP is not set ROOTDBS - if neither of DBSPACETEMP or PSORT_DBTEMP is set DBTEMP is an old 4.xx and 5.xx Online variable which define where to place temp tables instead of ROOTDBS since there were not tempdbspaces. It is no longer being used by IDS versions 6.xx and later. Art S. Kagel