0 Replies Latest reply on Nov 26, 2018 2:38 PM by Indrajit Jadhav

    Parameters for MSSQL and Oracle database availability report

    Indrajit Jadhav
      Share This:

      Dear Expert,

      Below parameters provide value database availability status.

      1. MS SQL Server Database - Database Status (0-ONLINE, 1-RESTORING, 2-RECOVERING, 3-RECOVERY_PENDING, 4-SUSPECT, 5-EMERGENCY, 6-OFFLINE, 7-COPYING, 10-OFFLINE_SECONDARY)

      2. Oracle Availability - Instance status (0=OK, 1=Warn, 2=Alarm)

       

      If we configured above parameters for Monthly/Weekly data where we need to use rate/aggregate data, report will provide the wrong availability. I think for availability report data value should be either 0 or 1.

      Please let me know if I am having wrong perception about aggregation. Also correct me if I am considering wrong parameters for database availability. 

      Thanks in advance.