Db2

 View Only
Expand all | Collapse all

DMCTOP

  • 1.  DMCTOP

    IBM Champion
    Posted Mon October 09, 2023 01:52 PM

    Hi!

    Silly question - which version of dmctop was/is supporting Db2 V11.1?

    Don't ask why - my sandbox pureScale is at 11.1 level :-(



    ------------------------------
    Jan Nelken
    ------------------------------


  • 2.  RE: DMCTOP

    IBM Champion
    Posted Mon October 16, 2023 09:28 PM

    One more related question: is DMCTOP supported on Power9/Linux setup? Is DMC supported as well?



    ------------------------------
    Jan Nelken
    ------------------------------



  • 3.  RE: DMCTOP

    Posted Tue October 17, 2023 09:23 AM
    Edited by Cintia Ogura Tue October 17, 2023 09:29 AM

    Hello Jan,

    The latest dmctop version is 1.0.4.1, and it is available for download at IBM Fix Central at:

    https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+Db2+Data+Management+Console&release=3.1.8.0&platform=Linux&function=all

    Here is a guide that might help you:

    https://ibm.github.io/dmctop-wiki/

    Just to clarify, we are currently not supporting dmctop monitoring Db2 V11.1 as it is out of support.

    Also, DMC or dmctop currently does not support pLinux.

    If this feature is important for your business, my recommendation is to submit an idea at IBM Aha! page, so our product manager can considered a future implementation in DMC:

    https://ibm-data-and-ai.ideas.ibm.com/?category=7093947472735440072

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



  • 4.  RE: DMCTOP

    IBM Champion
    Posted Tue October 17, 2023 05:03 PM

    Actually I specifically asked: which version of DMCTOP was supporting Db2 V11.1. I will have to d/l Db2 V11.1 server fixpack - extract DMCTOP from it and try. I was hoping for a specific DMCTOP version answer though.



    ------------------------------
    Jan Nelken
    ------------------------------



  • 5.  RE: DMCTOP

    Posted Tue October 17, 2023 05:14 PM

    Hello Jan,

    Please use the latest dmctop 1.0.4.1 from the link that I have provided above.

    I hope that helps!



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



  • 6.  RE: DMCTOP

    IBM Champion
    Posted Tue October 17, 2023 11:58 PM
    Edited by Jan Nelken Wed October 18, 2023 03:23 AM

    That obviously does not work:

    time="2023-10-09T14:00:41.798930Z" level=info msg=ConfigUtils event=Information info="*************Initializing dmctop*************" moreInfo= trace=b603efbb-75a1-4e5f-83f8-d8cfbd2ececa
    time="2023-10-09T14:00:41.799011Z" level=info msg=DbUtils event=Information info="Setting DB Connection Info" moreInfo= trace=b603efbb-75a1-4e5f-83f8-d8cfbd2ececa
    time="2023-10-09T14:00:41.799019Z" level=info msg=DbUtils event=Information info="Connecting to DB" moreInfo=";50000;mytest;" trace=b603efbb-75a1-4e5f-83f8-d8cfbd2ececa
    time="2023-10-09T14:00:41.806296Z" level=info msg=DbUtils event=Information info="Connected to DB" moreInfo=";50000;mytest;" trace=b603efbb-75a1-4e5f-83f8-d8cfbd2ececa
    time="2023-10-09T14:00:41.806326Z" level=info msg=ConfigUtils event=Information info="Initializing DB config" moreInfo= trace=b603efbb-75a1-4e5f-83f8-d8cfbd2ececa
    time="2023-10-09T14:00:44.886224Z" level=error msg=DbConfig error="DB version 11010000 not supported" event="Encountered exception" moreInfo= trace=b603efbb-75a1-4e5f-83f8-d8cfbd2ececa
    [db2inst1@node03 ~]$ 

    [db2inst1@node03 ~]$ db2level
    DB21085I  This instance or install (instance name, where applicable: "db2psc") 
    uses "64" bits and DB2 code release "SQL11010" with level identifier 
    "0201010F".
    Informational tokens are "DB2 v11.1.0.0", "s1605251900", "DYN1605251900AMD64", 
    and Fix Pack "0".
    Product is installed at "/opt/ibm/db2".

    [db2inst1@node03 ~]$ dmctop -v
    dmctop 1.0.4.1 2022-06-21_328
    [db2inst1@node03 ~]$ 

    From the Wiki page you referred to - it is clear that:
    The dmctop utility can monitor Db2® version 11.1.0 and later fix

    All I am asking which version of DMCTOP can monitor Db2 Version 11.1 - fully accepting fact that V11.1 is now out of support.



    ------------------------------
    Jan Nelken
    ------------------------------



  • 7.  RE: DMCTOP

    Posted Wed October 18, 2023 12:25 PM

    Hello Jan,

    I checked with the developer and dmctop does not support Db2 V11.1 GA as there is a functionality that we use which was added after Db2 V11.1 FP1.

    So, to use dmctop, you need to install any fixpack (1 or later) on the monitored database, it does not matter what dmctop version you are using.

    I don't recommend using dsmtop, as dsmtop is not supported anymore.

    I hope that helps!



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



  • 8.  RE: DMCTOP

    IBM Champion
    Posted Wed October 18, 2023 01:23 PM
    Edited by Jan Nelken Fri October 20, 2023 09:15 AM

    Thank you Cynthia! - this mud appears to be a bit clearer now ... :-)



    ------------------------------
    Jan Nelken
    ------------------------------



  • 9.  RE: DMCTOP

    Posted Wed October 18, 2023 12:12 PM

    I am using db2 11.1.4 version. my dsmtop -v command gives the following output.

    ============================================================

    install dir: /home/db2inst1/sqllib
    java executable path: /home/db2inst1/sqllib/java/jdk64/jre/bin/java
    Java version used: "1.8.0_171"
    Version: 1.4
    Build level: 1.4.10

    ============================================================



    ------------------------------
    Sahan Mendis
    ------------------------------



  • 10.  RE: DMCTOP

    IBM Champion
    Posted Wed October 18, 2023 05:53 PM

    Thank you for your input - all discussion was about DMCTOP - not DSMTOP though



    ------------------------------
    Jan Nelken
    ------------------------------