Re: SE: Transaction log on raw device ?
From: liliano@my-deja.com > >I've Informix SE 7.23 under Solaris7. >Can i set a raw device (700 MB) instead of a regular file for >transaction log? >If so, what happen when it is full ? I doubt it. I think SE logging expects to write to an OS file. But even if by some miracle works, I doubt it would get much sympathy from Tech Support. :0) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Obnoxio The Clown wrote: > > From: liliano@my-deja.com > >I've Informix SE 7.23 under Solaris7. > >Can i set a raw device (700 MB) instead of a regular file for > >transaction log? If so, what happen when it is full ? > > I doubt it. I think SE logging expects to write to an OS file. But even if > by some miracle works, I doubt it would get much sympathy from Tech Support. > :0) The trouble with it would happen rather quickly -- the first time the SE code tried to append data after the end of the device, the transaction log would appear full, thus leading to problems of one sort (error messages about no disk space left) or another (no transactions being recorded). -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"
Jonathan Leffler wrote: > > Obnoxio The Clown wrote: > > > > From: liliano@my-deja.com > > >I've Informix SE 7.23 under Solaris7. > > >Can i set a raw device (700 MB) instead of a regular file for > > >transaction log? If so, what happen when it is full ? > > > > I doubt it. I think SE logging expects to write to an OS file. But even if > > by some miracle works, I doubt it would get much sympathy from Tech Support. > > :0) > > The trouble with it would happen rather quickly -- the first time the SE > code tried to append data after the end of the device, the transaction > log would appear full, thus leading to problems of one sort (error messages > about no disk space left) or another (no transactions being recorded). And, just in case what I mean isn't clear, I mean that the problems would occur immediately. The way the transaction log code works is by opening the file in append mode. A normal file has a size smaller than the disk it is on (logical volume if you've got an LVM), and you can extend it. A device file is always as big as the disk space allocated for it, and you cannot extend it. Hence, to SE, the raw device would always appear full. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"