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…

Sybase ASE – Create new Database & Device in Sybase ASE

In Sybase ASE the database is hosted on devices which in turn are mapped to physical datafiles. So to create a database we should have devices already created, if not we can create new devices as:- disk init name='<Device Name>’, physname='<PATH where the datafile would be created>’, size='<Size in MB>M’, directio=true go From the above…