Re: DBTEMP

You basically reiterated both my point and my question. I HAVE DBSPACETEMP set in the onconfig file (I didn't have the environment variable DBSPACETEMP set however, only in onconfig)! The engine IS using the temp spaces defined by DBSPACETEMP. However, SOMETHING is also using the temp space defined by the DBTEMP environment variable (which isn't defined in the ODS Admin manuals, only in SQL manual which says it is an SE only setting). My question is what is using this space and why? Why isn't it using the spaces defined by DBSPACETEMP all the time? --- On Thu, 15 Jan 1998 23:03:45 -0500 Tim Schaefer <tschaefe@mindspring.com> wrote: For NT: An example ONCONFIG entry for DBSPACETEMP: DBSPACETEMP tempdbs1 assuming the temp dbspace called temdbs1, created with the onspaces command, not the Space Explorer. Space Explorer will not create temp dbspaces correctly you will have to create them with onspaces, using the -t flag thusly: ( ON NT ) set inst_name=%INFORMIXSERVER% set ifmx_data=IFMXDATA set drv_ltr=C onmode -sy echo "" > %drv_ltr%:\\%ifmx_data%\\%inst_name%\\tempdbs1_dat.000 onspaces -c -d tempdbs3 -t -p %drv_ltr%:\\%ifmx_data%\\%inst_name%\\tempdbs1_dat.000 -o 0 -s 50000 Ignore the comments you find in the ONCONFIG and use the above example, especially for more than one dbspaces you've set up. The colon-delimitation doesn't work, it's all lies. For example: DBSPACETEMP tempdbs1,tempdbs2,tempdbs3 for 3 temp dbspaces. If you don't have DBSPACETEMP set, then yes, the available space on the drive where Informix resides will get eaten up for temp usage, especially during an NT backup, when onfoobar decides to first dump the data to disk, then to tape. I guess this would apply to large sorts as well as backups. Creating the tempdbs spaces allows a neat and tidy way of managing temp usage. Keep in mind that usage will distribute round-robin amongst all the tempdbs spaces, and it's a good idea to have more than one temp dbspace. To confirm your temp dbspaces are actually going to be used for temp space, do an "onstat -d", and check the flags for the temp dbspaces. If you don't see "2001" or a "T" flag next to the dbspace then it isn't going to be treated as a temp space. Hope this is of some help, :-) Tim -- Tim Schaefer \\\\|// tschaefe@mindspring.com 6 6 -------------------------------oOOo---( )---o00o---------------------- http://www.inxutil.com ICQ:6358805 http://www.informix.com http://www.iiug.org news://comp.databases.informix mailto:majordomo@iiug.org no subject body: subscribe linux-informix http://securities.stanford.edu/complaints/informix/ ====================================================================== Bill Weaver wrote in message <69lfgv$ko4@cssun.mathcs.emory.edu>... >I'm running Online Dynamic Server version 7.22. I have a system that I inherited >and in the environment, the DBTEMP variable is set to a particular file system. >This environment variable is not listed in the System Admin manuals so it would >seem that 7.22 doesn't utilize it. You can find reference to it in the SQL >Reference manual however and it states there that it only is applicable to SE >which I am not running. HOWEVER, I am getting some temporary files in the file >system named by DBTEMP (PSORT_DBTEMP doesn't reference it nor does any other >environment variable)! If this variable "isn't used" by Online, then why are >they appearing and what are they (they all begin with prefixes "en" and "f1"? Is >it safe to unset this variable and not use it at all? If so, will it use the >temporary spaces I already have defined? In addition to Online, we also utilize >version 6.04 of SQL and I4GL. Could one of these be using it? >-------------------------------------------------------- >Name: Bill Weaver >E-mail: Bill Weaver <billw@fscorp.com> >Date: 01/15/98 >Time: 11:16:28 > >This message was sent by Z-Mail Pro - from NetManage >NetManage - delivers Standards Based IntraNet Solutions >-------------------------------------------------------- > ---------------End of Original Message----------------- -------------------------------------------------------- Name: Bill Weaver E-mail: Bill Weaver <billw@fscorp.com> Date: 01/16/98 Time: 09:07:47 This message was sent by Z-Mail Pro - from NetManage NetManage - delivers Standards Based IntraNet Solutions --------------------------------------------------------