RE: HPL Deluxe Mode

Set PSORT_NPROC = number of cpuvp's SET PSORT_DBTEMP = fast disk and empty directory can use multiple separator is ":" Set PDQPRIORITY = 1; Try that on Index builds. This will start PDQ on the reading and sorting on index builds. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: rboscia [mailto:rbosciaNOrbSPAM@ems.att.com.invalid] Sent: Wednesday, June 28, 2000 12:31 PM To: informix-list@iiug.org Subject: Re: HPL Deluxe Mode I have never used HPL before last week. Last week we used Express Mode and our data locked up during the indexes. Informix suggests building indexes after the load which we tried this week. The data unload/load took 1.5 hours. The indexes took 13+ hours and only 4 of the 6 are done. Obviously with users not able to access the data for that long of a time, I don't want to go that route again.... So I think I will try Deluxe Mode next time at least for this table... Since I still have 2 more indexes to go and my table has been locked forever, could you tell me more about PDQPRIORITY and PSORT_NPROCS? We are running 7.31 UC5 on Sun Solaris 7 E10K machine Thanks Robin Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com