RE: How to break up a big transaction?

Posted in 2000

mosserp@WellsFargo.COM — Fri, 7 Jan 2000 14:54:50 -0800 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF5962.38A49340 Content-Type: text/plain; charset="iso-8859-1" Or check out Art Kagel's dbdelete program on www.iiug.org -> Software -> utils2_ak -----Original Message----- From: ackerbau@us.ibm.com [mailto:ackerbau@us.ibm.com] Sent: Friday, January 07, 2000 2:50 PM To: informix-list@iiug.org Subject: Re: How to break up a big transaction? Lena -- If you code the delete as a cursor that implicitly deletes one record at a time, it should not adversely affect logging. The only way you'd fill up your logs is if you issued a "delete from table where . . ." in dbaccess. A foreach cursor in SPL should do the trick very nicely for you -- no explicit commit statements required if you delete a record at a time in the cursor. -mka Michael Ackerbauer SP Platform Evaluation Test Systems Verification/Integration Webmaster Please respond to lena_peltonen@my-deja.com Sent by: owner-informix-list@iiug.org To: informix-list@iiug.org cc: Subject: How to break up a big transaction? Hi all, I'd need perform a huge delete operation (about million rows). I wouldn't like to add several logs for this single transaction that will be run very rarely. So how can I break up a delete operation so that it would do commit e.g. after every 5000 rows? I was told that I could use dbloader but is there any way to do it from SPL or C/ESQL script? Any help would make me most grateful. Best Regards Lena Sent via Deja.com http://www.deja.com/ Before you buy. ------_=_NextPart_001_01BF5962.38A49340 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0"> <TITLE>RE: How to break up a big transaction?</TITLE> </HEAD> <BODY> Or check out Art Kagel's dbdelete program on www.iiug.org -> Software -> utils2_ak -----Original Message----- From: ackerbau@us.ibm.com [<A HREF="mailto:ackerbau@us.ibm.com">mailto:ackerbau@us.ibm.com</A>] Sent: Friday, January 07, 2000 2:50 PM To: informix-list@iiug.org Subject: Re: How to break up a big transaction? Lena -- If you code the delete as a cursor that implicitly deletes one record at a time, it should not adversely affect logging.  The only way you'd fill up your logs is if you issued a "delete from table where . . ." in dbaccess. A foreach cursor in SPL should do the trick very nicely for you -- no explicit commit statements required if you delete a record at a time in the cursor. -mka Michael Ackerbauer SP Platform Evaluation Test Systems Verification/Integration Webmaster Please respond to lena_peltonen@my-deja.com Sent by:  owner-informix-list@iiug.org To:   informix-list@iiug.org cc: Subject:  How to break up a big transaction? Hi all, I'd need perform a huge delete operation (about million rows). I wouldn't like to add several logs for this single transaction that will be run very rarely. So how can I break up a delete operation so that it would do commit e.g. after every 5000 rows? I was told that I could use dbloader but is there any way to do it from SPL or C/ESQL script? Any help would make me most grateful. Best Regards Lena Sent via Deja.com <A HREF="http://www.deja.com/"; TARGET="_blank">http://www.deja.com/</A>; Before you buy. </BODY> </HTML> ------_=_NextPart_001_01BF5962.38A49340--

RE: How to break up a big transaction?

Related threads

Your privacy choices