The dsync option ensures Adaptive Server can recover data from devices on the file systems. By default, Adaptive Server enables dsync for file system devices. However, dsync may cause performance degradation for file system devices that experience high write activity. You can set or reset dsync using the disk init, disk reinit, and sp_deviceattr commands.
The dsync option is ignored for raw
devices.
By default, when you install a new Adaptive Server, dsync is set on for all file system devices.
When you are upgrading from ASE 12.0 or earlier versions on a UNIX server that stored databases on UNIX file system devices, by default, dsync is set:
on for the master device
off for all other devices
Immediately after upgrading, check to make sure that dsync or directio is set for the file system devices. See also sp_deviceattr and sp_helpdevice in the Reference Manual
WARNING! Data corruption may occur if dsync option is not set immediately after upgrade.
