KBI 220635 Different SLA Rules Assigned To Same Key In Database
Version
Argent Predictor 8.0A-0607C through 8.0A-0701
Date
29 September 2006
Summary
Different SLA Rules Are Assigned To Same Key In Argent Predictor DB
Technical Background
One can configure different SLA/Connectivity Rules against a single device, for example, NDE_TCPIP_PING and NDE_ORACLE_LOGON. The Rules both send data to the Argent Predictor, and they are both logged against the same key in the database table AOM_PRD_MASTER:
object | counter | instance |
Service Level Agreement | System Alive | ARGENTVM |
These are field values in the database table
AOM_PRD_MASTER: object=’Service Level Agreement’, counter=’System Alive’, instance=’ARGENTVM’.
This means that it is not possible to do sensible reporting against more than one SLA/Connectivity Rule on the same device. As an example, if NDE_ORACLE_LOGON is failing and NDE_TCPIP_PING is succeeding, the single SLA category available in the Argent Predictor database will show a 50% availability metric. It is not possible to pick each Rule individually in the SLA reports and report against them separately.
This issue is present in the Argent Predictor tables associated with the Argent Monitor for Oracle, the Argent SQL Monitor, and the Argent Guardian.
Resolution
If reporting on multiple SLA/Connectivity Rules are required against a single device, a workaround is to configure each Rule in a separate Argent product. For example, the NDE_TCPIP_PING Rule could be configured (and reported on) in the Argent Guardian, and the NDE_ORACLE_LOGON Rule could be used in the Argent Monitor For Oracle.