Sybase ASE – Changing Existing Database Device from ‘dsync’ to ‘directio’

The directio parameter allows you to configure Adaptive Server to transfer data directly to disk, bypassing the operating system buffer cache. directio performs IO in the same manner as raw devices and provides the same performance benefit as raw devices, but has the ease of use and manageability of file system devices. You cannot set…

Sybase ASE – Extending an Existing Database Device

When the free space in the device where the DB is hosted is exhausted Sybase ASE gives following error:- In such cases sometimes we need to extend the Database device, for which first we’ll identify the devices mapped to the database by executing following command:- Once the device is identified we would use following command…