For devices initialized on UNIX operating system files, the dsync setting controls whether or not writes to those files are buffered. When the dsync setting is on, Adaptive Server opens a database device file using the UNIX dsync flag, which ensures that writes to the device file occur directly to the physical storage media, and that Adaptive Server can recover data on the device in the event of a system failure.
When dsync is off, writes to the device file may be buffered by the UNIX file system, and the recovery of data on the device cannot be ensured. Turn off dsync only when data integrity is not required.
The dsync setting is ignored for
devices initialized on raw partitions. Instead, writes to the database
device take place directly to the physical media.
