RE: onpload

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