Show TOC Start of Content Area

Procedure documentation Maintaining Database Connection Information

Use

Use DB connection maintenance to maintain the SAP table DBCON. This table contains information about additional non-standard database connections (such as database system, password, and so on).

Procedure

To call DB connection maintenance, choose Administration CCMS DB administration DB connections. Alternatively, use Transaction DBCO.

A table for DB connection maintenance appears. The table includes the following columns:

      Name of connection

Logical name of database connection

      DBS

Database system

      Database user name

Database user

      Database password

Password to create the connection to the database

      Connection information

Database system-dependent information about the database connection.

Displaying Details about the Database Connection

...

       1.      Select the entry

       2.      Choose Details.

Adding New Information to Database Connections

...

       1.      To switch to change mode, choose Table view Display -> Change

       2.      Choose New entries. Alternatively, choose Copy as... to use an existing data connection as a template

       3.      In the Connection name field, enter a name you choose for the logical database connection

       4.      In the DBMS field enter the code for the database system (for example, ORA for Oracle)

       5.      In the User name field enter the name of the database user

       6.      In the DB Password field enter the password twice

       7.      In the Conn.info field enter the database-dependent information for the database connection

       8.      In the Reconnect type field enter the type of availability for an open database connection

       9.      Choose Save

Maintaining Existing Database Connection Information

...

       1.      To switch to change mode, choose Table view Display Change.

       2.      Select the entry

       3.      Choose Details.

       4.      Change the existing information

       5.      In the DB Password field enter the password twice

       6.      Choose Save.

Deleting Existing Database Connection Information

...

       1.      To switch to change mode, choose Table view Display Change.

       2.      Select the entry

       3.      Choose Delete.

 

 

End of Content Area