RE: HPL Deluxe Mode
Personally I stand by my setting and we have H.P. 7 N class
( 18 when we finish) servers running 7X24 in our
warehouses and have had no problems.
But I do agree - testing in your env. will be needed.
Wayne
-----Original Message-----
From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk]
Sent: Wednesday, June 28, 2000 4:56 PM
To: Martin, Wayne E.
Cc: informix-list@iiug.org
Subject: Re: HPL Deluxe Mode
"Martin, Wayne E." wrote:
>
> Set PSORT_NPROC = number of cpuvp's
Set this much higher, but make sure you have lots of virtual memory. I
once brought a box to it's knees when we eventually reached a value that
used all memory. We then had to watch while the machine swapped out 1 Gb
of database memory. It was NOT a pretty sight! :-)
> SET PSORT_DBTEMP = fast disk and empty directory can use multiple
separator
> is ":"
> Set PDQPRIORITY = 1;
Set this to 100, unless you are trying to do other things at the same
time. If you are, delay them until after the index build. ;-)
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
| http://www.informix.com http://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+