Locating Databases in SAP HANA Cockpit

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Use the Database Directory
  • Use the Database Management application
  • Find the SAP HANA database version

Database Directory

The Database Directory in the SAP HANA cockpit displays an aggregated view of all the registered databases belonging to resource groups to which you have been granted access.

For each database, you can drill down for more information. Through the Database Directory, you can also specify the database user credentials required to drill down to an individual database, which is necessary unless single sign-on is in effect for that resource.

Every line gives an aggregated health overview of a registered SAP HANA database. Only the databases that you are assigned to are shown in the list.

The Database Directory provides the following details about each registered database:

  • Status – Displays the status of the database. Possible options are Running, Running with issues, Transitioning, Stopped, No SQL access, License expired, Invalid technical user, or Error.
  • Usage Type – Provides the usage type that was assigned to the database during installation. The available options are Production, Development, Test, and Custom. It is possible to change the usage type after the installation by setting the parameter global.inisystem_informationusage to one of the above values.
  • Database – Shows the name of the database and its host. You can choose the database name to navigate to the databases Database Overview screen.
  • Alerts – Provides the number of high and medium alerts triggered in the database. The Alerts page opens, if you choose the link.
  • Memory – Shows values for Current and Peak memory, the Memory Allocation Limit, and the Threshold for high and medium memory usage alerts. Choosing the memory graph opens the Performance Monitor page where KPIs for your database's memory usage are displayed.
  • CPU – Shows values for Current CPU usage, the Threshold for high CPU usage alerts, and the Start Time and End Time of the twelve-hour time range that is shown. Clicking the CPU graph takes you to the Performance Monitor where KPIs for your database's CPU usage are displayed.
  • Disk – Shows the Current percentage of disk usage, the Threshold for high and medium disk usage alerts, and the Severity Level, which can be one of normal, warning, or critical. Selecting the disk graph takes you to the Performance Monitor where KPIs for your database's disk usage are displayed.
  • Expensive Statements – Displays the number of expensive statements executed by the database. Therefore, the Expensive Statements trace must be active. Clicking on the number takes you to the Expensive Statements tab on the SQL Statements page.
  • Group – The number of database groups to which this database belongs to. Choose the number to display a list of the groups.
  • Type/Version – Indicates whether the database is a tenant or system database and displays the SAP HANA version. If the registered SAP HANA database is offline or stopped, its correct version is still shown.
  • Credentials – When you choose the link in the Credentials column, you can enter your personal SAP HANA database user name and password (unless single sign-on is enforced for this resource). The cockpit securely encrypts and stores separate database credentials for each cockpit user; the database user name and password you enter cannot be used by other cockpit users.
  • SAP Control Credentials – To store the SAP Control logon credentials used for starting and stopping the resource and restoring features, choose Enter Credentials, and enter the name and password of the resource's <sid>adm OS user. If this operating system user needs to be a personal user account, follow the instructions from SAP Note 1881622 – SAP HANA DB: Access to trace files via sapstartsrv.

    The cockpit securely encrypts and stores the credentials. If you want to clear the credentials, choose Manage Credentials, and choose Delete the stored credentials for this database.

Database Management

The Database Management app provided by the system database displays information about all databases in the database system and allows you to monitor and administer your tenant databases. From the Database Management screen, you can drill down to more detailed information about each individual tenant database.

To perform operations on a tenant database, you must have the system privilege DATABASE ADMIN.

The Blocklisted Parameters button (1) allows you to control which system configuration (*.ini) file parameters can be changed by the individual tenant databases. It might be desirable to prevent changes to certain parameters being made directly in tenant databases because they could, for example, affect the performance of the system as a whole (CPU and memory management parameters). A configuration change blocklist is available for this purpose. You can use the SAP HANA cockpit to lock parameters against editing them from within a tenant database. The blocklist is stored in multidb.ini. Several parameters are prohibited by default, so you'll see them when you visit the Blocklisted Parameters for Tenants page for a tenant. You can remove default properties from that page, that is, make them editable by the tenant and you can add new parameters and lock them so they can’t be edited. Customizing the default configuration change blocklist can be achieved by changing existing entries in the multidb.ini file and the section readonly_parameters.

