About Diagnosis Files Path on HANA DATABASE(sp04_35)

[Former Member]

hi all

We can read Diagnosis Files on the hana studio.

We think the files are stored on HANA DATABASE.

Would you like tell us the path.

We read installation and Aministrator guides. but did not find.

thanks in advance.

Best Regards,

Akihiro

[lbreddemann · Accepted solution]

Hi Akihiro,

on linux level you can easily navigate to the trace files of one host via the pre-defined shell alias cdtrace:

alias cdtrace='cd $DIR_INSTANCE/$VTHOSTNAME/trace'

As you can see in the path above, the trace files are stored separated per host.

So to get access to the trace files of a multi-node system you'd have to check different paths for each host.

From within SAP HANA you can query the location of the trace files via the monitoring view m_disks:

select * from m_disks where usage_type ='TRACE'

Generally a much more convenient approach to access the files and the contents of the files are the views m_tracefiles and m_tracefile_contents.

While the actual trace information is stored in the files, you can still just select these views to read the data in them.

On top of that, if you don't want to iterate over all files yourself, give m_merged_traces a try.

This view automatically reads all the standard trace files of all nodes and generates a combined overview.

As you can imagine this takes a while - and it is executed every time you select from this view.

Thus, if working with the data from this view it might be a good idea to load its content to a temporary table first and operate on this further.

This is, by the way, the way SAP HANA studio presents the merged diagnosis files.

- Lars

[Former Member · Accepted solution]

hi,Lars

Thank you very much.

We have one  more question.

If trace files become big size.

We should add the disks volumes or delete the trance files.

Would you like tell us can we delete the trace files on OS level and what we should attention about that.

Thanks in advance,

Best Reagrds,

Akihiro

[lbreddemann · Accepted solution]

Hi Akihiro,

the easiest way to get rid of the trace files is to select them in the trace files list in SAP HANA Studio and choose "DELETE" from the context menu.

Unfortunately, for those trace files that are still opened by the indexserver process, the files will disappear from the list (and from the directory) but the storage space will only be released after a restart of the indexserver process.

- Lars

[Former Member · Accepted solution]

hi Lars

Thanks your information.

Would you like tell us if we delete the trace files.

Will the trace files be created again?

We just afraid the disk to become full.

But want to monitor the trace files always.

Thanks in advance

Best Regards,

Akihiro

[lbreddemann · Accepted solution]

Yes, the trace files will be recreated again, if needed.

I wouldn't recommend to delete any of the .001, .002 ... numbered trace files as there should be just 10 of them for each service at a time (although the numbers continuously are counted up).

And these should only take about 10MB each.

What's probably taking more space are large crash dumps, maybe even from revisions you don't use any more.

These can be safely deleted.

- Lars

[Former Member · Accepted solution]

hi Lars

Thank you very much!!!!!!!!!

Best Regards,

Akihiro

[Former Member]

This message was moderated.