Unable to PS Connect on DB2 database. (4305785)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Unable to PS Connect on DB2 database.
Description

After upgraded STAT from 5.6.2 to 5.7.2 the Stat Agent is up and running, but PS Connect raises error:
URL=jdbc:db2://<server_name>:67000/EPMDK1:currentSchema=psadmep; Verify Connection Error--port out of range:67000
Cause

The limitation is about the TCP protocol as its port range is 0 to 65535, and in this case the ports you are using for the TCPIP connection is out of that range.
Resolution

Basically, to solve the error is to set DB2 tcp port connection to a valid lower port.
1. Configuring DB2 server communications (TCP/IP)
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0004727.html
2. Configuring IBM data server client communications
http://www-01.ibm.com/support/knowledgecenter/#!/SSEPGG_10.1.0/com.ibm.db2.luw.qb.client.doc/com.ibm.db2.luw.qb.client.doc-gentopic1.html

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title