cancel
Showing results for 
Search instead for 
Did you mean: 

Resize Volume in SAPDB

Former Member
0 Kudos

Dear Experts,

Previously i'm sorry if this question is rather out of topic because i can not find group for sapdb question.

Direct to my question, now i already installed sapdb in unix server for sap content server purpose, and my question here is how to resize the existing volume and how to delete it when we think we need to do some database reorganization.

i try to find some literature for this case, but i cannot find the solutions.

Thanks in advance,

Radityo

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

MaxDB has no "resize" function. You can simply add and delete volumes during runtime.

Markus

Former Member
0 Kudos

Hi Markus,

At the moment, i use sapdb 7.3. could you give me some explanation about how to delete the exisiting volume. because i alredy try from DBM GUI and the option delete is always grey, then i try to use dbmcli from OS level, but i can not find command to delete volume, there is only found command db_adddevspace.

I read some forum that the delete volume function is available from version 7.6. Is it right?

thanks for your kind help

-radit-

lbreddemann
Active Contributor
0 Kudos

> At the moment, i use sapdb 7.3. could you give me some explanation about how to delete the exisiting volume. because i alredy try from DBM GUI and the option delete is always grey, then i try to use dbmcli from OS level, but i can not find command to delete volume, there is only found command db_adddevspace.

>

> I read some forum that the delete volume function is available from version 7.6. Is it right?

>

Correct - SAP DB 7.3 does not know this feature.

Anyhow, this version is pretty old and if there is no good reason to stick with it, a ugrade to 7.6 or 7.7 will bring a lot of benefits.

regards,

Lars

Former Member
0 Kudos

Thanks for all answer, i'll add point for any answer today.

best regards,

radityo

Answers (2)

Answers (2)

former_member188065
Participant
0 Kudos

In v7.9 I was able to.

dbmcli -d SID -U c db_expandvolume 2 3932160

above example will grow (shrink isn't posible) Volume 2 to 30GB (size in 8k blocks)

That way datafile reorg will become more easy to manage.

Remember the golden rule optimal datafile size and number for maxdb is the square, eg. for a 900GB database it would be 30 files of 30GB evenly distributed over 3 filesystems in the order ABC, ABC, and so on.

lbreddemann
Active Contributor
0 Kudos

> Direct to my question, now i already installed sapdb in unix server for sap content server purpose, and my question here is how to resize the existing volume and how to delete it when we think we need to do some database reorganization.

Just to add to Markus' comment:

There is no such thing as reorganization for MaxDB - you never do that. You simply never have to.

Should you, e.g. discover that creating on of your data volumes with just 20 MB wasn't the best thing to do, you can simply delete it while the database is up and running.

MaxDB will automatically copy the content of the file you want to drop to the other volumes.

That way you can also manage to 'move' a datavolume without downtime.

regards,

Lars