cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB : /local/sapdb/ occupied 100%.

former_member268919
Participant
0 Kudos

Hi Folks,

We have a SAP system with database as MaxDB 7.x

We have found that directory /local/sapdb/ is occupied 100%.

This direcoty has sub-directories /local/sapdb/data/wrk/SID.

Can anyone suggest what files can be cleared or moved so i can have free space in /local/sapdb.

Thanks in advance.

Regards,

Trev.

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member268919
Participant
0 Kudos

Thanks Ratnajit.

former_member268919
Participant
0 Kudos

Hi,

I have three sub-directories under

SID_20120424_12-27-19

SID_20120522_03-36-44

History_KnlMsg

59> du -sg *|sort -nr|head -10

7.18    SID_20120522_03-36-44

0.11    SID_20120424_12-27-19

0.01    History_KnlMsg

Regards,

Trev

former_member189725
Active Contributor
0 Kudos

You can move the directory SID_20120522_03-36-44 to some other location just incase you want to analyze the files within it. This would free up space . This would not effect the running of the system .

A small extract from the Maxdb wiki in SCN

******************************************************

DIAGHISTORY

Directory DIAGHISTORY is a subdirectory of the rundirectory.
When the database determines during the startup that the previous shutdown was not a 'normal' shutdown but an emergency shutdown or a crash, the most important log files are copied to the DIAGHISTORY. In this directory a directory is created which is called <database name>_<timestamp>. The timestamp is the time of this restart - not of the crash.
These are the files which are copied/moved - if they have been written:
knldiag, knltrace, knldump, rtedump, *.dmp, *.buf, *.stm, core

The location of the DIAGHISTORY directories can be changed using the database parameter DIAG_HISTORY_PATH.
The number of histories which are stored can be changed using the database parameter DIAG_HISTORY_NUM. The default is 2.

If the log files cannot be copied successfully the database is nevertheless started.

***************************************************************************

Hope this helps.

Regards

Ratnajit

former_member268919
Participant
0 Kudos

Hi Ratnajit,

The following path under /local/sapdb occupied the highest space(/local/sapdb/data/wrk/SID/DIAGHISTORY).

I would like to know any such subdirectories where unwanted files may be generated and can be deleted.

Regards,

Trev.

former_member189725
Active Contributor
0 Kudos

How many subdirectories are there under the directory  /local/sapdb/data/wrk/SID/DIAGHISTORY ??

You can leave the last 2 for analysis and remove the rest .

Please verify if the database parameter DIAG_HISTORY_NUM is set to 2 .

Regards

Ratnajit

former_member189725
Active Contributor
0 Kudos

Can you figure out as to which directory is occupying more space .

Go to /local/sdb

then execute du - sk . | more

Check which directory/files are occupying more space.

Regards

Ratnajit