This blog highlights filesystems/directories/files that don’t have any housekeeping by default.
/sapmnt/SID/global This contains WF_LOG…_002 where 002 is the client number. Remove all older than 3 days.
/usr/sap/trans/data Only *SAP files can be deleted. Leave the cofiles alone.
/usr/sap/trans/log Compress the SAP* logs. gzip -9 SAP* Does it nicely.
/usr/sap/trans/EPS/in After support packs have been imported, the *PAT and *ATT files can be deleted.
/usr/sap/trans If there are any *car or *CAR files they can be deleted. Leave the CAR executable though.
/oracle/SID/saparch Delete all *svd files older than 3 months.
/oracle/SID/sapbackup Delete all files older than 3 months.
oracle/SID/saptrace/background Copy alert_SID.log to alert_SID.log_MMYY. re-initialise alert_SID.log. Delete all files older than 3 months.
oracle/SID/saptrace/usertrace Delete all files older than 3 months.
/oracle/SID/sapcheck Delete all files older than 3 months.
/oracle/SID/sapreorg Files and directories to be house kept are the ones with the following format. YYMMDDHHMM. These files have a number of different extensions. Delete all files and directories older than 3 months.
For trans Directory alone use below steps
# – /usr/sap/trans/data/*.sap (after 60 days, 30 days on prod systems)
# – /usr/sap/trans/log/CC* (all but last for each client, after 30 days)
# – /usr/sap/trans/log/SAP* (after 215 days)
# – /usr/sap/trans/EPS/in/* (after 7 days)
# – /usr/sap/trans *.CAR (after 7 days, except on WGP)
# – /usr/sap/SID/INSTANCE/log/audit* (after 90 days) (ref 379858)
To remove the files which is older than 10 days. you can change the -10 to number of days.
find . ! -mtime -10 /usr/bin/xargs rm -rf
This blog answers the below queries
- If file systems in SAP server is full, what need to be done?
- How to avoid file system full in SAP?
- How to delete un necessary files in file systems of SAP?
- How to delete core files in SAP?
- How to delete trace files in SAP?
- How to delete stat files manually in SAP?
- What is the transaction code used to delete stat files manually in SAP?
- What are various reports to be run to cleanup when file system is full?
- How to prune the file systems in SAP?
- How to delete old archive files in SAP?
- What is the location of work and data directories in SAP?
- What is the location of global directory in SAP?
- Can we delete old page file and role files when the SAP system is online?
- What is the sap parameter to set the trace level in SAP?
Sometimes, a basis consultant will get alerts or information from customers that the file systems are full. To avoid system issues and to increase availability of the SAP system, In those cases, we have 2 options.
i) Delete unnecessary files in the file system
ii) In case you found file system is defined as too small then increase the size of them.
In this blog, am covering the option 1 mentioned above.
Let us assume that the system id(SID) of the sap system is DP1. Then the
i) work directory in (Unix, WindowsNT operating system) is /usr/sap/DP1/DVEBMGSnn/work (where nn is the instance number)
ii) data directory in (Unix, WindowsNT) is
/usr/sap/DP1/DVEBMGSnn/data (where nn is the instance number)
iii) Global directory (i.e. for all instances) is
/sapmnt/DP1/global (for UNIX )
\\<sapglobalhost>\sapmnt\DP1\sys\global (for WindowsNT)
Please follow below steps to avoid this issue :
1) Delete core files from work directory
Work directory in Unix often contains old core files which were generated due to previous program terminations. These core files need to be deleted
2) Delete old log files and spool files
Under global directory there will be many log files which can be deleted regularly.
Those files are
Log file type Naming Convention
Spool requests nnnSPOOL ( where nnn=client)
Job logs nnnJOBLG
Batch input logs BI<hostname><instance-number>
Following reports can be run using SE38 or through background job for selective deletion of the files mentioned above.
RSPO0041 – This report is used for deletion of old spool files
RSBTCDEL – Used for deletion of old job logs
RSBDCREO – Report can be used for deletion of batch input log files and reorganization.
3) Deletion of old ABAP/4 trace files
Some trace files with the name AT<instance number>nnnn will be in the data directory. Old files of this type can be deleted. The maximum available space for all files is defined by the parameter abap/atrasizequota. Also transaction SE30 can be used to delete the files.
4) Deletion of old archiving files
When old data is archived, some files are written to the global directory. The naming convention of those files is Rxxmmddn (xx= application, mm= month, dd=day, n=number). For example, RMM11056
If these files are already saved on tape and these data is no longer required for productive operation, then these files can be deleted from the disk
5) Deletion of old output requests
Output requests are normally stored on the data directory. Naming convention will be like SP*. Under normal scenarios, they are deleted automatically when the output is completed. In case you see they are not getting deleted, you can delete the same
6) Page file and Roll file
Under the data directory, normally page files and roll files are stored. Naming convention will be like PAGFILnn and ROLLFLnn. Please note that page file and roll files can only be deleted when the corresponding SAP instance is offline.
Deleting these files hardly makes any sense because these files will start growing to the allowed maximum extent during the R/3 system start up. However in some special scenarios (during or after client copy), the required space can be retrieved by deleting these files. As mentioned earlier, please note that this can be done only when the instance is offline.
The maximum size of the roll file is given by
(rdisp/ROLL_MAXFS – rdisp/ROLL_SHM) * 8 Kbytes
A similar formula applies to the paging file also.
In some scenarios, to avoid the file system full issue, we can even move these page and roll files to a different file system by defining alternate values for R/3 parameters DIR_ROLL and DIR_PAGING
7) Deletion of Old sort and Extract files
By the ABAP commands SORT and EXTRACT, temporary files are created. The location of these files are set using profile parameter DIR_SORT or DIR_EXTRACT.
The temporary files for sort are named S+++++++<Extension> (On Windows NT .dat is used as extension and on Unix there is no extension). Similarly for Extract, E+++++++<Extension> will be the file naming convention.
These files will be automatically deleted after the execution of these SORT and EXTRACT commands. However, in some scenarios, an abrupt termination can happen and these files won’t get deleted automatically. Those old files can be deleted by an administrator.
The exact file names for these are stored in the profile parameters FN_SORT or FN_EXTRACT
8) Deletion of trace files
Trace files are created during a new system start up and they can be deleted. They are contained in the work directory
9) Deletion of stat file or moving to different location
Please check whether the stat file which consists the work load statistics, has not been reorganized for some time and has therefore become too large. In emergency cases, this file can be either deleted manually or can be moved to different location.
To delete the stat file manually, please proceed as follows:
Go to ST03 transaction , call the delete function on the relevant instance by choosing :
Workload -> Reorganize -> Delete seq.stat.file
To change the location of stat file, change the value of system parameter ‘stat/file’ to a new location.
10) Deletion of job logs at operating system level
In some emergency cases, where you cannot start the R/3 system at all, the measure is to delete the job logs at operating system level and run RSBTCDEL report in forced mode.
Note: How to delete job logs at operating system level will be covered in a separate article later
11) Changing the trace level
If the trace files (dev_*) in the work directory are very large(normal size 0.1 to 20Kbyte), it is likely that the trace level is set to very high value. In SAP, rdisp/TRACE parameter is used to set the trace level. Normal value for trace is 1.
Please cross check this SAP parameter and reset to 1 if the value is maintained as 2 or higher. If this value is set to high, much more detailed trace will be collected and trace file sizes are likely to increase. Therefore recommending to decrease or set the trace level to 1.
I am sure, if you duly follow the steps mentioned above, file system full issues can be addressed. However, if after carrying out all the above steps there is no improvement, then please consider to increase the file system size by requesting space to the relevant team.