Database name for increasing space

[adarsh_jainer]

Hi Mates,

Can anyone inform me on how to find the database name in command prompt so that i can increase the database space in our SAP system.

Regards,

Adarsh

[Johan_sapbasis · Accepted solution]

Hi Adarsh,

This will increase device SID_data_001 by 1G

disk resize name ='SID_data_001' , size='1G'

go

Now you have to allocate the newly added space on the device to the database. Now there will be 1G of free space on your database on datafile SID_data_001

alter database SID on SID_data_001 ='1G'

Please note if you need to add log space the disk resize command syntax remains the same but for log the command would change for alter i.e.

disk resize name ='SID_log_001' , size='1G'

go

alter database SID log on SID_log_001 ='1G'

go

Hope this helps, you can also set up ATM, I will be doing this shortly and then publishing a wiki.

Johan

[victoria_normand]

Hi Adarsh,
If you are using SAP application on ASE you may use DBACockpit to increase space, please refer to this documentation Configuring Automatic Database Space Expansion in SAP Adaptive Server Enterprise.

Best regards,
Victoria.

[Former Member]

Adarsh,

You database name would SID of the SAP system.

Try this command to after login to isql

> user master

>go

>disk resize name = "SID_data_001", size = <1024M>

>go

You can choose your own size requirement

Regards

Anand

[former_member198560]

Hi Adarsh,

You can connect to ASE server using isql and then run the sp_helpdb procedure to see the database names along with other details.

Please also refer the SAP Note 1931223 - SYB: SQL Error 1105 - ASE database data and/ or log segment is full.

Automatic Database Space Expansion : http://scn.sap.com/docs/DOC-56403

~Regards Gaurav