Informix KB
From Documentation
(Difference between revisions)
| Revision as of 07:58, 14 July 2006 Moff (Talk | contribs) (→CPU_Hogs Sentry) ← Previous diff |
Revision as of 08:10, 14 July 2006 Moff (Talk | contribs) (→Overview) Next diff → |
||
| Line 349: | Line 349: | ||
| !width="65" bgcolor="#cccccc" | Logging | !width="65" bgcolor="#cccccc" | Logging | ||
| |- | |- | ||
| - | |Active_Transactions ||Informix ||Status ||75s ||align="center" | √ || | + | |Active_Transactions ||Informix ||Status ||60s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Onconfig_File ||Informix ||FileInfo ||75s ||align="center" | √ || | + | |Onconfig_File ||Informix ||FileInfo ||20s ||align="center" | √ || |
| |- | |- | ||
| - | |Server_Info ||Informix ||infoAg ||75s ||align="center" | √ ||align="center" | √ | + | |Server_Info ||Informix ||infoAg ||30s ||align="center" | √ || |
| |- | |- | ||
| - | |Shared_Memory ||Informix ||Status ||75s || ||align="center" | √ | + | |Shared_Memory ||Informix ||Status ||60s ||align="center" | √ || |
| |- | |- | ||
| - | |Uptime ||Informix ||Status ||75s || ||align="center" | √ | + | |Uptime ||Informix ||Status ||60s ||align="center" | √ || |
| |- | |- | ||
| - | |Users ||Informix ||Status ||75s || ||align="center" | √ | + | |Users ||Informix ||Status ||60s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Chunks ||Chunks ||CSpace ||75s ||align="center" | √ || | + | |Chunks ||Chunks ||CSpace ||900s ||align="center" | √ || |
| |- | |- | ||
| - | |DB_Spaces ||DBspaces ||CSpace ||75s ||align="center" | √ || | + | |DB_Spaces ||DBspaces ||CSpace ||900s ||align="center" | √ || |
| |- | |- | ||
| - | |Extents ||Extents ||Extnts ||75s ||align="center" | √ ||align="center" | √ | + | |Extents ||Extents ||Extnts ||300s ||align="center" | √ || |
| |- | |- | ||
| - | |Mirror_Chunks ||Mirror_Chunks||CSpace ||75s || ||align="center" | √ | + | |Mirror_Chunks ||Mirror_Chunks||CSpace ||900s ||align="center" | √ || |
| |- | |- | ||
| - | |Online_Log ||Online_Log ||OnLog ||75s || ||align="center" | √ | + | |Online_Log ||Online_Log ||OnLog ||n/a ||align="center" | √ || |
| |- | |- | ||
| - | |Buffers ||Performance ||Perf ||75s || ||align="center" | √ | + | |Buffers ||Performance ||Perf ||90s ||align="center" | √ || |
| |- | |- | ||
| - | |CPU_States ||Performance ||Perf ||75s || ||align="center" | √ | + | |CPU_States ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Checkpoint_Waits ||Performance ||Perf ||75s || ||align="center" | √ | + | |Checkpoint_Waits ||Performance ||Perf ||90s ||align="center" | √ || |
| |- | |- | ||
| - | |Deadlocks ||Performance ||Perf ||75s || ||align="center" | √ | + | |Deadlocks ||Performance ||Perf ||90s ||align="center" | √ || |
| |- | |- | ||
| - | |Latch_Waits ||Performance ||Perf ||75s || ||align="center" | √ | + | |Latch_Waits ||Performance ||Perf ||90s ||align="center" | √ || |
| |- | |- | ||
| - | |Locks ||Performance ||Perf ||75s || ||align="center" | √ | + | |Locks ||Performance ||Perf ||90s ||align="center" | √ || |
| |- | |- | ||
| - | |Over_User_Threads ||Performance ||Perf ||75s || ||align="center" | √ | + | |Over_User_Threads ||Performance ||Perf ||90s ||align="center" | √ || |
| |- | |- | ||
| - | |Read_Ahead ||Performance ||Perf ||75s || ||align="center" | √ | + | |Read_Ahead ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Read_Chche ||Performance ||Perf ||75s || ||align="center" | √ | + | |Read_Chche ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Sequential_Scans ||Performance ||Perf ||75s || ||align="center" | √ | + | |Sequential_Scans ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Write_Cache ||Performance ||Perf ||75s || ||align="center" | √ | + | |Write_Cache ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √ |
| |- | |- | ||
| - | |Virtual_Processor ||Processes ||virtual_proc||75s || ||align="center" | √ | + | |Virtual_Processor ||Processes ||virtual_proc||75s ||align="center" | √ || |
| |} | |} | ||
Revision as of 08:10, 14 July 2006
Contents |
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.
Informix Knowledge Base Version
| Version | Availability Date | Min Sentinel Version |
|---|---|---|
| 1.5 | 11th Jul, 2003 | 4.3 |
Informix Knowledge Base
Informix Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Active_Transactions | √ | √ | √ | √ | √ | √ | |
| Onconfig_File | √ | √ | √ | √ | √ | √ | |
| Server_Infor | √ | √ | √ | √ | √ | √ | |
| Shared_Memory | √ | √ | √ | √ | √ | √ | |
| Uptime | √ | √ | √ | √ | √ | √ | |
| Users | √ | √ | √ | √ | √ | √ |
Informix Chunks Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Chunks | √ | √ | √ | √ | √ | √ |
Informix DBspaces Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| DB_Spaces | √ | √ | √ | √ | √ | √ |
Informix Extents Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Extents | √ | √ | √ | √ | √ | √ |
Informix Mirror Chunks Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Mirror_Chunks | √ | √ | √ | √ | √ | √ |
Informix Online Log Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Online_Log | √ | √ | √ | √ | √ | √ |
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 | √ | √ | √ | √ | √ | √ |
Informix Processes Class
| Sentry | AIX | HPUX | Linux | SCO | Solaris | Tru64 | Windows |
|---|---|---|---|---|---|---|---|
| Virtual_Processor | √ | √ | √ | √ | √ | √ |
Sentry Details
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 | √ |
Sentry State Details
Active_Transactions Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| DOWN | disabled | $ix_status != "Up" | |
| OK_TRANS | normal |
Memory_Hogs Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
Constants
| Constant | Description | Value |
|---|---|---|
| MEMORY_HIGH | Percentage memory usage considered high for a process | 10 |
| MEMORY_VHIGH | Unacceptable percentage memory usage for a process | 50 |
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| VHigh_Memory | info | $mem_percent >= $MEMORY_VHIGH | warning after 160s, alarm after 400s |
| High_Memory | normal | $mem_percent >= $MEMORY_HIGH | |
| OK_Memory | disabled | delete immediately | |
| Delete | built-in | No data state |
Important_Processes Sentry
- Availability
- AIX, HPUX, Linux, SCO, Solaris, Tru64
States
| State | Severity | Condition | Escalation |
|---|---|---|---|
| Not_Running | alarm | $count == 0 | |
| Running_Mult | normal | $count > 0 | |
| Running | normal |