RE: onpload

-fu - file unload vs -fl - file load. (if my memory serves) > -----Original Message----- > From: Richard Savage [mailto:risavage@ea-dc.dhl.com] > Sent: Monday, December 04, 2000 10:44 AM > To: Parker, Jack; informix-list@iiug.org > Subject: Re: onpload > > > Richard Savage wrote: > > Don't you have access to the GUI front end of the High Performance > Loader ? If you do, I recommend that you use this to create load and > unload "jobs" which you can then execute from the command line, using > the following syntax:- > > onpload -p cdw0407 -j ttrdat -fu -l /tmp/ttr.log> > where -p = "project" name > -j = "job" name > -fu = Can't remember, but you need it ! > -l = load or unload job log file > > The High Performance Loader is very fast (38,000,000 rows loaded into > a table in approx 1 hour), BUT watch out for one of its "features": > an "express" load (the HPL has two operating modes - Express and > Deluxe) disables all indexes associated with the table it is loading > data into. This means that a level 0 archive has to be taken after > the data loading has finished and the indexes will have to be > rebuilt. > > "Parker, Jack" wrote: > > > > That's the first I've heard about onpload demanding a > logged database. I've > > used HPL against unlogged databases just fine. > > > > cheers > > j. > > > > > -----Original Message----- > > > From: Ravi Krishna [mailto:srkrishna@mail.com] > > > Sent: Friday, December 01, 2000 11:12 PM > > > To: informix-list@iiug.org > > > Subject: onpload > > > > > > > > > Hi, > > > > > > For a data warehousing project we are loading data from > > > mainframe to Informix > > > 9.x database. > > > The entire ETL tool is custom written in Perl and ESQL-C. > > > > > > The data comes from the mainframe as an ASCII fixed length > > > file which is then > > > loaded onto the informix database using dbload. The Perl > > > script creates the > > > appropriate dbload command file > > > and calls dbload to load the data to a *unlogged* database. > > > > > > The whole process has been tested and works fine. > > > > > > Now here comes the problem. We are contemplating moving to > > > onpload (some high > > > performance loader). From the manuals it looks like that > > > onpload has a setup > > > process which is GUI driven. From iiug.org I downloaded a > > > script which can > > > create the onpload database bypassing the GUI process. > > > However its readme.txt > > > file > > > > > > >Installing and Using > > > >-------------------- > > > >1. You should be logged in as "Informix" > > > >2. dbaccess onpload master.sql > > > >3. database that you want to load to must have logging > > > >4. run the "gop" shell script to use the interface > > > > > > Point no 3 says that the target database where the data is to > > > be loaded must be > > > logged. This conflicts with our objective of keeping the > > > database unlogged. Does > > > that mean, we can not use high performance loader unless we > > > change the database > > > to a logged one. > > > > > > TIA. > > > > > > Ravi. > > > > > > >