Re: Pls. Help with Informix-SE v5 turning off trans. log.
Posted in 1998
In article <68r1nf$j74@cssun.mathcs.emory.edu>, Zoltan Luspai
<zoltan@proxima.co.uk> writes
>Hi,
>
>Please help, I have problem with turning off (removing) the
>transaction log from an INFORMIX-SE ver 5.05.UC1. I have tried the sql
>command: START DATABASE <dbname> WITH NO LOG , but the dbaccess only
>gives me a 201: syntax error message.
>
>Tia,
>Zoltan Luspai
I SE there is NO offically supported way of turning off transaction
logging (this is straight from Informix UK Technical Support).
However you can do
delete from systables where tabtype = "L"
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care