DX Unified Infrastructure Management

  • 1.  Oracle probe custom template with QOS

    Posted Dec 04, 2018 04:18 PM

    Hi Team

     

    I created a new custom template with oracle probe 5.30 and UIM 9.0.2 and also configured it to send a QOS , but in USM the new metric it is reported with "User Defined" suffix and not with the QOS name.

    Where I can configure the custom template to show the OS name in USM?

     

    QOS from custom checkpoint:

     

     

    QOS from "standard" checkpoint :

     

     

    Regards

    Antonello



  • 2.  Re: Oracle probe custom template with QOS

    Posted Dec 04, 2018 06:44 PM

    Have you compared your custom template to the built in ones?



  • 3.  Re: Oracle probe custom template with QOS

    Posted Dec 05, 2018 05:39 AM

    yes but the built in ones are different because they doesn't show the query tab, anyway I checked the qos list, this is for one builtin template

     

     

     

    And this is for the custom template, I expect to see in USM the new metric "custom_hit_ratio" or any other info to identify the new metric instead of "User Defined"

     



  • 4.  Re: Oracle probe custom template with QOS

    Posted Dec 05, 2018 12:41 PM

    seems to me

    A probe upon startup sends qos definition messages.

    A new qos should result in a new qos definition message

    which updates S_QOS_DEFINITION

    which for example has name and description columns

    name = qos

    QOS_PROC_QUEUE_LEN  - example

    description = the qos name shown in ums > device > metrics (again seems to me)

    Processor Queue Length  - example

     

    See what this returns

     select * FROM [CA_UIM].[dbo].[S_QOS_DEFINITION] where name like '%custom_hit_ratio'



  • 5.  Re: Oracle probe custom template with QOS

    Broadcom Employee
    Posted Dec 06, 2018 12:40 AM

    Hi,

    Every metric owns "Metric Type" and a resource files provide strings (for display in USM) for every "Metric Type".

    "Metric Type" is found in CM_CONFIGURATION_ITEM_METRIC table.

    So reported behavior is that different "Metric Type" is assigned by oracle probe in between OOTB template and custom template.

     

    https://comm.support.ca.com/kb/how-does-ci-type-ci-metric-definition-work-in-uim/kb000045003

     

    Regards, Yu



  • 6.  Re: Oracle probe custom template with QOS

    Posted Dec 10, 2018 04:44 PM

    Hi Yu

     

    looking ar the suggested doc:

    https://comm.support.ca.com/kb/how-does-ci-type-ci-metric-definition-work-in-uim/kb000045003

    I found the metric type "user defined" for Oracle identified by:

    met@4.1.1\:1 = User Defined

    but if I have more than one user defined metrics how can I enumerate them in the file nimsoft.properties?

    infact I see the subsequent index are used by these:

    met#4.1.1\:2 = SQL Error
    met#4.1.1\:3 = SQL Timeout

    ................

     

     

    nimsoft.properties:

     

    ci#4.1 = Database.Oracle
    ci#4.1.1 = Database.Oracle.DynamicCheckpoint

    .....

    met#4.1.1\:0 = Health Index
    met#4.1.1\:1 = User Defined
    met#4.1.1\:2 = SQL Error
    met#4.1.1\:3 = SQL Timeout
    met#4.1.1\:4 = Query Checksum
    met#4.1.1\:5 = Version Error
    met#4.1.2\:0 = Health Index
    met#4.1.2\:1 = Connection Ratio

    .........................

    .........................



  • 7.  Re: Oracle probe custom template with QOS

    Broadcom Employee
    Posted Dec 10, 2018 08:36 PM

    Thanks for reply. Sorry you can't manipulate these properties as all definitions reserved for internal processing.