Database Size

[sid-desh]

Hi,

I have installed NW Dev Workplace on my machine. In the MMC on the database node i find that it shows that the database if full.

My question is that how can i increase the size of the database. Also once the database is full does the deployment fail often.

Regards

Sidharth

[stefan_seemann]

Hello,

the Onlne help about the Space Management with MaxDB can be found here:

http://help.sap.com/saphelp_erp2004/helpdata/en/08/5742974ae611d1894f0000e829fbbd/frameset.htm

In general when the database becomes full it stops processing.

Then you can add another Datavolume to the Database.

The easiest way to that is to use the Database Manager GUI ( DBMGUI ).

This DBMGUI is only available on Windows but it also allows to administrate databases remotely.

In this GUI connect to your database and the click on "Configuration -> Volumes" then you can just add another Volume until the parameter Maxdatavolumes is reached.

Once no Datavolumes can be attached during Onlinemode you have to restart the database. Then the parameter Maxdatavolumes increases automatically and after the next restart you can add further Datavolumes.

The latest DBMGUI can be downloaded here http://dev.mysql.com/downloads/maxdb/clients.html or ( when you are a SAP customer ) from http://service.sap.com/swdc

Please keep in mind that it won't help to add further Logvolumes when the Log area becomes full.

Then you have to save the log. Then it can be released and the old log is overwritten.

Hope that helps, Stefan