Re: changing logging mode

Ravi, There is a new utility calleb ondblog which can be used to change the logging status. I believe that a level 0 backup through either onbar or ontape is still necessary to enforce the change. But look up ondblog first. regards Malcolm ----- Original Message ----- From: "rkusenet" <rkusenet@sympatico.ca> To: <informix-list@iiug.org> Sent: Wednesday, October 01, 2003 4:05 PM Subject: changing logging mode > I will be changing the logging mode of some databases pretty > soon. The only method I know is to use ontape -s -U dbname. > Now we don't have access to tape drive. The backup is taken > by EDS using onbar. I am not too familiar with onbar. I looked > up the options of onbar and saw no options to change the logging > mode of a database. > > I think this is what it needs to be done if I have to change > the logging mode without bouncing the server and involving > EDS. > > 1. use onmonitor to change the TAPEDEV parameter to /dev/null. > > 2. use ontape -s -U dbname option for a quick change of logging > mode without taking any real backup. > > 3. use onmonitor to set the TAPEDEV parameter back to its actual > value. > > > Is there a better approach. > > TIA. > > ravi > > sending to informix-list

"malcolm.iiug" <malcolm.iiug@btopenworld.com> wrote in message news:blf1t2$q16$1@terabinaries.xmission.com... > > Ravi, > There is a new utility calleb ondblog which can be used to change the > logging status. I believe that a level 0 backup through either onbar or > ontape is still necessary to enforce the change. But look up ondblog first. > > regards > > Malcolm Thanks. This seems to be an easier approach. $ ondblog unbuf database_name $ onbar -b -F Ravi