Saturday, 11 January 2020

How to extent sap data unit in sybase

In any database data units and log units are core places where the data of database resides. in this post  i am sharing the process of extending disk space of one data unit in Sybase.

In the below screenshots,  sapdata_1 to sap data _4 & saplog_1 to saplog_2 are available.

To extended the disk space of sapdata_4,execute the below commands:



% isql -Usapsa -SSOL -X
Password:
1> use master
2> go
1> disk resize name = "SOL_data_004",size="5G"
2> go
1> use master
2> go
1> alter database SOL on SOL_data_004 = '5G'
2> go




Note: the disk space from root is assigned to sapdata_4. 

2 comments: