Re: changing logging mode

Hi Ravi. How about using ondblog utility ? -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "rkusenet" <rkusenet@sympatico.ca> >Reply-To: "rkusenet" <rkusenet@sympatico.ca> >To: informix-list@iiug.org >Subject: changing logging mode >Date: Wed, 1 Oct 2003 11:05:27 -0400 > >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 > > _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail sending to informix-list