Good morning!

Is it possible to turn logging off for a command? We know how to turn logging on/off for the database, but we are wondering if it is possible to turn logging on/off for just a command (and then it revert back to the state it was in before the command was executed)?

Thanks!

Hi,

You can change logging mode, depending of Informix version.

Please test run ondblog <new mode> [-f <filename>] [<database list>]

new mode:
buf - Change database to buffered mode.
unbuf - Change database to unbuffered mode.
nolog - Change database to no logging.
ansi - Change database to be ANSI-compliant
cancel - Cancel logging request.

Then ondblog nolog, press <Enter>. Next onbar -b -F.

Gustavo.

The answer to your question is no. You would have to go throught the process with ondblog/onbar or ontape. If just one command is maxing you out figure out a way to break up the command with checkpoints.

Running SQL that copies data to a raw table is not logged.