Database connection error

When you are opening a mining model in the database, you can test the database connection.

If the system cannot connect to the database, the following error might be displayed:

ConnectException: Error opening socket to server <HOST> on port <PORT_NUMBER> 
with message: Connection refused: connect.

Where:

<HOST> is the host name of the database server.
<PORT_NUMBER> is the port that is used for the instance by the DB2® server.

The system cannot connect to the database if the DB2 server is down or the specified port number is not correct. With the stand-alone DB2 Intelligent Miner® Visualization version 9.1 or higher, you can use one of the following options to connect to a database and to check whether the port number is correct:

Use defaults from Intelligent Miner

Check the port number. If required, correct the port number.

Use a profile

Check the database URL.

jdbc:db2://<HOST>:<PORT_NUMBER>/<DATABASE_NAME>

Where:

<HOST> is the host name of the database server.
<PORT_NUMBER> is the port that is used for the instance by the DB2 server.
By default, the port number is 50000. Every instance has a different port number.
<DATABASE_NAME> is the name of the DB2 server.

You can identify the port number by searching for the file services. On Windows, this file is saved in C:\WINDOWS\system32\drivers\etc\services. On UNIX, this file is saved in /etc/services. In this file, there is a mapping to a port number for every instance. For example, the standard instance DB2 has an entry like db2c_DB2 50000/tcp.

Feedback | Information roadmap