Alternatives in using and managing the HPL for 7.x

Hi everyone! :-) I've been spending some considerable time working with the high performance loader for 7.x and I must say what a piece of crap it is. :-) I can't figure out why we are forced to use the onpload data base. Who on earth designed this thing??? It would be so nice to be able to use the HPL like the 8.x HPL, and avoid the really badly designed user interface in the 7.,x product, and having to use the onpload data base. ( 8.x loader doesn't even have a GUI or a data base, and comes with its own language. ) Is there a utility or tool somebody has written to overcome this sloppy design? I'm working on my own, but sheesh, what a badly designed product onpload/ipload is. It uses terminology that is inconsistent, and confusing to say the least. There has got to be a better way. Imagine having to set up 500 tables to unload with the 7.x HPL! It'd take longer to set it up than unload it! And what if I want to duplicate the work on several machines? Argh! Thanks, Tim -- . .- .-- .--- .---- Tim Schaefer .----- tschaefe@bellsouth.net .---- http://www.inxutil.com .--- .-- .- .

Tim Schaefer wrote: > > Hi everyone! > > :-) > > I've been spending some considerable time working with the high > performance loader for 7.x and I must say what a piece of crap > it is. > > :-) Not my experience . . . I was able to dump, reorg, and recreate 11.3G in 14 hours on a HP K200 box. > > I can't figure out why we are forced to use the onpload data base. > Who on earth designed this thing??? It would be so nice to be > able to use the HPL like the 8.x HPL, and avoid the really badly > designed user interface in the 7.,x product, and having to use > the onpload data base. ( 8.x loader doesn't even have a GUI or > a data base, and comes with its own language. ) > I'm not sure about the differences concerning 7.x and 8.x. Sounds a bit better than 7.x. > Is there a utility or tool somebody has written to overcome this > sloppy design? I'm working on my own, but sheesh, what a badly > designed product onpload/ipload is. It uses terminology that is > inconsistent, and confusing to say the least. There has got to > be a better way. Imagine having to set up 500 tables to unload > with the 7.x HPL! It'd take longer to set it up than unload it! > And what if I want to duplicate the work on several machines? > Argh! > There's a package (IIUG, I think) called pload.tar. I was able to make a few modifications to it and, in effect, roll my own reorg scripts. It will generate the required entries to the HPL database without using the GUI. I've reorged 20G with it already (even on a production system), and when coupled with myschema (thanks, Art), I'm able to run dbspace-level reorgs with little muss or fuss. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */