Re: HPL Deluxe Mode

What table changes do you need to make that require you to unload and reload all that data? I'd have to think REALLY hard to find some modification to a table that I could not get Informix to perform online and usually in-place at that! Art S. Kagel rboscia 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

The extents were set incorrectly and we ran out (error code 136). When we moved the data out and recreated the table (last week) Informix suggested we set extents at 24 (which was WAY incorrect & in my non-wisdom I did not know better at the time) (I sure do now) so we ran it up again. Moved the data out and in again using HPL one more time. Our table is 100,000,000 records. Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com