CI_Metric_ID is NULL in UIM database S_QOS_Data

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

There are many entries where ci_metric_id is NULL in S_QOS_Data table. Please suggest how these entries can be deleted so as to improve UIM DB performance.

Environment

Release : 9.0.2

Component : UNIFIED INFRASTRUCTURE MGMT

Resolution

If there are rows with proper ci_metrics_id s_qos_data for same  source/qos/target with proper ci_metric_id then it is safe to delete that data:

delete from s_qos_data where ci_metric_id is NULL