30. Database Tier - Invalid Objects¶
It is important not to have invalid objects in the IFS database. These checks will monitor if invalid triggers, packages, bodies or views exists. If invalid objects still exist it might impact business processes.
Multiple Instances: No
Interval: Every 5 minutes (288 times per day)
| Status | Expression |
|---|---|
| Critical | If ( Invalid Triggers > 0) or ( Invalid Packages > 0) or ( Invalid Bodies > 0) or ( Invalid Views > 0) |
| OK | If not status Critical. |
| Unknown | Missing application response. |
| Metric & Service | Command line example |
|---|---|
| Invalid Triggers | java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_TRIGGERS -ca=0 |
| Invalid Packages | java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_PACKAGES -ca=0 |
| Invalid Bodies | java -jar application-monitoring-metrics-cli.jar db -host=localhost -instance=<instancename> -user=ifsmonitoring -pass=<password> -appowner=<value> -request=INVALID_BODIES -ca=0 |
| Invalid Views |