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: