RE: Logging to Disk

We too rename our log files to "logfile.<last log number>" on our remote servers. When rolling forward the logs this is awkward and prone to error however. Upon a restore of the logical logs Informix will prompt you for a specific tape number, not log number. Care must be taken when renaming the archive. In the event one must restore you must rename in the order of date stamp (or log number - should be the same). Fortunately, I have not had to do this in production, but have tested it. Wherever possible I would recommend logical log archive to tape. If archive to tape is not possible I would recommend you rename your log files to "logfile.<tape_number>" (this may avoid any confusion during a stressful situation). You could create a counter variable and reset it after a successful level 0/1/2. You may also want to save the old logs. HTH Scott H. > -----Original Message----- > From: Art S. Kagel [SMTP:kagel@bloomberg.net] > Sent: Monday, October 25, 1999 4:18 PM > To: informix-list@iiug.org > Subject: Re: Logging to Disk > > The LTAPEDEV always names the same file. After an archive of logs > completes, rename the file and create a new empty file for the next > archive with the same name. I habitually rename the log archive file as > "logfile.<last log number>" indicating which log is last in that archive > file. It is known to contain the logs from the last file until the named > log number. > > Art S. Kagel > > Heidemarie Fernandez wrote: > > > > How could i alternate the log file in Windows NT without restarting the > > Informix Server > > > > Thanks for your help in advance > > > > heidi > > -----Original Message----- > > From: Paul watson <watsop@russellcorp.co.uk> > > To: bak@fadavis.com <bak@fadavis.com> > > Cc: informix-list@iiug.org <informix-list@iiug.org> > > Date: Monday, October 25, 1999 14:31 > > Subject: Re: Logging to Disk > > > > >Yes, create a file, use onmonitor etc to alter the LTAPEDEV parameter > and > > stop and restart > > >the engine > > > > > >Alternatively touch a link file and then alter the link when you want > to > > move from tape to > > >disk or vice versus. This way you don't need to stop and restart the > > engine > > > > > > > > > > > >Paul Watson > > >WF Software Ltd > > >Tel: +44 1436 674729 > > >Fax: +44 1436 678729 > > >www.wfsoftware.com/informix > > ># If you broke it, hide the evidence > > > > > >>>> "Brian Krause" <bak@fadavis.com> 10/25/99 01:00PM >>> > > >I would like to have the logs go to disk rather than a tape drive. Is > this > > >possible? How? > > > > > > > > > > > >********************************************************************** > > >This email and any files transmitted with it are confidential and > > >intended solely for the use of the individual or entity to whom they > > >are addressed. If you have received this email in error please notify > > >the system manager. > > > > > >This footnote also confirms that this email message has been swept by > > >MIMEsweeper for the presence of computer viruses. > > > > > >www.mimesweeper.com > > >**********************************************************************