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. > > > >