Re: sorting to OS filesystem
Thanks.
I tried it, no Joy.
I made /dbtemp2, reexported the environment variable, bounced the engine, and it still sorts in /tmp only.
I've tried PSORT_NPROCS at 0, 2 and 3. No joy still.
<shrugging> what's up with this ??
Thanks.
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Home: 703-430-0805
Cell: 703-477-6045
========================
http://www.one.org/
----- Original Message ----
From: Obnoxio The Clown <obnoxio@serendipita.com>
To: Floyd Wellershaus <fwellers@yahoo.com>
Cc: informix-list@iiug.org
Sent: Saturday, March 18, 2006 3:29:48 AM
Subject: 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