Cloud Pak for Data

 View Only

How to connect ICP4D to on prem DB2 (in mainframe)

  • 1.  How to connect ICP4D to on prem DB2 (in mainframe)

    Posted Mon September 21, 2020 11:06 AM
    Hi,

    I am trying to connect on prem DB2 (in mainframe, private) into ICP4D with no success.  And I am here to check with you guys if you know how it should be done.  i tried to connect to the DB2 server directly (via host ip, and port) using db2 for z/os connector but below error occurred.  I also tried to connect first to a DB2 client (local windows machine) before reaching the DB2 server, wherein db and nodes are pointing to DB2 server, but similar error occurred with error message of "no route to host" (i have db2 server and db2 connect for this installed in local machine with port 50000 and 50001).  Is it because I need a gateway server like secure gateway?  if yes how can this be used in ICP4D?

    error message:
    Encountered error trying to test connection "name" for data source type DB2Z. -com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.26.14] Exception java.net.ConnectException: Error opening socket to server /xxx.xxx.xxx.xxx on port xxxx with message: Connection timed out (Connection timed out). ERRORCODE=-4499, SQLSTATE=08001

    Thank you.

    ------------------------------
    Richardson
    ------------------------------

    #CloudPakforDataGroup