Informix KB
This page was last modified 08:57, 14 July 2006.From Documentation
(Difference between revisions)
| Revision as of 08:45, 14 July 2006 Moff (Talk | contribs) (→Server_Info Sentry) ← Previous diff |
Current revision Moff (Talk | contribs) (→Users Sentry) |
||
| Line 486: | Line 486: | ||
| <br> | <br> | ||
| - | ==== Server_Info Sentry ==== | + | ==== Uptime Sentry ==== |
| ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| Line 498: | Line 498: | ||
| !width="120" bgcolor="#cccccc" | Escalation | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| - | |DOWN ||alarm ||$ix_status != "Up" || | + | |DOWN ||disabled||$ix_status != "Up" || |
| |- | |- | ||
| - | |OFFLINE ||warning ||$mode == "Off-Line" || | + | |UPTIME ||normal || || |
| - | |- | + | |
| - | |RASTRECOVERY ||info ||$mode == "Fast Recovery" || $mode == "Fast Recovery (CKPT REQ)" || | + | |
| - | |- | + | |
| - | |QUIESCENT ||info ||$mode == "Quiescent" || | + | |
| - | |- | + | |
| - | |UP ||normal || || | + | |
| |} | |} | ||
| <br> | <br> | ||
| - | ==== Server_Info Sentry ==== | + | |
| + | ==== Users Sentry ==== | ||
| ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| + | |||
| + | '''Constants''' | ||
| + | |||
| + | {| border="1" cellpadding="6" cellspacing="0" | ||
| + | !width="150" bgcolor="#cccccc" | Constant | ||
| + | !width="500" bgcolor="#cccccc" | Description | ||
| + | !width="65" bgcolor="#cccccc" | Value | ||
| + | |- | ||
| + | |OK_USERS ||Indicating OK number of connections ||790 | ||
| + | |- | ||
| + | |MAX_USERS ||Indicating maximum number of connections ||830 | ||
| + | |- | ||
| + | |HIGH_USERS ||Indicating a high number of connections ||930 | ||
| + | |} | ||
| '''States''' | '''States''' | ||
| Line 522: | Line 531: | ||
| !width="120" bgcolor="#cccccc" | Escalation | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| - | |DOWN ||alarm ||$ix_status != "Up" || | + | |DOWN ||disabled||$ix_status != "Up" || |
| |- | |- | ||
| - | |OFFLINE ||warning ||$mode == "Off-Line" || | + | |HIGH_CLIENTS ||alarm ||$active_users > $HIGH_USERS || |
| |- | |- | ||
| - | |RASTRECOVERY ||info ||$mode == "Fast Recovery" || $mode == "Fast Recovery (CKPT REQ)" || | + | |MAX_CLIENTS ||alarm ||$active_users > $MAX_USERS || |
| |- | |- | ||
| - | |QUIESCENT ||info ||$mode == "Quiescent" || | + | |OK_CLIENTS ||normal || || |
| - | |- | + | |
| - | |UP ||normal || || | + | |
| |} | |} | ||
| <br> | <br> | ||
| - | ==== Server_Info Sentry ==== | + | |
| + | ==== Chunks Sentry ==== | ||
| ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| + | |||
| + | '''Constants''' | ||
| + | |||
| + | {| border="1" cellpadding="6" cellspacing="0" | ||
| + | !width="150" bgcolor="#cccccc" | Constant | ||
| + | !width="500" bgcolor="#cccccc" | Description | ||
| + | !width="65" bgcolor="#cccccc" | Value | ||
| + | |- | ||
| + | |LOW ||Indicating low free chunkspace ||35 | ||
| + | |- | ||
| + | |VERY_LOW ||Indicating very low free chunkspace ||25 | ||
| + | |- | ||
| + | |NEARLY_FULL ||Indicating the chunkspace is nearly full ||15 | ||
| + | |- | ||
| + | |FULL ||Indicating the chunkspace is full ||0 | ||
| + | |} | ||
| '''States''' | '''States''' | ||
| Line 546: | Line 570: | ||
| !width="120" bgcolor="#cccccc" | Escalation | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| - | |DOWN ||alarm ||$ix_status != "Up" || | + | |DOWN ||critical ||$chunk_status != "up" || |
| - | |- | + | |
| - | |OFFLINE ||warning ||$mode == "Off-Line" || | + | |
| - | |- | + | |
| - | |RASTRECOVERY ||info ||$mode == "Fast Recovery" || $mode == "Fast Recovery (CKPT REQ)" || | + | |
| |- | |- | ||
| - | |QUIESCENT ||info ||$mode == "Quiescent" || | + | |ONLINE ||normal || || |
| |- | |- | ||
| - | |UP ||normal || || | + | |Delete ||built-in ||No data state || |
| |} | |} | ||
| <br> | <br> | ||
Current revision
Contents |
[edit]
Overview
The primary aim of the Informix knowledge base in Sentinel3G is to provide notification of CPU and memory hungry processes using monitoring that is consistent across various UNIX, Linux and Windows platforms. Due to differences between the various operating systems we monitor, complete consistency is not always achievable. This document describes the general content of the Process knowledge base, and the discrepancies between them on different platforms.
[edit]
Informix Knowledge Base Version
| Version | Availability Date | Min Sentinel Version |
|---|---|---|
| 1.5 | 11th Jul, 2003 | 4.3 |
[edit]
Informix Knowledge Base
[edit]
Informix Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Active_Transactions | √ | √ | √ | √ | √ | √ | |
| Onconfig_File | √ | √ | √ | √ | √ | √ | |
| Server_Infor | √ | √ | √ | √ | √ | √ | |
| Shared_Memory | √ | √ | √ | √ | √ | √ | |
| Uptime | √ | √ | √ | √ | √ | √ | |
| Users | √ | √ | √ | √ | √ | √ |
[edit]
Informix Chunks Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Chunks | √ | √ | √ | √ | √ | √ |
[edit]
Informix DBspaces Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| DB_Spaces | √ | √ | √ | √ | √ | √ |
[edit]
Informix Extents Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Extents | √ | √ | √ | √ | √ | √ |
[edit]
Informix Mirror Chunks Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Mirror_Chunks | √ | √ | √ | √ | √ | √ |
[edit]
Informix Online Log Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Online_Log | √ | √ | √ | √ | √ | √ |
[edit]
Informix Performance Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Buffers | √ | √ | √ | √ | √ | √ | |
| CPU_States | √ | √ | √ | √ | √ | √ | |
| Checkpoint_Waits | √ | √ | √ | √ | √ | √ | |
| Deadlocks | √ | √ | √ | √ | √ | √ | |
| Latch_Waits | √ | √ | √ | √ | √ | √ | |
| Locks | √ | √ | √ | √ | √ | √ | |
| Over_User_Threads | √ | √ | √ | √ | √ | √ | |
| Read_Ahead | √ | √ | √ | √ | √ | √ | |
| Read_Cache | √ | √ | √ | √ | √ | √ | |
| Sequential_Scans | √ | √ | √ | √ | √ | √ | |
| Write_Cache | √ | √ | √ | √ | √ | √ |
[edit]
Informix Processes Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Virtual_Processor | √ | √ | √ | √ | √ | √ |
[edit]
Sentry Details
[edit]
Overview
| Sentry | Class | Agent | Poll Time | States | Logging |
|---|---|---|---|---|---|
| Active_Transactions | Informix | Status | 60s | √ | √ |
| Onconfig_File | Informix | FileInfo | 20s | √ | |
| Server_Info | Informix | infoAg | 30s | √ | |
| Shared_Memory | Informix | Status | 60s | √ | |
| Uptime | Informix | Status | 60s | √ | |
| Users | Informix | Status | 60s | √ | √ |
| Chunks | Chunks | CSpace | 900s | √ | |
| DB_Spaces | DBspaces | CSpace | 900s | √ | |
| Extents | Extents | Extnts | 300s | √ | |
| Mirror_Chunks | Mirror_Chunks | CSpace | 900s | √ | |
| Online_Log | Online_Log | OnLog | n/a | √ | |
| Buffers | Performance | Perf | 90s | √ | |
| CPU_States | Performance | Perf | 90s | √ | √ |
| Checkpoint_Waits | Performance | Perf | 90s | √ | |
| Deadlocks | Performance | Perf | 90s | √ | |
| Latch_Waits | Performance | Perf | 90s | √ | |
| Locks | Performance | Perf | 90s | √ | |
| Over_User_Threads | Performance | Perf | 90s | √ | |
| Read_Ahead | Performance | Perf | 90s | √ | √ |
| Read_Chche | Performance | Perf | 90s | √ | √ |
| Sequential_Scans | Performance | Perf | 90s | √ | √ |
| Write_Cache | Performance | Perf | 90s | √ | √ |
| Virtual_Processor | Processes | virtual_proc | 75s | √ |
[edit]
Sentry State Details
[edit]
Active_Transactions Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | disabled | $ix_status != "Up" | |
| OK_TRANS | normal |
[edit]
Onconfig_File Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| MODIFIED | warning | $mtime != $prev_mtime | OK after acknowledgement |
| DOWN | disabled | $ix_status != "Up" | |
| DELETED | alarm | !$exists | |
| OK | normal n |
[edit]
Server_Info Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | alarm | $ix_status != "Up" | |
| OFFLINE | warning | $mode == "Off-Line" | |
| RASTRECOVERY | info | $mode == "Fast Recovery" || $mode == "Fast Recovery (CKPT REQ)" | |
| QUIESCENT | info | $mode == "Quiescent" | |
| UP | normal |
[edit]
Shared_Memory Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | disabled | $ix_status != "Up" | |
| SHARED_MEM | normal |
[edit]
Uptime Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | disabled | $ix_status != "Up" | |
| UPTIME | normal |
[edit]
Users Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
Constants
| Constant | Description | Value |
|---|---|---|
| OK_USERS | Indicating OK number of connections | 790 |
| MAX_USERS | Indicating maximum number of connections | 830 |
| HIGH_USERS | Indicating a high number of connections | 930 |
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | disabled | $ix_status != "Up" | |
| HIGH_CLIENTS | alarm | $active_users > $HIGH_USERS | |
| MAX_CLIENTS | alarm | $active_users > $MAX_USERS | |
| OK_CLIENTS | normal |
[edit]
Chunks Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
Constants
| Constant | Description | Value |
|---|---|---|
| LOW | Indicating low free chunkspace | 35 |
| VERY_LOW | Indicating very low free chunkspace | 25 |
| NEARLY_FULL | Indicating the chunkspace is nearly full | 15 |
| FULL | Indicating the chunkspace is full | 0 |
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | critical | $chunk_status != "up" | |
| ONLINE | normal | ||
| Delete | built-in | No data state |