Db2

  • 1.  DMC 3.1.4 database responsiveness not working ?

    Posted Mon January 25, 2021 04:19 PM
    Hello ,

    Just starting to use DMC so I installed latest version 3.1.4.0 on Windows.
    Purpose is to use DMC to monitor DB2 v11.5 databases running on zLinux.
    Up till now, I still used Optim Performance Manager (I know, out-of-support for many years but I kind of liked OPM) so I hope that DMC provides as much  functionality as OPM did

    Now, when I configured my first database to be monitored using DMC ,the responsiveness console does not show any data :



    I checked and 
    1) event monitor RTMON_EVMON_STATS is created and active 
    2) multiple of the workloads have been altered so that aggregate activity data is collected
    3) registry variable DB2_ATS_ENABLE=YES
    4) Statistics watchdog seems to be fine as well 

    Any idea what I'm doing wrong ?

    Best regards

    Filip

    ------------------------------
    filip degryse
    ------------------------------

    #Db2


  • 2.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Tue January 26, 2021 09:31 AM
    Hi Filip,

    Thanks for using DMC 3.1.4 and pointing out this issue. Actually this is a known issue, and a hot fix would be available. Could you raise a DMC ticket about this issue? We'll deliver the hot fix via the ticket. thanks.

    ------------------------------
    KAI DING
    ------------------------------



  • 3.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Wed January 27, 2021 04:42 AM
    Thx Kai,

    I've opened an IBM support case for this

    Best regards

    Filip

    ------------------------------
    filip degryse
    ------------------------------



  • 4.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Wed January 27, 2021 08:44 PM
    Hi Filip,

    Could you please provide the case number? thanks.


    ------------------------------
    KAI DING
    ------------------------------



  • 5.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Thu January 28, 2021 03:23 AM
    Hello Kai, 

    Case number is TS004894869

    Best regards

    Filip


    ------------------------------
    filip degryse
    ------------------------------



  • 6.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Thu January 28, 2021 05:39 AM
    Hi filip,

    Sure, will let you know the updates. thanks.

    ------------------------------
    KAI DING
    ------------------------------



  • 7.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Fri January 29, 2021 05:40 AM
    Hi filip,

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

    Please refer to this link to get the hot fix for this issue. Please follow the readme guide in the fix pack to apply the fix. thanks.

    ------------------------------
    KAI DING
    ------------------------------



  • 8.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Fri January 29, 2021 06:59 AM
    Hello Kai, 

    Fix installed and issue solved :-)
    Thx !

    Best regards

    Filip

    ------------------------------
    filip degryse
    ------------------------------



  • 9.  RE: DMC 3.1.4 database responsiveness not working ?

    Posted Fri February 05, 2021 02:07 AM
    Glad to hear it. thanks!

    ------------------------------
    KAI DING
    ------------------------------