The base layer of HANA provides two file I/O interfaces:
The SAP HANA file I/O layer can be configured with configuration parameters to optimize file I/Os for a given file system (the Linux XFS file system is used on all Dell EMC storage LUNs for the SAP HANA persistence) and storage array
After the SAP HANA persistence is installed on Unity LUNs, set the following file I/O layer parameters for optimal I/O processing after the initial SAP HANA installation has been completed:
After the initial SAP HANA installation is complete, set the parameters by using 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=128
# hdbparam –-paramset fileio.async_read_submit=on
# hdbparam –-paramset fileio.async_write_submit_blocks=all
Starting with SAP HANA 2.0, the hdbparam command-line tool has been deprecated. Instead, the parameters are defined as normal parameters in global.ini > [fileio].
Set the parameter as follows in the global.ini file:
Both async_read_submit=on and async_write_submit_blocks=all are set by default during installation.
For more information, see SAP Note 2399079: Elimination of hdbparam in HANA 2 (access requires an SAP username and password).