You must have the system privilege INIFILE ADMIN.

The Global Allocation Limits button (2) opens the Global Limits app and provides configuration options for resource usage like memory and CPU allocation for individual tenant databases. The configurable settings come with two tabs:

  • Memory allocation: Setting the memory allocation limits for each database on a host safeguards the appropriate memory sharing through setting the maximum amount of memory that can be allocated for a particular tenant database.
  • CPU allocation: Setting the allocation limits safeguards the appropriate sharing of CPU cores, effectively specifying the maximum number of CPU cores that can be used by a particular tenant on a particular host.

The Restricted Features button (3) is used to safeguard and/or customize your system. Certain features of the SAP HANA database can be disabled in tenant databases.

The Restricted Features for Tenants application provides you with a list of features that can be disabled for a specific tenant. For example, you can restrict import and export operations or the ability to back up the database. Which features you disable depends on the usage of the tenant.

The More (...) button (4) opens a dropdown list that provides you with links to additional tenant features that you can set up. These features are as follows:

  • Audit policies: allows you to create, view, and delete system, configuration- and security-related audit policies.
  • Backup configuration: allows you to configure system-wide backup settings.
  • Backup schedules: allows you to schedule backups for the system database and tenant databases.
  • Configure tenant replication: allows you to set up replication between two tenants.
  • Database licenses: allows you to request, upload, and delete system database and tenant database licenses.

The Create Tenant button (5) allows you to create new tenants, and in a scale-out system, you can assign the different tenants service to the hosts belonging to the scale-out system.

The Tenant Actions button (6) provides you with additional advanced tenant administration features. The tenant features include back up, copy, recover, replicate, rename, and set restart mode. You can also reset the tenant's SYSTEM user password.

The Fallback Snapshot button (7) includes options to create, delete, and reset fallback snapshots.

The Delete Tenant (X) button (8) is used to delete the tenant database. Optionally, you can keep or delete the current backup directories.

SAP HANA Database Overview

Through the overview, you can view key health indicators for this specific resource, such as database status, alerts, and resource utilization. You also have access to tools that allow you to perform database administration tasks, such as performance analysis and executing SQL statements. Different parts of a single card can link to different views or applications. This way, you can see various components in a single view and make the decision whether to further examine issues by drilling down.

The cards that appear on the Database Overview depend on whether you're connected to a tenant or system database.

If you register an offline resource and display its overview, you'll notice that much of the information that appears on the overview of an online resource is missing. You can use the cockpit to start the resource: choose the Database Overview screen, then choose the Start Database button.

SAP HANA Database Information

For a first analysis of the SAP HANA database system status, you need access to database information about the SAP HANA system. Information like database version, operating system version, or operational status can help you to monitor your system and quickly identify potential problems.

In SAP HANA cockpit, from the Database Overview screen, you can access database information by searching for the Database Information card. The easiest way to do this is by using the SAP HANA cockpit search function and the search term Database Information.

Drill down into the General Information card for more detailed information. Details shown in the General Information card are grouped into three tabs.

  • The Overview tab (1) provides information on system usage, start time, and whether the system is a scale-out system. If the SAP HANA system is a distributed system, the number of hosts is displayed as well. The operating system flavor and version are displayed and on what hardware or hypervisor the database is running.
  • The SAP HANA Version History tab (2) shows the update history of the SAP HANA database system. This information is very useful during software lifecycle management tasks.
  • The Installed Plugins Details tab (3) shows information about the plugins that are installed. This information is useful when you need to update the SAP HANA database system and want to make sure that all the installed plugins are supported in the new version. If SAP HANA system replication is activated, then the replication status between primary and secondary system is displayed as well.

To access the Database Information card and its detailed content, you need the system privilege CATALOG READ.

Log in to track your progress & complete quizzes