Re: HELP ! - DBTEMP - ONLINE 7.12

thunt27@aol.com (Thunt27) wrote: >Anyone got ideas on how this variable is used in Online 7. We have a big >table (c 4million rows) and when we try to add indexes we are running out >of space in rootdbs. It should be possible to set DBTEMP to make the >sorting and temporary building take place on a UNIX volume that we specify >e.g. /tmp >This doesn't appear to work i.e. still uses rootdbs >Any ideas folks ? >BR in advance >Trevor Hunt >Nomura Bank Intl In OnLine 7.12 the variable is DBSPACETEMP instead of DBTEMP. You can then point to wherever you want your sorting to take place. I also believe it isn't a good idea to use /tmp. I believe informix recommends you specifically create space specifically for temp spaces and furtheremore, designate them as temp spaces. For example, on our system we specifically have (8) 500meg dbspaces designated specifically as temp dbpaces, and they are listed in our onconfig file under the DBSPACETEMP variable. Yesterday, I had to create the eighth space because I also ran out of contiguous temp space when creating an index on a 60million row table. I used onmonitor and marked it as temp on the designated section on the screen. I also had to add this space into the onconfig file as stated above and then take down and reinitialize the engine for the change to take effect. I hope this helps. National Linen Service 1420 Peachtree Street MS #230 Atlanta, GA 30309 e-mail: barryleb@mindspring.com