cancel
Showing results for 
Search instead for 
Did you mean: 

ondblog in Informix

Patrick Chim
Trusted Contributor

ondblog in Informix

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
3 REPLIES
Vincenzo Restuccia
Honored Contributor

Re: ondblog in Informix

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
Occasional Visitor

Re: ondblog in Informix

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
Occasional Visitor

Re: ondblog in Informix

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.