Skip to Content
SAP HANA

DBA Cockpit for SAP HANA: Support for Multitenant Database Containers with SAP HANA SPS09 and Higher

Tags:

You can use DBA Cockpit for SAP HANA to monitor and administer local or remote SAP HANA databases in SAP systems in an ABAP environment.

This post provides an overview of the features in DBA Cockpit for SAP HANA that support SAP HANA multitenant database containers.

Contents

Prerequisites

You can connect to an SAP HANA multitenant database container using any version of DBA Cockpit for SAP HANA, even very old versions.

To use the newest features described in this document, you need to be working with:

  • At least SAP HANA SPS09

AND at least the following SAP_BASIS Support Packages:

  • 7.40 SP10
  • 7.31 SP15
  • 7.30 SP13
  • 7.02 SP17

Connect to an SAP HANA Database in DBA Cockpit

To monitor a remote database in DBA Cockpit, you need to create a connection to that database.


  1. From DBA Cockpit, choose DB Connections -> SAP HANA database -> Add.
  2. Specify the information required.
  3. The SQL port to be used for the connection is entered in the form:
    3xxyy
    xx is the SAP HANA instance number.
    yy is a two-digit number as follows:
    • 3xx15 is for a SAP HANA single-container system
    • 3xx13 is for the system database in a SAP HANA multitenant database container
      The SQL port numbers for tenant databases are normally increased by increments of 3, starting from 41:
      3xx15, 3xx41, 3xx44, or 3xx47 etc.

To find out the instance number:

  • From SAP HANA studio, open the Administration view.
    The instance number is displayed in the title after the host name.
  • If the monitored SAP HANA database is an SAP System, you can log on to the SAP System to see the instance number.
    Choose System -> Status.
    The instance number is displayed in the field Name in the section Database Data.

To find out the SQL port, you can execute the following SQL query:

SELECT DISTINCT(sql_port) FROM SYS.M_SERVICES WHERE SQL_PORT > 0

To open the SQL Console, from SAP HANA studio, right-click over the database and choose Open SQL Console from the context menu.

What Information Does DBA Cockpit Show for Multitenant Database Containers?

Section: Overview

Choose Current Status -> Overview.

An SAP HANA multitenant database container is indicated by “Multitenant database container = Yes”.

To determine whether a database is multitenant or not, DBA Cockpit reads the parameter [multidb] mode in global.ini.

[multidb] mode can be either multidb or singledb.

The SID displayed after this is the system ID of the entire SAP HANA system.

To find the SID of the entire SAP HANA system, DBA Cockpit reads M_DATABASE.SYSTEM_ID.

To find the SID of the database, DBA Cockpit reads M_DATABASE.DATABASE_NAME.

In the example screen below, the Overview shows the system database of the SAP HANA multitenant database container MD2:

If you are working with a tenant database, its name is displayed in the top left corner of the Overview section.

In the example screen below, the Overview shows a tenant database DB0 inside the multitenant database container MD2:

Section: SAP HANA Multitenant Database Containers

This section is displayed only if the you are logged on to the system database.

This section offers the following functions:

Depending on the support package that you have installed, some of these functions may not be available in your system.

These functions are described in the sections that follow.

List of Tenant Databases

You can display an overview of configured tenant databases.

DBA Cockpit reads this information from the schema M_DATABASES.

  • In DBA Cockpit, connect to the system database.
  • Open SAP HANA multitenant database containers.
  • Choose List of tenant databases
    An overview of tenant databases is displayed, showing basic information for each tenant database.


In later support packages, the overview of tenant databases additionally shows alerts, memory used, disks used, and total CPU.
This feature is available with the following SAP_BASIS Support Packages or higher:

  • 7.40 SP12
  • 7.31 SP17
  • 7.30 SP14
  • 7.02 SP18

From this screen, you can stop or start a tenant database, or create a new tenant database.

Note that alerts are only supported with SAP HANA SPS10 (and the above SAP_BASIS Support Packages).

Memory used, disks used, and total CPU are supported with SAP HANA SPS09.

Data Browser for Schema SYS_DATABASES

You can display an overview of the views and tables.

DBA Cockpit reads this information from the schema SYS_DATABASES.

To display the content of a table or view, double-click a row.

Database Name:
If you specify a particular database, DBA Cockpit displays only the content of the selected table or view for that tenant database.

Backup Catalog

DBA Cockpit shows the backup catalog for the entire system and for all the tenant databases.

This feature is available with the following SAP_BASIS Support Packages or higher:

  • 7.40 SP11
  • 7.31 SP15
  • 7.30 SP13
  • 7.02 SP17

Diagnosis Files

DBA Cockpit displays trace files for the entire system and all the tenant databases.

This feature is available with the following SAP_BASIS Support Packages or higher:

  • 7.40 SP12
  • 7.31 SP17
  • 7.30 SP14
  • 7.02 SP18

You can download every file displayed on this screen.

Choose Download  File(s) Content or Download  Compressed File(s) Content.

Schedule Backups of Tenant Databases

You can schedule backups of tenant databases from inside a system database.

  1. In DBA Cockpit, choose Jobs -> DBA Planning Calendar.
  2. To create a new action, drag and drop an action from the Action Pad to a calendar cell in the future.
    You can also drag and drop actions to reschedule them.
    To copy an action, hold down the CTRL key while dragging.
  3. Specify the information required.
  4. Specify the Database Name of a tenant database (or of the system database).
  5. Choose Add to schedule the action.

Alternatively, you can schedule tenant database backups by logging onto a tenant database instead of the system database.

More information: SAP Note 2164096 - Schedule backups for SAP HANA multiple-container systems with DB13

More Information

SCN: SAP HANA SPS10 – What is New for Backup and Recovery - Section: DBA Cockpit for SAP HANA: New Backup Functionality

No comments