The following sections of this guide describe how to:
The configuration example in this guide assumes the following basic installation and configuration operations are complete on the SAP HANA nodes:
Figure 2. Linux native multipathing command
service multipath restart
The SAP HANA persistence must be visible to every node in the SAP HANA cluster. To achieve this, you can run the rescan-scsi-bus.sh command or reboot each node, as described in this section.
To verify that the volumes are visible:
multipath -ll | grep -B1 -A5 512G
Figure 3. List data volumes command
multipath -ll | grep -B1 -A5 256G
Figure 4. List log volumes command
The unique device identifier of the multipath device must match the WWN of the volumes that you created in Unisphere. (When viewed on a Linux host, the WWN of the volume from the PowerMax is now preceded by a 3.)
After all the file systems are created, you are ready to install the SAP HANA scale-out cluster.
SAP HANA NSE uses the data volume that the main database is using. While no special configuration steps are necessary for the NSE persistence layer, sizing must take into account additional capacity for the feature.
When you use the SAP HANA NSE feature, a portion of DRAM is used as a buffer cache to dynamically load paged data from the persistence (data volume). By default, the size of this buffer cache is 10 percent of the total main memory of the system. For more information, see “SAP HANA Buffer Cache” in the SAP HANA Administration Guide.
SAP recommends not exceeding a ratio of 1:8 for the buffer cache and the total amount of warm data handled by SAP HANA NSE. When using SAP HANA NSE, you can store data in the warm tier in the following specific granularities:
Data location handling is built into SAP HANA's Data Definition Language (DDL). Manage the configuration by using the SAP HANA CLI SQL client hdbsql or the SQL editor in SAP HANA Studio or SAP HANA Cockpit.
To create a table using SAP HANA NSE (the warm tier), run the following DDL command:
CREATE T_DELL_NSE (id INT, name VARCHAR(100)) PAGE LOADABLE;
To create a specific column in the warm tier, run:
CREATE T_DELL_NSE (id INT PAGE LOADABLE, name VARCHAR(100));
To move an entire existing table to the warm tier, run:
ALTER TABLE T_DELL_NSE PAGE LOADABLE CASCADE
To move a specific column to the warm tier, run:
ALTER TABLET_DELL_NSE ALTER (name VARCHAR(100) PAGE LOADABLE);
SAP HANA NSE Advisor, which is based on real-time statistics from an existing SAP HANA database, provides recommendations for which data to move from the hot (in-memory) tier to the warm tier (SAP HANA NSE). Use the SAP HANA NSE Advisor information for guidance regarding the amount of data to move to the warm tier on an existing system.
For more information about SAP HANA NSE, SAP HANA NSE Data Sizing, and related topics, go to the SAP Help Portal.