The base layer of SAP HANA provides two file I/O interfaces:
You can configure the SAP HANA file I/O layer to optimize file I/O for a specific file system and storage system.
Note: The Linux XFS file system is used on all Dell EMC storage volumes for the SAP HANA persistence.
After the initial SAP HANA installation is complete, set the parameters by running the SAP HANA hdbparam command as <sid>adm in the Linux shell:
su - <sid>adm
hdbparam –p # lists current parameter setting
hdbparam –-paramset fileio [LOG].max_parallel_io_requests=128
hdbparam –-paramset fileio [LOG].num_completion_queues=4
hdbparam –-paramset fileio [LOG]. num_submit_queues=8
Effective from SAP HANA 2.0, the hdbparam command-line tool has been deprecated. Instead, the parameters are defined as normal parameters in
global.ini > [fileio]. Using the SQL console in the SAP HANA Cockpit, set the parameters in the global.ini file by running the following commands:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[LOG]') = '128';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','num_completion_queues[LOG]') = '4';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','num_submit_queues[LOG]') = '8' WITH RECONFIGURE
The following figure shows what the fileio section of global.ini looks like in the Cockpit after the parameters are set: