Maximo Open Forum

 View Only

Related Content

  • 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)

    pdf
    MASMS-DatabaseConnectionSteps.pdf   640 KB 1 version


Newest Episode
Ep. 2 | Adding a QR Code to a BIRT Report

Watch Steven Shull walk through how to add a QR code to a BIRT report and make Maximo reporting more scannable, connected, and useful in the field.

Watch on YouTube Listen on Spotify
MORE by Naviam Episode 2 cover
Watch Episode 2
Also available: Ep. 1 | IBM Maximo Application Suite 9.2
Ep. 1 YouTube Ep. 1 Spotify Browse all episodes →