dbaccess:load and long transaction

Posted in 2001

Topics: Server Administration, Migration, Import/Export & Data Conversion

Pentti Tiet�v�inen — Fri, 19 Jan 2001 17:10:38 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, I'm using dbaccess to unload/load tables and like to skip the transaction handling (read long transaction aborted). Is there any easy way/command to do this? Thank's Pentti

↪ replying to Pentti Tiet�v�inen

Jonathan Leffler — Fri, 19 Jan 2001 18:27:28 GMT — source: Informix-list mailing list archive (1991-1998)

"Pentti Tietäväinen" wrote: > I'm using dbaccess to unload/load tables and like to skip the transaction > handling (read long transaction aborted). > Is there any easy way/command to do this? Don't use DB-Access. DB-Load provides for smaller transactions. So does SQLCMD. And HPL avoids those problems too, I'm pretty sure. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

↪ replying to Pentti Tiet�v�inen

mars1972@my-deja.com — Fri, 19 Jan 2001 18:30:10 GMT — source: Informix-list mailing list archive (1991-1998)

Turn off logging during the process. Otherwise, use dbload, which commits every 100 records, and shouldn't cause long transactions. In article <949lsa$h64$1@tron.sci.fi>, "Pentti Tiet'v'inen" <pat@sci.fi> wrote: > Hi, > I'm using dbaccess to unload/load tables and like to skip the transaction > handling (read long transaction aborted). > Is there any easy way/command to do this? > > Thank's > > Pentti > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/

Glossary

dbaccess