Maximo Open Forum

 View Only
  • 1.  Connect to db2 maxximo application suite

    Posted 05-26-2022 19:09
    Hi,

    Anyone know how to connect db2 manage database on IBM cloud, I need to run some querys directly to db to obtain several reports

    I'm trying to use dbeaver to connect and luw driver

    Already habe the jdbc, but when I use the host in the jdbc it doesn't work, just have a message with the unknown host error

    jdbc:db2://HOST.DOMAIN:50001/MANAGE:sslConnection=true;

    Any help is welcome

    Best regards
    #EndUser

    ------------------------------
    Ricardo Monsivais
    NA
    ------------------------------


  • 2.  RE: Connect to db2 maxximo application suite

    Posted 05-27-2022 09:31
      |   view attached
    Hi Ricardo

    The attached doc from IBM worked for us with the addition of the property below to the driver properties tab in DBeaver:

    sslTrustStoreType - jks

    Kind Regards

    Phil

    ------------------------------
    Phil Naylor
    MACS EU
    ------------------------------

    Attachment(s)



Newest Episode
Ep. 5 | Make Manage Feel Like Home with Configuration, Not Customization

Watch Steven Shull and Phil Runion discuss how IBM Maximo Manage teams can make the system feel more familiar, useful, and aligned to their business through configuration instead of customization.

MORE by Naviam Episode 5 cover
Watch Episode 5
Also available: Ep. 4 | System Properties in IBM Maximo