on 05-23-2012 3:32 AM
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.
Thanks Ratnajit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
******************************************************
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.