Re: sorting to OS filesystem

Floyd Wellershaus said: > Hello, > I can't get PSORT_DBTEMP to take. > No matter what I do, even bouncing the engine. > I set the environment variable in the ksh > export PSORT_DBTEMP=/dbtemp > The permissions on /dbtemp are 777. > > onstat -g env and also the OS env command show that the PSORT_DBTEMP> variable is set to /dbtemp. > Yet still, when I try to create this huge index, it sorts in /tmp ( the > default ). It might be one of two things: 1. The "P" in "PSORT" stands for "Parallel", and since you only have one dbspace, there's no parallelization. Try PSORT_DBTEMP=/dbtemp1:/dbtemp2 (and preferably more than two!) 2. Is PSORT_NPROCS set? -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo "But wait, it gets worse." -- Cosmo "Run, don't walk, for the nearest exit." -- Cosmo