MaxDB related Urgent

[Former Member]

Hi Basis,

We have the NSP server with MaxDB as the database server, today it is showing the disp+work.exe in brown color . I read the all log files the reason is DataBase is full.

How to solve this problem, I am trying to do the backup of using dbmcli it was giving error.If tried with db_connect command

-24798,ERR_DATAFULL: Data area is full.

1)How to do the backup and how to increase the memory size and how to know the DB size.

2)what tools i have to use.

Let me know .

Thanks & Regards,

Vivek.

[JPReyes · Accepted solution]

Seems like you need to add a new volume to your database...

Use MaxDB DB manager.

Check the parameters 'param_addvolume' and 'db_addvolume'..the go into Admin mode and use following command to add a volume,

dbmcli -d <SID> -u db_adddevice data <filename> <vol pages>

Then restart your DB.

Regards

Juan

[Former Member · Accepted solution]

Hello Juan,

Thanks for your response, I already have been done this extension.

But I need how to free up the memory after backup done and how to do the backup with dbmcli (backup_start command) otherwise i need to use third party tools.

Thanks & Regards,

Vivek.

[Former Member · Accepted solution]

Hi,

Any one Please let me know how to solve this ..

Thanks & regards.

Vivek.

[Former Member · Accepted solution]

Hi. Read the Note 338903 - Backint for MaxDB connection , also the good if you install the Database Manager GUI .Read this documents :

http://help.sap.com/saphelp_nw70/helpdata/en/e8/1835f553214549bc2d3110aa4dab1d/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/7a/ea493905e6d07de10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/5e/aeb431c2b9d44986218a9ff4063ad8/frameset.htm

Note 767598 - Available documentation.

Regards. Award if helpful.

[roland_mallmann]

Hi,

you can use the Database Manager GUI or Database Studio to conveniently create data & log backups, add new volumes etc.

You can download both of these tools here:

[SAP MaxDB - Community Edition - Download|https://www.sdn.sap.com/irj/sdn/maxdb-downloads]

These tools will also show you how much space is already in use by the DB and ofcourse how much you've still got left.

If you really need to free up space, you need to think about archiving data.

Regards,

Roland