The Linux XFS file system is used on all storage volumes for the SAP HANA persistence. You can configure the SAP HANA file I/O layer with certain parameters to optimize file I/O for a given storage solution and file system.

The following sections describe how to set file I/O layer parameters in SAP HANA 1.0 and SAP HANA 2.0.

SAP HANA 1.0

For SAP HANA 1.0 installations, run the SAP HANA hdbparam command as <sid>adm in the Linux shell:

$ su - <sid>adm

$ hdbparam –p      # lists current parameter setting

$ hdbparam –-paramset fileio.max_parallel_io_requests[Data]=128

$ hdbparam –-paramset fileio.max_parallel_io_requests[Log]=128

SAP HANA 2.0

For SAP HANA 2.0 installations, use either hdbsql or the SQL function in SAP HANA Studio or Cockpit. Run the following SQL commands:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio', 'max_parallel_io_requests[Data]') = '128' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio', 'max_parallel_io_requests[Log]') = '128' WITH RECONFIGURE;

For more information, see SAP Note 2399079: Elimination of hdbparam in HANA 2 (access requires an SAP username and password).