Adding a Database Connection 

Call the DBA Cockpit...

       1.      Call the DBA Cockpit

       2.      In the system landscape toolbar, choose DB Connections.

       3.      Choose Add.

The screen DB Connections – Add Connection Entry appears.

       4.      In the Connection Name field, specify the name of the connection.

This name is a unique ID that you can choose freely except for names that are reserved by SAP for generated connections. These can be, for example, administrator connections or connections that are used by systems from the system landscape directory (SLD).

       5.      Specify the database connection attributes as follows:

                            a.      In the Database System field, specify the name of the database platform.

                            b.      In the Connection Maximum field, enter an appropriate value. This value limits the number of database connections that are currently held by the SAP system. The SAP system does not let you exceed this limit.

                            c.      In the Connection Optimum field, enter an appropriate value. This value is a more flexible limit that can be exceeded.

                            d.      If you want the connection to be mandatory for the SAP system, choose Permanent Connection. This parameter defines the availability of the database connection.

It is then handled like the local default connection, that is, if this database connection is not available for a work process, the work process of the SAP system will not run.

You should set this parameter only if this connection is absolutely required to run your SAP system.

                            e.      In the User Name field, enter the name of the connect user. Make sure that you choose a user with the appropriate authorizations. For more information, see Maintenance Actions in the DBA Cockpit.

                              f.      In the Password field, enter a password for the connect user.

       6.      In the Connection Parameters table, specify the following additional database-specific attributes:

Attribute	Description
SSID/Alias	Name of your DB2 subsystem ID.
Collection ID	Identifier of the collection that is used for you database connection.
Schema Name	Name of the database schema. If you are using an MCOD system, the database schema also indicates the database system in which you are currently working.
Database Name	Name of your DB2 system.
Port Number	This is the port number of your database. Contact your database administrator for details.
Database Host	Name of your DB2 database host.

 

       7.      To confirm your entries, choose Add.

Result

The database is now automatically catalogued. As soon as the connection has been specified, the DBA Cockpit connects automatically to the newly added database system and displays data on the System Data tab page.