Add a Database Connection

This section describes the steps to create a database connection from DBA Cockpit. (To create and change a database connection, you can alternatively use SAP transaction DBCO.)

1. From DBA Cockpit, choose DB Connections.

   An overview of the available database connections for each database platform is displayed. The local database is always displayed here.

   Table 1: Database Connections

   Column	Description
   Remote Database Connection	Name of the database connection This is a unique name that you define.
   DB Name	Name of the database Note Not relevant for SAP HANA.
   DB Host	Name of the database host
   DB Schema	Name of the database schema to be monitored Note Not relevant for SAP HANA.
   User Name	Name of the database user
   Permanent	Specifies whether the database user must be permanently available
   Max. Connections	Maximum number of open connections allowed
   Opt. Connections	Optimal number of connections

2. Choose SAP HANA database.
3. Choose Add.

   The screen DB Connections: Add Connection Entry is displayed.

4. Specify the following information:

   Option	Description
   Connection Name	A unique name for the database connection A database connection name must be in UPPERCASE and not include blanks.
   Database System	Specify "SAP HANA database"
   Connection Maximum	The maximum number of connections that can be open for each work process for a logical secondary database connection (DBCON-CON_NAME). Possible values: 0 - 15 0 means that there is no fixed limit to the number of open connections. A work process is only physically able to open up to 15 secondary connections.
   Connection Optimum	The optimum number of connections that can remain open for each work process for a logical secondary database connection (DBCON-CON_NAME). Possible values: 0 - 15 0 means that no special action is taken. A value n > 0 means that, at intervals of 5 minutes, the system checks whether more than n physical connections exist for this logical connection. If more than n physical connections exist, the excess connections are closed in order to maintain the defined optimum number of connections. Tip It is generally recommended to set both Connection Optimum and Connection Maximum to 0. Under normal circumstances, it is unlikely that an application uses more than one physical connection for a particular work process. If more than one physical connection is used, it may be because a connection was not closed correctly. In view of this, Connection Maximum can be set to 1 to ensure that no more than one physical connection is opened for a particular work process.
   Permanent Connection	Specify whether you want the connection to be permanently available. If a database connection is permanent, and if the connection is closed, an attempt is automatically made to reestablish the connection, regardless of whether the connection is currently being used or not. This means that the system does not run without this database connection.
   User Name	A user for the connection For an SAP HANA single-container system, use the operating system user <sid>adm. For an SAP HANA multitenant database container, use the database user SYSTEM.
   Password	The password of the database user
   Confirm	Re-enter the password.
   Connection Parameters	Generated automatically from the database host and the SQL port.
   Database Host	Name of the database host
   SQL Port	The SQL port to be used for the connection. Port = 3xxyy where xx is the SAP HANA instance number and yy is a two-digit number as follows: Port = 3xx15 is for an SAP HANA single-container system. Port = 3xx13 is for the system database of an 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. The instance number is displayed in SAP HANA studio. 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. Tip 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.

5. Save.