Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2015-05-06T11:27:37Z by Pam25
SystemAdmin
SystemAdmin
224 Posts
ACCEPTED ANSWER

Pinned topic DB2 Endpoint Access from Appliance

‏2010-09-14T14:40:00Z |

Hello... I have a DB2 Endpoint accesible from my Cast Iron 5 Studio. I can insert and update data on the tables from the studio. I published my project on an appliance and now I am not able to access the same Endpoint. Here is the error... An exception occurred whileprocessing a SingleTableNotification job. Data error at row number 0 of tableFRIENDSHIP7.SF_USERROLE. The Error is Connection error while getting connectionout of the pool.  SQLSTATE: 08001 ERRORCODE: 0 Error Message: CastIronSystemsDB2 JDBC DriverError establishing socket. Unknown host: DBServer1

 Pls advise... SvK 

Updated on 2010-09-24T19:24:09Z at 2010-09-24T19:24:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    224 Posts
    ACCEPTED ANSWER

    Fully Qualified Host Name or IP Address solves the issue..

    ‏2010-09-24T19:24:09Z  in response to SystemAdmin

    It worked OK when I provided the fully qualified name of the host.It also works fine with the IP address..  ThanxSvK  
  • Pam25
    Pam25
    2 Posts
    ACCEPTED ANSWER

    Re: DB2 Endpoint Access from Appliance

    ‏2015-05-06T11:27:37Z  in response to SystemAdmin

    Hi Svk,

    Can you please elaborate the solution. because I am also facing the same issue.

    the error is :

    An exception occurred while processing a SingleTableNotification job. Data error at row number 0 of table FleetData.SiemensFleetData. The Error is Connection error while getting connection out of the pool.  SQLSTATE: 08001 ERRORCODE: 0 Error Message: [CastIron Systems][SQLServer JDBC Driver]Error establishing socket to host and port: DKBDKB7QKA.ww007.siemens.net:1433. Reason: Connection timed out

     

     

    Thanks!