Ask Sawal

Discussion Forum
Notification Icon1
Write Answer Icon
Add Question Icon

How to disable fda in hana?

3 Answer(s) Available
Answer # 1 #

Fast data access (FDA) is a protocol which is accessible in the environments of SAP ABAP. It allows for the submission of open SQL SELECTs against SAP HANA, making the use of the data format of SAP ABAP. Here, the transfer of a SAP ABAP table to the database and back takes place. This method of approach does away with the requirement for field-wise copying and conversion of data.

The main advantage of FDA is that eliminating conversion overhead can lead to lesser resource utilization and enhanced performance.

FDA has been available from the start SAP ABAP kernel 7.42. When it comes to FOR ALL ENTRIES statements, FDA can be used with SAP ABAP kernel 7.43 and higher variations.

SQL: "HANA_Configuration_MiniChecks" (SAP Docs 1969700, 1999993) returns a prospectively critical issue (C = 'X') for one of the individual checks listed below:

A number of parameters are available for the configuration of fast data access, as listed below. It is important to know that any divergence from the default should only be applied in case of a specific problem scenario, for example based on the advice of SAP support or on the basis of the guidelines that are given in a SAP Doc.

The following problems exist in the fast data access area:

The SQL statements that originate from FDA requests are tagged with a comment which is included in the SQL text and can be located in traces (e.g. ST05) or the SAP HANA SQL cache (e.g. transaction DBACOCKPIT or SAP HANA Studio):

For example:

SELECT /* FDA READ */ * FROM "DD03K" WHERE "TABNAME" = ?SELECT /* FDA WRITE */ DISTINCT  "T100" . "ARBGB" , "T100" . "MSGNR" , "T100" . "SPRSL" , "T100" . "TEXT" FROM "T100" , ? AS "t_00" (C_0 NVARCHAR(3), C_1 NVARCHAR(20)) WHERE "T100" . "MSGNR" = "t_00" . "C_0" AND "T100" . "ARBGB" = "t_00" . "C_1" AND "T100" . "SPRSL" IN ( ? , ? , ? )

On the basis of these tags you can filter the executed FDA SQL statements for example using SQL:

[0]
Edit
Query
Report
Solange Vito
Conductor
Answer # 2 #

Fast data access (FDA) is a protocol which is accessible in the environments of SAP ABAP. It allows for the submission of open SQL SELECTs against SAP HANA, making the use of the data format of SAP ABAP. Here, the transfer of a SAP ABAP table to the database and back takes place. This method of approach does away with the requirement for field-wise copying and conversion of data.

The main advantage of FDA is that eliminating conversion overhead can lead to lesser resource utilization and enhanced performance.

FDA has been available from the start SAP ABAP kernel 7.42. When it comes to FOR ALL ENTRIES statements, FDA can be used with SAP ABAP kernel 7.43 and higher variations.

SQL: "HANA_Configuration_MiniChecks" (SAP Docs 1969700, 1999993) returns a prospectively critical issue (C = 'X') for one of the individual checks listed below:

A number of parameters are available for the configuration of fast data access, as listed below. It is important to know that any divergence from the default should only be applied in case of a specific problem scenario, for example based on the advice of SAP support or on the basis of the guidelines that are given in a SAP Doc.

The following problems exist in the fast data access area:

The SQL statements that originate from FDA requests are tagged with a comment which is included in the SQL text and can be located in traces (e.g. ST05) or the SAP HANA SQL cache (e.g. transaction DBACOCKPIT or SAP HANA Studio):

For example:

[0]
Edit
Query
Report
Ikraam Park
DISPATCHER RADIO
Answer # 3 #
  • Fast Data Access optimization can be deactivated by setting the parameter rsdb/supports_fda_prot=0 in the instance profile of the ABAP server.
  • If in case if the SAP HANA connection is a secondary connection, the parameter dbs/hdb/supports_fda_prot=0 must be set.
[0]
Edit
Query
Report
Manjula Kalra
HEAD BANDER AND LINER OPERATOR