ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
CI_Metric_ID is NULL in UIM database S_QOS_Data
Article ID: 145124
DX Unified Infrastructure Management (Nimsoft / UIM)
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