Re: Are logs any use in a no logging database?

} } > Spetc@aol.com writes: } > 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? } } No. } } > 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? } } There is no way of doing any rollbacks at all without logs. That is one of } the things the logs are used for. Your 5 million records would be permanently } updated. } } I have been told by Informix that the logs are used even in a no logging } database when new extents are allocated to a table. I once got an error } about full logs when I did an insert into tab2 select * from tab1 and had } forgotten to set the first extent properly on tab2 first. The error was } gracefull but the insert stoped. } Any schema change is logged. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________