Db2 Error Opening Socket
Contents |
DB2; RAM; DB2 configuration; installation;
Asteria Error Opening Socket
RAM server setup; CRRAM703I; configure database; Exception java.net.ConnectException; Error
Com.ibm.db2.jcc.am.disconnectnontransientconnectionexception Errorcode=-4499 Sqlstate=08001
opening socket to server; Connection refused; ERRORCODE=-4499; SQLSTATE=08001; WSRR; service registry Technote (troubleshooting) error opening socket to server localhost/127.0.0.1 on port 50 000 Problem(Abstract) Attempts to configure your IBM DB2 database connection in IBM Rational Asset Manager results in "Error opening socket to server http://www.ibm.com/support/knowledgecenter/SS3JRN_7.2.0/com.ibm.itcamsoa.doc/kd4trmst45.htm {machine} on port 60,000 with message: Connection refused. " Symptom You see the following error message: CRRAM703I: Database - [jcc][t4][2043][11550][3.51.90] Exception java.net.ConnectException: Error opening socket to server {machine} on port 60,000 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001 Cause A possible cause for this http://www-01.ibm.com/support/docview.wss?uid=swg21403644 problem is that TCP/IP is not properly enabled on your DB2 database server. Resolving the problem Use the db2set DB2COMM command from the DB2 command window to start the TCP/IP connection: db2set DB2COMM=protocol_names For example, to set the database manager to start connection managers for the TCP/IP communication protocols, enter the following commands:
db2set DB2COMM=tcpip db2stop Db2start If the above command does not resolve the connection problem, contact IBM support. Related information Configuring TCP/IP communications for a DB2 instance Document information More support for: Rational Asset Manager Installation Software version: 7.1 Operating system(s): Linux Reference #: 1403644 Modified date: 2014-12-10 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
remote database using a non-default port Technote (troubleshooting) Problem(Abstract) You see database connection errors when you start a new instance that was created with the Remote Database, Existing Database options and that uses a non-default port. [jcc][t4][2043][11550][4.7.118] Exception java.net.ConnectException: Error opening socket to server taranis21.torolab.ibm.com/9.26.31.189 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499. Diagnosing the problem The server fails to start and you notice database connection errors when you attempt to start a new instance that was created with the remote database, existing database options and that uses a non-default port. The error looks similar to the following: [1/24/11 13:11:35:763 EST] 0000000f JDBCPersister W CNTR0031W: Error starting CMP bean WC_pmrtest#Enablement-RelationshipManagementData.jar#AlternativeLanguage: com.ibm.ejs.persistence.EJSPersistenceException: ; nested exception is: com.ibm.websphere.ce.cm.StaleConnectionException: [jcc][t4][2043][11550][4.7.118] Exception java.net.ConnectException: Error opening socket to server taranis21.torolab.ibm.com/9.26.31.189 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001DSRA0010E: SQL State = 08001, Error Code = -4,499 at com.ibm.ejs.persistence.EJSJDBCPersister.initialize(EJSJDBCPersister.java:390) at ... Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: [jcc][t4][2043][11550][4.7.118] Exception java.net.ConnectException: Error opening socket to server taranis21.torolab.ibm.com/9.26.31.189 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001DSRA0010E: SQL State = 08001, Error Code = -4,499 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) at ... ... 90 more ---- Begin backtrace for Nested Throwables java.sql.SQLNonTransientException: [jcc][t4][2043][11550][4.7.118] Exception java.net.ConnectException: Error opening socket to server taranis21.torolab.ibm.com/9.26.31.189 o