Skip to main content
NetApp solutions for SAP

Contributors netapp-mschoen
PDFs

Single host setup

This chapter describes the setup of an SAP HANA single host.

LUN configuration for SAP HANA single-host systems

The Linux LVM is being used to increase performance and to address LUN size limitations.
At the SAP HANA host, volume groups and logical volumes need to be created and mounted, as indicated in the following table.

Logical volume/LUN Mount point at SAP HANA host Note

LV: FC5_data_mnt00001-vol

/hana/data/FC5/mnt00001

Mounted using /etc/fstab entry

LV: FC5_log_mnt00001-vol

/hana/log/FC5/mnt00001

Mounted using /etc/fstab entry

LUN: FC5_shared

/hana/shared/FC5

Mounted using /etc/fstab entry
Note With the described configuration, the /usr/sap/FC5 directory in which the default home directory of user FC5adm is stored, is on the local disk. In a disaster recovery setup with disk-based replication, NetApp recommends creating an additional LUN for the /usr/sap/FC5 directory so that all file systems are on the central storage.

Create LVM volume groups and logical volumes

  1. Initialize all LUNs as a physical volume.

    pvcreate /dev/mapper/svm1-FC5_data_mnt00001_1
pvcreate /dev/mapper/svm1-FC5_data_mnt00001_2
pvcreate /dev/mapper/svm1-FC5_log_mnt00001_1
pvcreate /dev/mapper/svm1-FC5_log_mnt00001_2

  2. Create the volume groups for each data and log partition.

    vgcreate FC5_data_mnt00001 /dev/mapper/svm1-FC5_data_mnt00001_1 /dev/mapper/svm1-FC5_data_mnt00001_2
vgcreate FC5_log_mnt00001 /dev/mapper/svm1-FC5_log_mnt00001_1 /dev/mapper/svm1-FC5_log_mnt00001_2

  3. Create a logical volume for each data and log partition. Use a stripe size that is equal to the number of LUNs used per volume group (in this example, it is two) and a stripe size of 256k for data and 64k for log. SAP only supports one logical volume per volume group.

    lvcreate --extents 100%FREE -i 2 -I 256k --name vol FC5_data_mnt00001
lvcreate --extents 100%FREE -i 2 -I 64k --name vol FC5_log_mnt00001

  4. Scan the physical volumes, volume groups, and vol groups at all other hosts.

modprobe dm_mod
pvscan
vgscan
lvscan
Note If these commands do not find the volumes, a restart is required.

To mount the logical volumes, the logical volumes must be activated. To activate the volumes, run the following command:

vgchange -a y

Create file systems

Create the XFS file system on all data and log logical volumes and the hana shared LUN.

mkfs.xfs FC5_data_mnt00001-vol
mkfs.xfs FC5_log_mnt00001-vol
mkfs.xfs /dev/mapper/svm1-FC5_shared
Note The multiple host example commands show a 2+1 multiple-host HANA system.

Create mount points

Create the required mount point directories, and set the permissions on the database host:

sapcc-hana-tst:/ # mkdir -p /hana/data/FC5/mnt00001
sapcc-hana-tst:/ # mkdir -p /hana/log/FC5/mnt00001
sapcc-hana-tst:/ # mkdir -p /hana/shared
sapcc-hana-tst:/ # chmod –R 777 /hana/log/FC5
sapcc-hana-tst:/ # chmod –R 777 /hana/data/FC5
sapcc-hana-tst:/ # chmod 777 /hana/shared

Mount file systems

To mount file systems during system boot using the /etc/fstab configuration file, add the required file systems to the /etc/fstab configuration file:

# cat /etc/fstab
/dev/mapper/hana-FC5_shared /hana/shared xfs defaults 0 0
/dev/mapper/FC5_log_mnt00001-vol /hana/log/FC5/mnt00001 xfs relatime,inode64 0 0
/dev/mapper/FC5_data_mnt00001-vol /hana/data/FC5/mnt00001 xfs relatime,inode64 0 0
Note The XFS file systems for the data and log LUNs must be mounted with the relatime and inode64 mount options.

To mount the file systems, run the mount –a command at the host.