Re: How do you turn off logginf in ODS?
Posted in 1997
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.
>
> I want to avoid the dreaded "458: Long transaction aborted." when running
>updates across an entire 10M row table.
>
> Thanks,
>
> Ed
>
>--
>Edmund J. Oliva PPS System Test Dept VN6A MS 994
> POWER Parallel Systems Poughkeepsie, NY
> (914) 433-8740
>
>
ontape -s -L 0 -N <database name>
(Run level 0 archive and set logging to no logging...
--
David Williams