delete without Logging
Francisco Roldan
Hi everybody, Happy New Year !!!
I need to delete a lot of
registers on a table, but the
delete query executed on dbaccess
aborts when the Long transaction limit is reached.
It is on a develop server, so it is not critical
for me to keep log of this delete statement,
so i was wondering how to execute the delete statement
without logging.
I would appreciate if somebody tell me how to do it.
Thanks in advance.
Regards.
Diego Morales
Try this:
"delete from table where condition WITH NO LOG" or "delete from table
where condition WITH NOLOG".
HTH
-----Mensaje original-----
De: owner-inf...@iiug.org [mailto:owner-inf...@iiug.org]En
nombre de Francisco Roldan
Enviado el: miércoles 8 de enero de 2003 17:46
Para: inform...@iiug.org
Asunto: delete without Logging
Jay Aymond
table "with no log" so that activity is not logged.
A couple of suggestions of how to do this:
(1) Change the logging mode of the entire database to unlogged during the
delete process (ontape -s -N dbname).
(2) Delete the data using a stored procedure or program that can flutter
the "begin work" / "commit work" statements. There is a utility at
www.iiug.org that does this.
(3) Change the mode of the table to raw for the delete process. In order
to do this, you must drop any indexes first.
"Diego Morales" <dmor...@districenter.es> wrote in message
news:avhm70$hp4$1...@terabinaries.xmission.com...
Rajib Sarkar
I didn't get the version of the engine .. but if you are on 7.31, you can
change the mode of the table to RAW and then do the delete. It'll not log
the delete. After the delete is complete, change the mode back to STANDARD.
HTH
Thanx much,
Rajib Sarkar
Advisory Support Engineer (Wells Fargo Bank)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
"Jay Aymond"
<jaymond@community To: inform...@iiug.org
coffee.com> cc:
Sent by: Subject: Re: delete without Logging
owner-informix-lis
t...@iiug.org
01/08/2003 11:24
AM
Please respond to
"Jay Aymond"
Abraham Kirubakaran
Can you confirm if the "raw" tables are available in
other than 8.x versions ??
-Abraham
=====
***************************************************
Abraham Kirubakaran
Enterprise Rent-A-Car
St Louis, MO
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Rajib Sarkar
Yes, its there in 7.31 ..:-) it may not be documented but try it out and
you'll be able to do it ...Actually, u know what its there in 9.2 as well
..:-) I just tried it on 9.21.FC4 and it worked ...
Thanx much,
Rajib Sarkar
Advisory Support Engineer (Wells Fargo Bank)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
Abraham
Kirubakaran To: Rajib Sarkar/Phoenix/IBM@IBMUS, Jay Aymond <jay...@communitycoffee.com>
<bull_informix@y cc: inform...@iiug.org, owner-inf...@iiug.org
ahoo.com> Subject: Re: delete without Logging
01/08/2003 01:15
PM
Eric Herber
You might download 'tx_split' from my website:
http://www.herber-consulting.de/cgi-bin/MainDriver.pl?action=IfmxUtil
tx_split is an esql/c program which is able to split update- and
delete-statements into smaller transaction groups.
HTH.
Best regards
Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: er...@herber-consulting.de
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
Art S. Kagel
download from the IIUG Software Repository. Dbdelete deletes large
numbers of rows from a table quickly but only locks 8192 rows at a time
before committing the transaction so it is also interruptable and
restartable.
Art S. Kagel
Mark D. Stock
Rajib Sarkar wrote:
>
>
>
> Yes, its there in 7.31 ..:-) it may not be documented but try it out and
> you'll be able to do it ...Actually, u know what its there in 9.2 as well
> ..:-) I just tried it on 9.21.FC4 and it worked ...
It's even documented. ;-)
I feel like I'm stuck in a time warp!
Can't someone put this in the FAQ? One of the most useful features
introduced in version 7.31 that was never really publicised (Do I LOOK
surprised? :). Thanks David.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mds...@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
Paul Watson
>
> Yes, its there in 7.31 ..:-) it may not be documented but try it out and
> you'll be able to do it ...Actually, u know what its there in 9.2 as well
> ..:-) I just tried it on 9.21.FC4 and it worked ...
But not in 9.20 unfortunately:-)
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
www.oninit.com #
David Williams
"Mark D. Stock" <mds...@mydassolutions.com> wrote in message
news:avk3hn$i44$1...@terabinaries.xmission.com...
>
> Rajib Sarkar wrote:
> >
> >
> >
> > Yes, its there in 7.31 ..:-) it may not be documented but try it out and
> > you'll be able to do it ...Actually, u know what its there in 9.2 as
well
> > ..:-) I just tried it on 9.21.FC4 and it worked ...
>
> It's even documented. ;-)
>
> I feel like I'm stuck in a time warp!
>
> Can't someone put this in the FAQ? One of the most useful features
> introduced in version 7.31 that was never really publicised (Do I LOOK
> surprised? :). Thanks David.
>