Adding database connections

A database connection is a set of JDBC connection data that you define to make a database available to the product. You can manually add connections, import connections from a CSV file, or discover databases on your servers and automatically add them.

1. Log in to the DSM web console.
   Use one of the following URLs:

   • http://server_host_name_or_ip:http_port/console
   • https://server_host_name_or_ip:https_port/console

   Note: When using versions of DSM older than V2.1.5, omit /console from the URL path.
2. Add database connections.

   Option	Description
   Manually add a connection	Go to Settings > Manage Connections, select Add > Add a database from the command bar, and enter/select connection parameters in the fields provided. The following information is required: Data server type Database name Host name Port number Operation credential: needed to perform operational tasks on connected databases, such as administration tasks, querying the database, or optimization through tuning Data Collection credential: needed to collect data from a connected database for monitoring and alert generation Choosing either of these credential options (Enable operation, Enable data collection) opens a new Credentials tab, where the user can enter a user name and password for either credential, which are saved as the Operation and/or Data Collection credentials for the connection profile Specific database privileges are needed for the above credentials, as DSM will use the credentials to conduct specific tasks against connected databases. For more details, see Privileges required for the ID used by DSM
   Import connections from a CSV file	Go to Settings > Manage Connections. Click the icon and follow the dialog prompts. The database connection information that you can import must be in CSV (comma-separated value) text format. For a sample CSV-file, see setup_directory/ibm-datasrvrmgr/samples/DatabaseConnectionsImportCSV.txt.
   Discover databases	Instead of manually adding database connections one by one, you can discover and add databases that exist on your database servers as database connections. To use the discover feature, go to Settings > Manage Connections and select Add > Discover databases from the command bar. In the wizard that opens, specify the host name for a database server and the credentials of a user with the required privileges on the database server. You can then find existing Db2® instances on the server, and discover and add connections for any associated databases. Db2 server requirements: The SSH PasswordAuthentication configuration setting must be set to yes The Db2 instance must be configured for Db2 discovery User ID requirements per platform: Linux: SSH access SYSADM Access to the db2nodes.cfg file and /etc/services Optional: To see instance status, the user ID must be the instance owner or have root user authority Windows: SSH access SYSADM Local administrator Access to the db2nodes.cfg file and to system32/drivers/etc/services If your configuration is PureScale One of the following authorities: SYSADM, SYSCTRL, or SYSMAINT