DBSPACETEMP & PSORT_DBTEMP

Hi everyone, I have not set DBSPACETEMP within my onconfig file because I have chosen to use environment variables to point to other locations. According to both the Administrator's Guide (page 14-27) and the Performance Guide (page 2-39), if the environment variables are set the engine will supersede any definition (or lack thereof) within the onconfig file. I have placed these variables within the Informix startup shell (.profile) and rebooted the engine. However, all explicit temp table creation is occurring in the rootdbs. The same is happening with group by and order by clauses within SQL statements. The Informix techie in Lenexa has stated though these variables seem to be OK. The real question comes down to whether I can use different locations for explicit temp tables and order by groups for client processes. System: HP-UX universe B.10.20 D 9000/849 INFORMIX-OnLine Version 7.22.UC3 Onconfig definition: DBSPACETEMP Environment variables: DBSPACETEMP=/sort2 PSORT_DBTEMP=/sort1,/sort2 This is now an open case with Informix Tech Support regarding these two environment variables, which they have not resolved. What am I missing? Thanks, John ---------------------------- John F. Coyle, DBA Yankee Candle Co. South Deerfield, MA 01373-0110 jfc@yankeecandle.com