Creating Segments

SAP ASE includes two methods for creating a segment in a database.

  • Use disk init to initialize the physical device, or

  • Use the on clause to create database or alter database to make the database device available to the database. This automatically adds the new device to the database’s default and system segments.

Once the database device exists and is available to the database, use sp_addsegment to define the segment in the database.

See the Reference Manual: Procedures.

This statement creates the segment seg_mydisk1 on the database device mydisk1:
sp_addsegment seg_mydisk1, mydata, mydisk1
Parent topic: Creating and Using Segments