What Is FSD In SAP HANA

HANA www.basisguru.com

In today’s article we will discuss what is FSD and how do we generate it.

What is FSD?

FSD is called as SAP HANA full system dump.
For analyzing the issue at HANA DB level, SAP demands FSD: SAP HANA full system info dump which is a collection of trace and configuration files.

It consists of the HANA DB information like
Trace files containing crash dump files, configuration files for all HANA services, topology, One RTEdump per service (only for SAP HANA 1.0).

What topology information is provided?

  • if system is single database or multiple database container MDC
  • system/tenant DB creation timestamp.
  • Host configuration
  • Hardware information
  • CPU model, cores/OS version, kernel version,
  • As of SAP HANA 2.0 No of sockets
  • HANA services details and their state.

Additional information available as of SAP HANA 2.0

  • SAP HANA upgrade history
  • Details of encryption
  • /etc/hosts file information
  • SSFS keys and their location
  • Kerberos file information

We can collect the Full system dump using multiple ways using

  1. HANA studio
  2. HANA cockpit
  3. python script.

Let us dicuss each method to generate HANa full system dump.

Using HANA Studio:

Goto SYSTEM DB or Tenant DB and select diagnostic file tab:

<img src=“FSD HANA Studio Diagnostic files.jpg” alt=“CDiagnostic files tab in SAP HANA studio ” title=“Diagnostic files tab”>
Fig1: FSD using HANa Studio

On left side, you’ll get Diagnosis Information drop down switch ,From drop down, select Collect option:

<img src=“FSD Diagnostic information.jpg” alt=“Collection of Diagnostic information ” title=“Diagnostic File tab”>

Click on collect,to start collecting all trace files:

<img src=“FSD Diagnostic information.jpg” alt=“Collection of Diagnostic information ” title=“Diagnostic File collection”>

File with below syntax will be generated:

[ fullsysteminfodump_< localhost >_< sapsid >_< yyyy >_< mm >_< dd >_< hh >_< mm >_< ss >.zip ]

For e.g:

fullsysteminfodump_hostname_linux_2020_02_02_14_59_33.zip

This file can be viewed in the history drop down option:

<img src=“FSD Diagnostic File history.jpg” alt=“Diagnostic File history in SAP HANA Studio ” title=“Diagnostic File history”>

Method: 2 Using HANA cockpit:

In case of Cockpit, you need to go to Manage Full System Information Dumps application and generate FSD

Method: 3 Using OS Level Python script:

  • Login with sidadm user and goto directory /usr/sap/SID/HDB<xx>/exe/python_support .
  • Find & execute the script python fullSystemInfoDump.py <options> to generate full system dump.
<Option> : --days=<number_of_days>

Note: use SIDAM user to execute thi script or we might get error like ImportError: No module named pyhdbcli