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].Using the SQL console in SAP HANA Cockpit, set the parameter max_parallel_io_requests=128 in the global.ini file by running the following commands:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[DATA]') = '128';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[LOG]') = '128' WITH RECONFIGURE
The following figure shows what the fileio section of global.ini looks like in the SAP HANA Cockpit after the parameters are set:
Figure 13. SAP HANA 2.0 parameters in global.ini fileio
Both async_read_submit=on and async_write_submit_blocks=all are set by default during installation. For more information, see SAP Note —Elimination of hdbparam in SAP HANA 2 (access requires SAP user credentials).
Note: The instructions in this guide for tuning file I/O parameters are based on SAP HANA 1.0 and SAP HANA 2.0 SPS04. See the latest SAP HANA documentation for any later updates.