ondblog in Informix

[Patrick Chim]

Hi all,

My system is running HP-UX 11.0 and Informix 7.31.UC6A. There is a command ondblog which is used to change the logging mode of database. My database is initially in buffered mode. I type 'ondblog nolog ' it return no error and the log mode has changed to nolog. But when I type 'ondblog buf to change back the logging mode, it return no error but the log mode has not changed (it is still nolog). Does anyone know why ?

Many thanks !
Patrick

[Vincenzo Restuccia]

There are some logging mode changes that cannot be made. For example,
if a database is using ANSI logging mode, all changes will be refused.

[Arthur Bazan]

Informix 'ondblog' will allow you to change the logging mode from buffered to unbuffered logging or to no logging, but to turn logging back on you must perform a backup using 'ontape'. A quick review of the 'ontape' command, 'ontape' (without arguement) will list the syntax for making a backup and turning logging back on.

[Mandred Wong]

Hi,

If you are in a hurry to switch from nolog to buffered log with ontape, set the TAPEDEV to /dev/null in the $ONCONFIG file. This way is not going to perform a whole DB backup, but resume the buffered mode in a minute.