Show TOC

Adding a Database ConnectionLocate this document in the navigation structure

Procedure

  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.
    Note

    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:

    1. In the Database System field, select the type of the database platform.

    2. 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.

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

    4. If you want the connection to be mandatory for the SAP system, select 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 cannot run.

      Caution

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

    5. 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.

    6. 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

    Database Host

    The name of the server where the database is located.

    iASP Name

    The name of the database. You should not specify a value for this parameter.

    Schema Name

    The name of the schema to be monitored (for an ABAP system: R3<SID>DATA) for a Java system: SAP<SID>DB.

    Connection Type

    The type of connection. The permitted parameters are OPTICONNECT and SOCKETS. SOCKETS means that a connection via TCP/IP sockets has been chosen.

    Optimize Method

    The possible optimization methods are:

    • First I/O. Designed for "Screen at a Time"

    • A

      All I/O

    • O

      All I/O whenever suitable

      You should use O as a default.

    Query Attribute Library

    Specifies the library of the query attribute file QAQQINI to be used for this connection. If you are not using a query attribute file, you should not specify a value for this parameter.

    SAP System ID (optional)

    Specifies a 3-character SAP system ID in case that the target is an SAP system. This parameter is optional. If it is not specified, it will be derived from the library name R3<SID>DATA or SAP<SID>DB.

    Database Performance Collector Output Schema

    Specifies the output library for the database performance collector.

    If this is not specified, the value to use will be SAPDB4M for non-switchable ASPs or SAPDB4M<asp Number> for independent ASPs.

    For more information, see SAP Note 1622665 Information published on SAP site.
    Note

    To support new connection parameters and for support scenarios, you might have to add connection parameters in an unchecked raw format. To be able to do so, choose Guided Mode <-> Expert Mode and switch to the expert mode. In the expert mode, you can enter connection parameters as a string instead of using the guided mode. However, we do not recommend that you use the expert mode.

    1. To confirm your entries, choose Save.

    Result

    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.