Using Operating System Files as Database Devices

For devices that are initialized on operating system files, ensure that device writes occur directly on the physical media.

Use:

directio with disk init and disk reinit
dsync with disk init

directio and dsync parameters are mutually exclusive. If a device has dsync set to true, you cannot set directio to true for this device. To enable directio for a device, also reset dsync to false.

There is no performance difference between dsync and directio on Windows.

The dsync Parameter
The dsync parameter ensures Adaptive Server can recover data from devices on file systems.
The directio Parameter
The directio parameter for disk init and disk reinit, lets you bypass the operating system buffer cache and transfer Adaptive Server data directly to disk.

Parent topic: Adaptive Server Devices and System Databases

Created August 1, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com