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 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'
go

Advertisements

One thought on “Sybase ASE – Create new Database & Device in Sybase ASE

  1. Pingback: Sybase ASE | Oracle Database Internal Mechanism

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.