Adding and importing database connections

You can add new database connections one by one, or you can import a set of database connections.

Before you begin

Before you can add or import database connections, you need the following information:
  • The database name (DB2® for Linux, UNIX, and Windows) or location (DB2 for z/OS®)
  • The host name
  • The port number
  • The user ID and password of a user with at least CONNECT privilege on the database.

About this task

Database connections are shared by all components and users of the web console. Updating or deleting a database connection might affect other users of the same connection.

Restriction: Only the following file formats are supported when you import database connection profiles:
  • CSV (comma-separated value text) files
    Tip: Your product comes with a sample CSV text file that you can edit and use to import connections. The sample CSV file is in the samples subdirectory of the installation directory. For an example of a CSV file, see Example of a CSV text file.
  • Configuration profiles that you export from DB2 by using the Configuration Assistant menu in the DB2 Control Center or by using the db2cfexp command.

Procedure

To add or import database connections to the web console:

  1. Log on to the web console.
  2. Select Open > Databases.
  3. Add a new database connection or import database connections:
    • To add a new database connection, click Add and then complete the Add Database Connection wizard.
      Tip: To see the format of a CSV file, first configure a few data source connections, then click Export All. The connections are exported and stored in the CSV file connectionExport.txt.
    • To import database connections from a file, click Import and then complete the Import Connection wizard.

Results

The database connections are added to the list of database connections and can be further modified as needed.
Feedback