Thread: IDS - Running temp dbspaces on RAMDISK
View Single Post

   
  #3 (permalink)  
Old 04-20-2008, 11:54 AM
eriegger
 
Posts: n/a
Default Re: IDS - Running temp dbspaces on RAMDISK
Another try could be to increase DS_NONPDQ_QUERY_MEM significatntly:
Must be >= 128 and <= 0.25 * DS_TOTAL_MEMORY
DS_NONPDQ_QUERY_MEM 65536 # Non PDQ query memory (Kbytes)
$ onmode -wm DS_NONPDQ_QUERY_MEM=65536 (IDS 10)
Could decrease IO into temp spaces.

Reply With Quote