Thank you Cynthia! - this mud appears to be a bit clearer now ... :-)
Original Message:
Sent: Wed October 18, 2023 12:25 PM
From: Cintia Ogura
Subject: DMCTOP
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
Original Message:
Sent: Tue October 17, 2023 11:58 PM
From: Jan Nelken
Subject: DMCTOP
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
Original Message:
Sent: Tue October 17, 2023 05:13 PM
From: Cintia Ogura
Subject: DMCTOP
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
Original Message:
Sent: Tue October 17, 2023 05:03 PM
From: Jan Nelken
Subject: DMCTOP
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
Original Message:
Sent: Tue October 17, 2023 09:23 AM
From: Cintia Ogura
Subject: DMCTOP
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
Original Message:
Sent: Mon October 09, 2023 01:52 PM
From: Jan Nelken
Subject: DMCTOP
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
------------------------------