CI_Metric_ID is NULL in UIM database S_QOS_Data
Article ID: 145124
DX Infrastructure Management
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.
Release : 9.0.2
Component : UNIFIED INFRASTRUCTURE MGMT
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