Database Health Degraded in SOI UI Page

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Database Health is showing Degraded in SOI UI Page.

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Cause

This feature was introduced in patch SO01669.

Resolution

Introduced Database Health Option on CA SOI Dashboard:
This option shows the database health status message based on the threshold value violation. You can also change the threshold values at runtime in file <SOI_HOME>\SamUI\webapps\sam\thinuiconf\dbconf.properties.

By default, the limit are set for the following tables

AlertHistory=1000000
Alerts=250000
DbQualityHistory=1000000
DbRiskHistory=1000000
DbAvailHistory=1000000



Depending on the current size of those tables listed above in your SOI database, you can increase it.