DB2 connection error Connect. errorcode=-4499, sqlstate=08001 (reprint)

The following error is reported when using data studio to connect to a remote DB2 database:
[jcc][Thread:main][SQLException@5b775b77] java.sql.SQLException
[jcc][Thread:main][SQLException@5b775b77] SQL state = 08001
[jcc][Thread:main][SQLException@5b775b77] Error code = -4499
[jcc][Thread:main][SQLException@5b775b77] Message = [jcc][t4][2043][11550][4.13.111] Exception java.net.ConnectException: Open port 50,000 on server 192.168.1.107/192.168. An error occurred during the 1.107 socket, and the message was: Connection timed out: connect. ERRORCODE=-4499, SQLSTATE=08001
[jcc][Thread:main][SQLException@5b775b77] Stack trace follows
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.13.111] Exception java.net.ConnectException: Open the set of server 192.168.1.107/192.168.1.107 on port 50,000 An error occurred while connecting, and the message was: Connection timed out: connect. ERRORCODE=-4499, SQLSTATE=08001
com.ibm.db2.jcc.am.id.a(id.java:320)
 
Cause:
Error 1: DB2 return code is -4499
Four problems might be the cause of this error.
1. Firewall is not stopped
2.DB2 is stopped.
3. The wrong DB2 database listening port number is specified.
4. The wrong database name is specified.
 
solution:
1.Check whether firewall is stopped.
chkconfig iptables off permanently off
service iptables stop fails after restarting the host
2. Check whether DB2 is started.
db2 list db directory
3. Check the DB2 listening port
db2 get dbm cfg |grep SVCENAME, check whether the TCP/IP service name matches the db2 service name defined in /etc/services
4. Check the DB2COMM
db2set -all check whether DB2COMM is TCPIP
db2 connection error connect. ERRORCODE=-4499, SQLSTATE=08001 (reproduced)

Tag: err grep cto wal ace span space comm open port

Original address: http://www.cnblogs.com/jjzd/p/6372908.html