Scale Up
To see where the filesystem is mounted to for a scale up or single node implementation execute the following :
SELECT VALUE FROM M_INIFILE_CONTENTS
WHERE FILE_NAME = 'global.ini'
AND SECTION = 'persistence'
AND KEY = 'basepath_datavolumes'
AND VALUE NOT LIKE '$%'
The value returned will include the database name at the end (e.g. SH1 will correspond to /hana/data/SH1) the mount point needed to interact with is the directory above the database name (e.g. /hana/data/SH1 becomes /hana/data/).
Scale Out
To see the hosts and filesystem mount point locations for all of the data volumes in a scale out / distributed system implementation execute the following:
SELECT HOST, STORAGE _ID, PATH, KEY, VALUE
FROM SYS.M_ATTACHED_STORAGES WHERE KEY = 'WWID'
AND PATH LIKE (SELECT CONCAT(VALUE,'%')
FROM M_INIFILE_CONTENTS
WHERE FILE_NAME = 'global.ini'AND SECTION = 'persistence'
AND KEY = 'basepath_datavolumes'
AND VALUE NOT LIKE '$%')
The values returned inform the user of the following:
- HOST - The SAP HANA host which the data volume is currently mounted to and being used by.
- STORAGE_ID - A Storage ID assigned by SAP HANA to the volumes used in the scale out deployment.
- PATH - The mount point at which the filesystem is mounted to.
- VALUE - This is the serial number of each volume, as exposed to the filesystem. This value can be used to match the SAP HANA data volume to the block device on FlashArray.