Before you run the installation script, prepare the following two configuration files:
The installation uses the global.ini file to describe the SAP HANA storage partitions and the storage connector. The SAP HANA-certified Dell EMC storage platforms use fcClient, which is part of the SAP software distribution.
Follow these steps:
Figure 5. Global.ini file storage content
Larger SAP HANA scale-out installations require additional partition entries.
SAP HANA SPS 07 introduced the SAP HANA Database Lifecycle Manager to provide the efficiency of installing all components at one time, while automating the installation and providing further flexibility to customers. Our example uses hdblcm to install our SAP HANA 3+1 scale-out cluster.
Follow these steps:
cd /<installation media>/DATA_UNITS/HDB_LCM_LINUX_X86_64
./hdblcm --action=install --dump_configfile_template=PMX_install.cfg
Directory root to search for components
Components ( Valid values: all | client | es | ets | lcapps | server | smartda | streaming | rdsync | xs | studio | afl | pos | sal | sca | sop | trd | udf )
Installation Path ( Default: /hana/shared )
Local Host Name ( Default: server06 )
Directory containing a storage configuration
SAP HANA System ID
# System Administrator User ID
ID of User Group (sapsys)
Action to be performed ( Default: exit; Valid values: install | update | extract_components )
The hdblcm installation procedure prompts you for any missing passwords or parameters.
After you have created and customized the global.ini and the installation parameter files, start the installation by running the following command:
./hdblcm --action=install –-configfile=PMX_Install.cfg
The base layer of SAP HANA provides two file I/O interfaces:
You can configure the SAP HANA file I/O layer with configuration parameters to optimize file I/O for a given storage array and file system. The Linux XFS file system is used on all Dell EMC storage LUNs for the HANA persistence.
After the SAP HANA persistence is installed on PowerMax LUNs, set the following file I/O layer parameters for optimal I/O processing:
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 [DATA].max_parallel_io_requests=256
hdbparam –-paramset fileio [LOG].max_parallel_io_requests=256
hdbparam –-paramset fileio [DATA].async_read_submit=on
hdbparam –-paramset fileio [LOG].async_read_submit=on
hdbparam –-paramset fileio [DATA].async_write_submit_blocks=all
hdbparam –-paramset fileio [LOG].async_write_submit_blocks=all
Starting with SAP HANA 2.0, the hdbparam command-line tool was deprecated. Instead, the parameters are defined in global.ini > [fileio].
Using the SQL console in SAP HANA studio, set the max_parallel_io_requests=256 parameter in the global.ini file by running the following commands:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[DATA]') = '256';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[LOG]') = '256' WITH RECONFIGURE;
The following figure shows what the fileio section of global.ini looks after the parameters are set:
Figure 6. Fileio section of the global.ini file in SAP HANA Studio
Both async_read_submit=on and async_write_submit_blocks=all are set by default during the installation. For more information, see SAP Note 2399079: Elimination of hdbparam in SAP HANA 2 (access requires an SAP username and password).