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

book

Article ID: 145124

calendar_today

Updated On:

Products

NIMSOFT PROBES 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
Powered by Wolken Software