Adding a New System for a Standalone HANA Database

If you want to monitor a standalone HANA database as a separate system, you must choose one of the following scenarios:

  1. Monitoring the standard HANA database through the default database connection on the central monitoring system

    The HANA database is the standard database of the central SAP system. No additional database connection (DBCON) is needed, but you can use the database connection DEFAULT. If you do not want to monitor the standard HANA database through the already monitored SAP system, you can start the additional collector jobs as mentioned at the beginning.

  2. Monitoring the HANA database through a secondary database connection on the central monitoring system

    The HANA database is not the standard database of the central SAP system. In this scenario, you must create the secondary database connection for the HANA database on the central SAP system as described in the chapter Creating a Secondary HANA Connection.

  3. Monitoring the HANA database on the remote SAP system connected via RFC destination

    The HANA database is installed on the remote SAP system. When adding a new system for the HANA database in this scenario, you must define the following:

    1. A working RFC destination to be able to communicate with a remote SAP system.

    2. A valid database connection name (DBCON) available on the remote SAP system to be able to communicate with the HANA database.

      If the HANA database is the standard database of the remote SAP system, the default database connection can be used as mentioned in scenario 1.

      If the HANA database is not the standard database of the remote SAP system, the secondary database connection must be used as mentioned in scenario 2.

Based on your selected scenario, on the central monitoring system, proceed as follows to add a new system for standalone HANA database monitoring:

  1. Start transaction /DVD/MON.

  2. In the main toolbar, click Add system (Shift+F1).

  3. Select the main system type HANA Database.

  4. Click Confirm.

  • The screen HANA DB system appears.

  1. In the System name field, enter a system name, e.g. HANA_DB.

  2. In the Description field, enter a suitable description.

  3. In the DB connection field, enter a valid database connection name based on the selected scenario.

  4. Click Check database connection to ensure that the database connection works correctly.

  • If any error occurs, click Open DBCO transaction next to the database connection field and maintain this connection according to the steps described in the chapter Creating a Secondary HANA Connection.

  • You can test this database connection by executing the report ADBC_TEST_CONNECTION or directly via transaction DBACOCKPIT on the central SAP system.

  1. Optional: If the HANA database is monitored from a central SAP system, leave the RFC destination field empty.

NOTE If you want to monitor the HANA database from a remote SAP system (see scenario 3 above), you must enter a valid RFC destination in order to provide a configured ABAP connection to a remote SAP system. If you fill out the RFC destination field, ensure that the defined DB connection name exists on the remote SAP system. If not, you must create a new database connection for the HANA database on this remote SAP system as described in the chapter Creating a Secondary HANA Connection.
You can change the value Timeout [s] to set the maximum time in seconds for the RFC connection ping:

  • If the RFC connection does not respond after the maximum time set here, a red light icon is displayed in the list of monitored systems. This icon indicates that the system is not accessible.

  • The recommended value for the RFC connection ping is at least 10 seconds (also for fast connections).

  1. Click Confirm to add the system.

  • A screen appears with the auto-detected database server(s).

  1. Ensure that the Monitor flag is selected.

  2. Click Confirm.

    The system automatically detects the IP address for all database servers, which is used as the full network address of this server. If necessary, you can adjust this address in the system settings.

    If any database node on HANA is configured as a standby node, this node is also detected in the list of servers. However, these servers are not monitored by default.

After confirming the database server(s), the new system for the standalone HANA database is added.

You can start the monitoring of the standalone HANA database by clicking Start default monitoring in the menu bar. This starts the collector jobs for HANA database monitoring.