Turn Transaction Logging OFF

Posted in 2001

Summary

ASA GSI could not turn transaction logging off with ontape -N. Brett Randall said to ensure no connections and run ontape -s -L 0 -N database. Andrew Hamm asked whether the user was informix. Denis Melnikov suggested ondblog nolog, which Hamm then found documented in the manual. Answered.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Backup & Restore, Transactions, Locking & Isolation

ASA GSI — Wed, 3 Jan 2001 15:30:30 -0500 — source: Informix-list mailing list archive (1991-1998)

I've tried to use % ontape -N databasename but nothing... Can someone please give me a step-by-step instruction. All help is greatly appreciated Thanks Jordan

↪ replying to ASA GSI

Brett Randall — Thu, 04 Jan 2001 07:54:17 +1000 — source: Informix-list mailing list archive (1991-1998)

1. No connections to the database. 2. ontape -s -L 0 -N database Brett Randall ASA GSI wrote: > > I've tried to use % ontape -N databasename but nothing... > > Can someone please give me a step-by-step instruction. > All help is greatly appreciated > > Thanks > Jordan

↪ replying to ASA GSI

Andrew Hamm — Thu, 4 Jan 2001 09:52:42 +1100 — source: Informix-list mailing list archive (1991-1998)

ASA GSI wrote in message ... >I've tried to use % ontape -N databasename but nothing... > >Can someone please give me a step-by-step instruction. >All help is greatly appreciated > >Thanks >Jordan Are you working as informix? Possibly root also has the authority to do the work, but an ordinary Joe won't be able to issue that command.

↪ replying to ASA GSI

Denis Melnikov — Thu, 4 Jan 2001 16:19:00 +0300 — source: Informix-list mailing list archive (1991-1998)

> I've tried to use % ontape -N databasename but nothing... ondblog nolog ...

↪ replying to Denis Melnikov

Andrew Hamm — Fri, 5 Jan 2001 10:19:46 +1100 — source: Informix-list mailing list archive (1991-1998)

Denis Melnikov wrote in message <931t8k$o6f$1@storm.comstar.ru>... >> I've tried to use % ontape -N databasename but nothing... > >ondblog nolog ... > What the hell does ondblog do? It won't print a usage of itself. Where's TFM? More information please...

↪ replying to Andrew Hamm

Andrew Hamm — Fri, 5 Jan 2001 10:21:52 +1100 — source: Informix-list mailing list archive (1991-1998)

Andrew Hamm wrote in message <3a550400@news.iprimus.com.au>... >Denis Melnikov wrote in message <931t8k$o6f$1@storm.comstar.ru>... >>> I've tried to use % ontape -N databasename but nothing... >> >>ondblog nolog ... >> > >What the hell does ondblog do? It won't print a usage of itself. Where's >TFM? > >More information please... > OOOOH! I've just RTFM (page 35-18) and it's very simple. Cute.

Glossary

ontape