Re: How do you turn off logginf in ODS?

In article <5m4fi8$q7o$1@poknews.pok.ibm.com>, Ed Oliva (oliva@clnt20kgn.pok.ibm.com) writes: >Hi, > > Is there a way to turn off logging (database built with buffered logging) >on a database using ODS? I know how to do it with SE, but it's not supported >in ODS. In ODS 7.X, this works for me: ontape -N database_name Oh, Ken, there must be no one accessing the database. So, all the users have to be OUT of the database. Online needs to be able to grab an exclusive lock. > > I want to avoid the dreaded "458: Long transaction aborted." when running >updates across an entire 10M row table. Oh, yes, the dreaded "Long transaction aborted" --- try breaking the update into "smaller" pieces and doing a commit after each piece. My developer hated me when I told him he needed to do that. > > Thanks, > > Ed > David Weis dweis@louisville-i-market.com Louisville Internet Marketing Service 1210 Garvin Place Louisville, KY 40203 502-637-7316 (Voice) 502-636-1553 (FAX) http://www.louisville-i-market.com thank goodness for bookmarks!!