Managing Data Volumes in MaxDB

[suhan_hegde]

Hello,

Due to an upgrade from ERP 6.0 to ERP 6.0 EHP5, I had to add new data volumes to my MAXDB database.

I created 6 data volumes of 9.5GB and 2 data volumes of 38GB.

i am not too worried about the 9.5 GB data volumes since they are close to 50% free.

However the 38GB data volumes are filled to only around 13%. This consumes a lot a space on my server.

Is there anyway to reorganize the database? I need to free-up some space on the server.

I am new to MaxDB.

Thanks,

Suhan Hegde

[former_member229109 · Accepted solution]

Hello Suhan Hegde,

1. Please see the documents "Deleting Data Volumes" and "Volumes (Permanent Storage) " in MAXDB library at

http://maxdb.sap.com/doc/7_8/44/d77a6368113ee3e10000000a114a6b/content.htm

2.

As you need to free-up some space on the server, please check that you have the permanent dataarea usage less as 9.5*6 GB first. Create the complete databackup, just to be safe. Then delete the datavolumes of the size 38GB when database is online, the data from the specified data volumeswill be distributed to the remaining data volumes. More details in recommended document "Deleting Data Volumes", see 1., or you could use db_deletevolume, see document at

http://maxdb.sap.com/doc/7_8/44/eefb7ab942108ee10000000a11466f/content.htm

or

you could do it using backup/restore procedure steps: create complete backup, initialize instance for restore and change the datavolumes configuration, then continue with restore.

3. If you are SAP customer => Please review SAP notes:

SAP Note No. 1173395

SAP note No. 1423732 < see 13. >

4. There are online traning sessions at

http://maxdb.sap.com/training/

Regards, Natalia Khlopina

[suhan_hegde]

Thanks you very much.

[Former Member]

If you dont find the parameter in the DBM gui, under

Instance -> Configuration ->Parameters

then choose,

Actions -> Show Extended and Support Parameters

You can always use the DBM CLI

dbmcli u2013 d <database_name> (connects to the database)

and set or display parameters........

[Former Member]

Due to the shadow memory concept and the dynamic storage management, reorganization is not necessary for MaxDB.

Depending on what version you are using, use the following parameter for even distribution/movement of pages across data volumes.

EnableDataVolumeBalancing YES

Why did you create 9.5GB volumes and 38GB volumes? why so much difference?

For easy management, you may have them all same of some reasonable size. Anyways, read the MaxDB admin guide

and to start with read the FAQs listed in SAP Note - 846890

MaxDB documentation available at - https://www.sdn.sap.com/irj/sdn/maxdb

Regards,

Sai R.

[suhan_hegde]

Hi Sai,

I am using version 7.8 of MaxDB.

The reson i used this size for the 2 data volumes was that the upgrade was erroring out on other extensions so i thought the better idea would be to go big on the volume.

Is there anyway I could reorganize.

I could not find the parameter EnableDataVolumeBalancing in the DBM GUI.

Thanks

Suhan

[former_member188883]

Hi Suhan,

Refer the link http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo-UsageofMultipleLogPartitions

Section Reconfiguration of multiple log partitions

Follow the same process for data volumes. It should work.

Regards,

Deepak Kori