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.ini → system_information → usage 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>admOS 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.NoteThe 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.