Workaround: Errors running the Evaluation installation scenario when the local DB2 is not configured with the default service port number 50000

Ya Qiang Li
Last Updated: September 4, 2012
Build Basis: Rational Insight 1.1.1

Workaround Summary

Change the default service port number to 50000 for the local DB2 service.

More Information

Versions: Rational Insight 1.1.1
Platforms: All

Problem

If the local DB2 service port number is not set to the default value 50000, you will receive an error message when clicking Deploy on the Configure DB2 databases and Tomcat for evaluation step of the Evaluation installation scenario. The port number must be set to 50000 in order to deploy Rational Insight v1.1.1 to Tomcat.

Errors reported:

com.ibm.rational.rrdi.setup.db.common.RRDIDBException: CRRRD4710E: Connection to the database cannot be established. Make sure that the connection information, the user, and credentials are valid. Make sure that the driver is properly set up and that the correct communication protocols have been configured on the database. Refer to the DBMS error message and code for details. Error Code: 4710 SQL ERROR: [jcc][t4][2043][11550][3.58.82] Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001

Workaround

1. Modify the existing system service that occupies the port 50000 to another port.
2. Run the following command to find the DB2 service name in the db2cmd console:
   
   db2 get dbm cfg | find "(SVCENAME)"
   
   The example will return the result: TCP/IP Service name (SVCENAME)=db2c_DB2
3. Modify the line in the services file (on Windows is C:WINDOWSsystem32driversetcservices, on Linux is /etc/services) with the related service name that you determined in the previous step. For example, change db2c_DB2 50001/tcp to db2c_DB2 50000/tcp
4. Run the following command to configure DB2 to use the service:
   
   db2 update dbm cfg using SVCENAME db2c_DB2
5. Run db2stop and db2start to restart the DB2 service.

Related Information

The following links point to related information:

• Rational Insight Work Item 70918
• Rational Insight Work Item 69920