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
From the above command we can create devices for the database, ideally there should be separate devices for hosting data & log. Once we have the device created, database can be created using following commands.
create database <DB Name>
on <Device name for hosting data> = '<Size in MB>M'
log on <Device name for hosting log> = '<Size in MB>M'
One thought on “Sybase ASE – Create new Database & Device in Sybase ASE”
Pingback: Sybase ASE | Oracle Database Internal Mechanism