on 03-19-2009 3:10 AM
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
MaxDB has no "resize" function. You can simply add and delete volumes during runtime.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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-
> 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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.