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 degredation for file system devices that experience high write activity. The dsync option can be set or reset using the disk init, disk reinit, and sp_deviceattr commands.
The dsync option is ignored for raw
devices.
When installing a new Adaptive Server, by default dsync is set on for all file system devices.
When upgrading from ASE 12.0 or earlier releases 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 upgrade, set the dsync option 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.
