View Single Post

   
  #6 (permalink)  
Old 04-20-2008, 11:59 AM
bozon
 
Posts: n/a
Default Re: IDS - Running temp dbspaces on RAMDISK

You can also point PSORT_DBTEMP to ramdisks. This seemed to help us.

/ramdisk/psort1/
/ramdisk/psort2/
/ramdisk/psort3/
/ramdisk/psort4/
....

then
PSORT_DBTEMP=/ramdisk/psort1:/ramdisk/psort2:/ramdisk/psort3/:/ramdisk/psort4/
....

You just make sure that the ramdisks are created when the machine comes
back on line before informix comes backup.

We use more than one directory because I thought and others concurred
that Informix would sort more in parallel with more directories. Of
course if you are running 10 use the high DS_NONPDQ_QUERY_MEM setting
as eriegger recommended.

Reply With Quote