DX Unified Infrastructure Management

 View Only
  • 1.  can we record string or date value in QOS_JDBC_VALUE?

    Posted Jul 22, 2020 01:34 PM
    Hello All,
    I am trying to pull values from JDBC queries using JDBC_RESPONSE probe and everything is working fine where I can connect with DB and pulling the value from query but that value is not saving in QOS_JDBC_VALUE just because it is not numeric.
    I am sharing the output we are expecting for each profiles but not getting for profiles where query is returning the value in date+time and string.

    Profile name : START_TIME
    Output expecting : ""07/20/20 22:00""

    Profile name : END_TIME
    Output expecting : ""07/20/20 22:07"" 

    Profile name : INPUT_TYPE
    Output expecting : ""DB INCR""

    Profile name : STATUS
    Output expecting : ""COMPLETED WITH WARNINGS""

    Profile name : SESSION_KEY
    Output we are getting : 1896

    Profile name : HRS
    Output we are getting : 0.127777778


    Please help.


  • 2.  RE: can we record string or date value in QOS_JDBC_VALUE?

    Posted Jul 22, 2020 01:37 PM
    Are non-numeric QoS message definitions supported?
    Article Id: 122434
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=122434

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: can we record string or date value in QOS_JDBC_VALUE?

    Posted Jul 22, 2020 02:05 PM
    Oh no ! need to inform my DB team then. Thanks @David Michel for the information with article details. 

    I am trying to add those query values in the Dashboard but not sure how to get that in dashboard. any other solution to display that value? I can see that return value in jdbc_response.log.




  • 4.  RE: can we record string or date value in QOS_JDBC_VALUE?
    Best Answer

    Posted Jul 22, 2020 04:45 PM
    To see the data 
    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/configuring-and-viewing-monitoring-data/the-performance-reports-designer.html

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/configuring-and-viewing-monitoring-data/the-slm-portlet/view-and-export-quality-of-service-qos-data.html

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------