The following limitations and restrictions apply to using dsync:
For the master device, dsync is always set to true and you cannot change the setting.
If you change a device file’s dsync setting using the sp_deviceattr procedure, restart Adaptive Server for the change to take effect.
When you upgrade from an Adaptive Server earlier than version 12.x, dsync is set to true only for the master device file. Use sp_deviceattr to change the dsync setting for any other device files.
Adaptive Server ignores the dsync setting for database devices stored on raw partitions. Writes to devices stored on raw partitions are always directly to the physical media.
The directio and dsync parameters are mutually exclusive. If a device has dsync set to true, you cannot set directio to true for the same device. To enable directio for a device, you must first reset dsync to false.
