Resent, not sure if my first response made it to list
---------- Forwarded message ----------
Date: Thu, 23 May 1996 01:39:35 -0500 (CDT)
From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov>
To: Spetc@aol.com
Cc: informix-list@rmy.emory.edu, eric@sstcs.com
Subject: Re: Are logs any use in a no logging database?
1. No!
2. Writes always occur to the log for certain commands (moslty all
update/alters/creates). It will write to the log, yet if your log is
point to /dev/null (that's like never never land) no real write occurs only
disk access. Yet the eninge does count it as an write!!!! It does in
otherwords access /dev/null. If I'm wrong! the expert's will pipe it in right.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Wed, 22 May 1996 Spetc@aol.com wrote:
> We do not use logging on our database.
>
> 1. We perform level 0,1 archives, but we don't backup the logs, do we really
> need to?
>
> 2. What are the logs used for in a no logging database? For example, if I
> update every row in a table with 10 million rows with a single update
> statement and I interrupted it half way through would the first 5 million
> updates be rolled back? Would it use the logs for this purpose?
>
> Thanks in advance.
>