Not getting Mdisk (SAN and RAID) throughput data report for ibm_svc probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)

Issue/Introduction

We are not getting Mdisk (SAN and RAID) throughput report in metric viewer

Related Metric 

MDisk throughput    QOS_STORAGE_CLUSTER_MDISK_IO    MBps    MDisk (SAN and RAID) throughput    1.0

 

Environment

Release : 20.4.x

probe : ibm_svc 1.11

Storage type v7000

Resolution

Cleared older qos data having null value causing the required metric to be not seen in metric viewer although being send by the ibm_svc probe and related data being collected in the database 

1) Find the metric type 
select * from CM_CONFIGURATION_ITEM_METRIC_DEFINITION where met_description like 'MDisk (SAN and RAID) throughput'

 

2) Below sample query used to find the older qos causing issue 

SELECT d.dev_name, ci.ci_name,cid.ci_description, cimd.met_description  
, cs.cs_id  
, cim.ci_metric_type, 
      qd.table_id, 
      qd.r_table, qd.h_table, cimd.unit_type 
     FROM cm_computer_system cs 
        INNER JOIN 
    cm_device d ON d.cs_id = cs.cs_id 
        INNER JOIN 
    cm_configuration_item ci ON ci.dev_id = d.dev_id 
        INNER JOIN 
      cm_configuration_item_definition cid ON cid.ci_type = ci.ci_type 
        INNER JOIN 
    cm_configuration_item_metric cim ON cim.ci_id = ci.ci_id 
        INNER JOIN 
    s_qos_data qd ON qd.ci_metric_id = cim.ci_metric_id 
        INNER JOIN 
    s_qos_snapshot qs ON qd.table_id = qs.table_id 
        LEFT JOIN 
      cm_configuration_item_metric_definition cimd ON ci_metric_type = cimd.met_type 
     WHERE cim.ci_metric_type = ''xxx'' AND cs.cs_id in (x) AND ci.ci_name in (''xxx')'
     where cs.cs_id in x)

 

3)Delete the older qos data identified in query 2 data using SLM portlet