Db2 On Premise and Cloud

 View Only
  • 1.  Connect to Db2 on Cloud

    Posted Mon November 22, 2021 07:16 AM
    Hello DMC Support Team,

    What are the steps to connect from DMC to a DB2 on Cloud database with the new service credentials?

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------


  • 2.  RE: Connect to Db2 on Cloud

    Posted Tue February 15, 2022 02:11 AM
    Hello Joachim,
    What do you mean about the new service credentials?  Would you please give more details about your question?

    From my experience, the cloud databases only allow SSL connections, so we need to set the connection profile, which points to the cloud db2 database, to enable the SSL option at the DMC side.

    A general process to adding an IBM Db2 cloud database connection profile.
    1 get the DB connection info


    2  add the connection profile with the info in DMC


    ------------------------------
    Tao Wen
    ------------------------------



  • 3.  RE: Connect to Db2 on Cloud

    Posted Tue February 15, 2022 09:30 AM
    Hello Tao Wen,

    did the same but with no success.



    Error: The operation has timed out.

    2022-02-15T14:20:59.568Z [ERROR] [RestService] - Aborted POST /dbapi/v4/dbprofiles/testConnection after 300000ms 
    2022-02-15T14:20:59.569Z [ERROR] [RestService] - Exception: 17efdbd7-35c9-f2f5-2ded-4d70a1239289: POST /dbapi/v4/dbprofiles/testConnection {} 
    2022-02-15T14:20:59.571Z [ERROR] [ErrorService] - TimeoutError: Timeout: POST /dbapi/v4/dbprofiles/testConnection 

    Configure the connection in the Data Studio works fine.

    Best regards,
    Joachim


    ------------------------------
    Joachim Müller
    ------------------------------



  • 4.  RE: Connect to Db2 on Cloud

    Posted Tue February 22, 2022 05:28 AM
    hello Joachim

    Thanks for your reply.

    Are your data studio and your DMC on the same host?

    The error says the connection times out, so I guess there are some networking issues.

    What connection fields did you fill in the data studio? could you please list them or post a screenshot here. If there has no networking issue, I think I need to do a comparison to the filled connection fields of the DMC and data studio.

    Thanks



    ------------------------------
    Tao Wen
    ------------------------------



  • 5.  RE: Connect to Db2 on Cloud

    Posted Wed February 23, 2022 02:18 AM
    Hello Tao Wen,

    Data Studio is on my client and the DMC with database repository is on an AIX machine.

    Here the screenshot from Data Studio:

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------



  • 6.  RE: Connect to Db2 on Cloud

    Posted Wed February 23, 2022 09:44 AM
    Hello Joachim,
    I noticed that your hostname is a very long name.
    Can you please try using the ipaddress or create a shorter name for the hostname, just to see if you bypass the problem?
    I am wondering if that has something to do with the issue.
    If using a shorter hostname works, please create a case, so we are able to track a fix for the issue.
    Please let me know your test results.
    Thanks!

    ------------------------------
    Cintia Ogura
    ------------------------------



  • 7.  RE: Connect to Db2 on Cloud

    Posted Thu February 24, 2022 01:18 PM

    It looks very much like a network connectivity issue.

    Make sure you are allowed to connect to the cloud from the server.  There may be network rules with lists of allowed or disallowed IP addresses.  You would still be able to issue a ping to the server which will only confirm that it exists, but you would not be able to do an actual connection.

    I would suggest that the application is updated to list status code, text and reason when the API calls fail.



    ------------------------------
    Tommy Petersen
    ------------------------------



  • 8.  RE: Connect to Db2 on Cloud

    Posted Wed March 02, 2022 10:00 AM
    Hello,

    After setting the port all works fine.
    Thanks a lot...

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------