Re: HPL Deluxe Mode

From: rboscia <rbosciaNOrbSPAM@ems.att.com.invalid> > >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.... Tsk, tsk. :-) >So I think I will try Deluxe Mode next time at least for this >table... Puck, puck, puck-uuuuck!! Wussy. :-) >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? For your remaining indexes: PDQPRIORITY=100 PSORT_NPROCS=40 PSORT_DBTEMP=/directory1:/directory2:/directory3... (At least 3 file system directories, on separate spindles) Then get out of the way. :-) >We are running 7.31 UC5 on Sun Solaris 7 E10K machine Nice.... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com