The following limitations and restrictions apply to using the dsync setting:
dsync is always set to “true” for the master device file. You cannot change the dsync setting for the master device. If you attempt to turn dsync off for the master device, Adaptive Server displays a warning message.
If you change a device file’s dsync setting using the sp_deviceattr procedure, you must restart Adaptive Server before the change takes affect.
When you upgrade from an Adaptive Server prior to version 12.x, dsync is set to “true” for the master device file only. You must use the sp_deviceattr procedure 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 done directly to the physical media.
Adaptive Server also ignores the dsync setting for database devices stored on Windows NT operating system files. Adaptive Server on Windows NT automatically uses a capability similar to dsync for all database device files.
