From the Data source drop-down list, select Create database connection. In the Database connection dialog box, select the required database provider under Database type.

To edit an existing connection, select the connection from the Data source drop-down list. Then click on the editing button.

Enter the other settings.

Connection name

This line contains the name of the database connection. The name is automatically formed and entered according to the scheme username@database as soon as you have filled in the fields below. Alternatively, you can enter and overwrite the connection name manually.

Timeout

Here you can specify a value for the timeout in seconds for establishing the connection. If the time set here is exceeded, ibaAnalyzer aborts the connection attempt and displays an error message.

Note that once the connection is made, each command sent to the database has an additional timeout, which can be set by the application that makes use of it. There is no generic configuration for the command timeout.

Server address

Enter the IP address or the host name of the database server.

Port

The DB server communicates via this port. Usually, you can keep the default port 50000. If a different port is required, you can enter this port here.

Username/Password

Enter here the required login data for the database. If uncertain, ask your DB administrator.

Database

Enter the database here. When you have entered the server address, authentication or username and password. The drop-down list shows all available databases for the connection and you can select one.

DB2 Client Version

ibaAnalyzer automatically displays the installed version of the DB2 client.

<Test connection>

ibaAnalyzer checks the access to the selected database on the set DB server. If the connection is successful, the message includes the version of the database.