Rebuilding S_QOS_DATA caused loss of all of our historic data.

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Introduction/Summary: 

NimsoftSLM database was getting very large.  We decided to rebuild the table S_QOS_DATA to try to recover disk space.

Environment:  

UIM 8.x

Instructions: 

The rebuild caused loss of all pointers to the QoS data tables.  The only solution was to restore a database backup which caused loss of all of the data since the S_QOS_DATA table was modified.  The S_QOS_DATA table can be seen as the master of all QOS table.  This table contains references to each QoS source and target defined by the probes.  It is THE ONE table that should never be modified unless Nimsoft has checked the modifications before they have are applied.

 

Environment

Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: