Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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.