Re: Rolling back transactions

We have always set our test environment log tape device to /dev/null. But occasionally, the logical logs still get full and the system crashes. Is it true that tbtape -c must be run to flush the log to /dev/null. In article <5tsktq$95p@cssun.mathcs.emory.edu>, uday@dpg.rnb.com says... > >Ah, excellent idea! Just what I was looking for. > >Thanks! > >Uday > >Nils Myklebust wrote: >} >} uday@dpg.rnb.com (Uday Shankar) wrote: >} >} :Ok, thanks. I was wondering if there was a way around this, since >} :we typically do our testing in unlogged databases. I guess there >} :really isn't a way to roll back unlogged transactions then, but >} :I thought I'd ask anyway! >} >} In this case it might be usefull to turn on logging but use /dev/null >} as the tape device. In that case you have logging and can do >} begin/commit/rollback, but you can do no recovery of the logs. That >} may be usefull for testing purposes. >} >} Nils.Myklebust@idg.no >} NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway >} My opinions are those of my company >} The Informix FAQ is at http://www.iiug.org > >-- >Uday Shankar >Derivative Products Group >Republic National Bank of New York >uday@dpg.rnb.com >(212) 525-8000 -- Chaiw Kok Kee Consultant Multi-Purpose Information Technology kkchaiw@mit.com.my www.jaring.my/mphb/