Step 1. Verify the System Type

Using SAP HANA Studio connected to any one of the systems deployed with the SAP HANA Instance, navigate towards the configuration page.

Expand the global.ini filename and then further expand the multidb section. Look for the key mode and observe its value. If this value is “singledb” then the system is a single container and if the value is “multidb” the system is then set to be a multiple container system.

Step 1a. If Database is "multidb" Find the Host on which the SYSTEMDB is Running

To identify the host which the SYSTEMDB is running on the nameserver and other non-persistent services needs to be identified. As per the SAP Knowledgebase article (201244) the most notable differences between the list of services running on the SYSTEM DB and tenant database are the nameserver and other non-persistent services are available on the SYSTEMDB. The SYSTEMDB will only ever exist on a single host in a scale out/distributed system environment and cannot be distributed across multiple hosts.

To investigate the services on each system in a scale out/distributed environment the landscape view and services tab is inspected to provide the required information.

The host on which the “nameserver” service and “master” detail are shown, is the system on which the SYSTEMDB is running.

Step 1b. Identify which Host each Storage Device is Mounted to at that Point in Time

The volumes and services used can be identified by selecting the volumes view and viewing the information for the “indexserver” service where “Data Volume Size” has a value. Each data persistence mount point for the scale out/distributed environment will typically be in the form “{BASE_PATH}/Data/<Database Name>/mntXXXXX” but this can vary between each deployment.