Delete old HANA database diagnosis trace files

 

Hi all,

Here I am going to show delete HANA old trace file easy workaround for this is this:

    Create another folder, say “old_tracefiles”

    Move all files older than, say 7 days (or whenever you last upgraded to the most recent revision), to this “old_tracesfiles” folder.
 

Follow these steps:

1. Logon to the SAP HANA server as SID.

2. Navigate to the trace file folder

For that, just use the predefined shell command alias ‘cdtrace‘

hanatest:/usr/sap/THR/HDB00> cdtrace

hanatest:/usr/sap/THR/HDB00/hanatest/trace>

3. Create the “old_tracefiles” folder
 

Heres simply create the “old_tracefiles” folder as a sub-folder of the actual trace folder.

You might and probably should create it at a different location, to release the storage space in the trace file folder.

hanatest:/usr/sap/THR/HDB00/hanatest/trace> mkdir old_tracefiles

4. Move old trace files into the new folder:

This can take some time…

hanatest:/usr/sap/THR/HDB00/hanatest/trace>find . -type f -mtime +7 -print | xargs -I {} mv {} old_traces/
If you find that you don’t actually need the trace files any more, you may just go on and delete this folder later on.

In general, it usually doesn’t make sense to keep the trace files generated by older revisions.

Exceptions to this general approach could be, that you faced bugs that you still wait to see fixed or to compare messages from normal/baseline system operations (think of time required for restart, message output during restart/shutdown/backup…).

Source: SAP SCN blog.