Re: HELP ! - DBTEMP - ONLINE 7.12

Posted in 1996

Peter Brueton — Mon, 12 Aug 1996 14:33:24 +0000 — source: Informix-list mailing list archive (1991-1998)

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 Look at DBSPACETEMP and PSORT_DBTEMP Informix-OnLine Dynamic Server Administrator's Guile Version 7.1, 38-18 & 14-27 Peter M Brueton