>On Sun 23 Apr, 2000, "Shahryar G. Hashemi" <shahryar(a)n2h2.com> wrote:
>>All in all I do not believe that using filesystem files is a solution for ASE
>>on any platform. With ASE 12.0 they now switch to D_SYNC [wait until the
>>write has been comitted to the file before continuing on] for filesystem
>>files. This of course will make using filesystem files more of an option
>>*but* it will also slow things down [you won't take the OS at it's word
>>anymore] since you will guarantee that data will be written to your filesystem
>>devices.
Well, DBA acquaintances always say that Sybase don't support recovery
from non-raw partition ASE setups and so won't run Production databases
on anything but.
I think, regarding D_SYNC, that perhaps you mean O_DSYNC? Don't know
how that plays out with NFS, as (for version 2) NFS operations are
synchronous anyway (but the Filer's NVRAM allows it to return
completion before data is resident on disk.) NetApp's Tech Note
document specifically uses Version 2, though not apparently for reasons
of data integrity (Can the author of that Tech Note, or anyone else,
comment on this?)
I must add that I'm interested to see that Sybase now support ASE on
Linux for production use, as of release 11.9.1, if you part with the
appropriate sum of money.
On Mon 24 Apr, 2000, "Bruce Sterling Woodcock" <sirbruce(a)ix.netcom.com> wrote:
>Since you're fond of testing, why don't you test this yourself?
(a bit harsh, but I agree with Bruce that if you've got your test-rig
then it seems like you're probably in the best place to do the
testing with your Linux system.)
James.