Re: HPL Deluxe Mode

Hello, HPL-Deluxe and HPL-Express has it's own advantages and disadvantages. In both type, you can create index before the data load or after the data load. Load data first and create index after would be the faster way to buildthe table. But if you want to keep the constraints on (for validations) while the data load, HPL-DELUXE method is the way. It can create a rejected records log file. No doubt Express is much faster, because it does not use transaction logging and keeps an Exclusive lock on a table. You need a Fake backup or Zero level backup after the Express load. All depends on your data. If it's a clean data or you don't have to do validations and if you got to load huge data then use Express mode and build indexes later by setting PDQPRIORITY and PSORT_NPROCS at the best your environment supports. Ganesh. --- rboscia <rbosciaNOrbSPAM@ems.att.com.invalid> wrote: > Using HPL deluxe mode -- > At what point do you recreate your indexes? > I am trying to unload, make table changes needed , & > load the > data back in. I am not sure when the indexes need > to be > created. Do I create them in my query language when > I am > creating the new table (after the old one is > dropped)? > I've used Express mode and always have problems with > my indexes > not creating properly or the HPL hanging up. I > don't want to do > this incorrectly.... > Or is deluxe the way to go??? > Thanks > > > Got questions? Get answers over the phone at > Keen.com. > Up to 100 minutes free! > http://www.keen.com > __________________________________________________ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

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