Informix KB
This page was last modified 08:57, 14 July 2006.From Documentation
(Difference between revisions)
| Revision as of 07:55, 14 July 2006 Moff (Talk | contribs) (→Overview) ← Previous diff |
Current revision Moff (Talk | contribs) (→Users Sentry) |
||
| 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" | √ || |
| |} | |} | ||
| Line 400: | Line 400: | ||
| === Sentry State Details === | === Sentry State Details === | ||
| - | ==== CPU_Hogs Sentry ==== | + | ==== Active_Transactions Sentry ==== |
| ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| - | '''Constants''' | + | '''States''' |
| {| border="1" cellpadding="6" cellspacing="0" | {| border="1" cellpadding="6" cellspacing="0" | ||
| - | !width="150" bgcolor="#cccccc" | Constant | + | !width="125" bgcolor="#cccccc" | State |
| - | !width="500" bgcolor="#cccccc" | Description | + | !width="65" bgcolor="#cccccc" | Severity |
| - | !width="65" bgcolor="#cccccc" | Value | + | !width="390" bgcolor="#cccccc" | Condition |
| + | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| - | |CPU_HIGH ||Percentage CPU usage considered high for a process ||10 | + | |DOWN ||disabled ||$ix_status != "Up" || |
| |- | |- | ||
| - | |CPU_VHIGH ||Unacceptable percentage CPU usage for a process ||50 | + | |OK_TRANS ||normal || || |
| |} | |} | ||
| + | |||
| + | <br> | ||
| + | |||
| + | ==== Onconfig_File Sentry ==== | ||
| + | |||
| + | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| + | |||
| + | '''States''' | ||
| + | |||
| + | {| border="1" cellpadding="6" cellspacing="0" | ||
| + | !width="125" bgcolor="#cccccc" | State | ||
| + | !width="65" bgcolor="#cccccc" | Severity | ||
| + | !width="330" bgcolor="#cccccc" | Condition | ||
| + | !width="180" bgcolor="#cccccc" | Escalation | ||
| + | |- | ||
| + | |- | ||
| + | |MODIFIED ||warning ||$mtime != $prev_mtime ||OK after acknowledgement | ||
| + | |- | ||
| + | |DOWN ||disabled ||$ix_status != "Up" || | ||
| + | |- | ||
| + | |DELETED ||alarm ||!$exists || | ||
| + | |- | ||
| + | |OK ||normal n || || | ||
| + | |} | ||
| + | |||
| + | <br> | ||
| + | |||
| + | ==== Server_Info Sentry ==== | ||
| + | |||
| + | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| '''States''' | '''States''' | ||
| Line 424: | Line 455: | ||
| !width="120" bgcolor="#cccccc" | Escalation | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| - | |VHigh_CPU ||info ||$cpu_percent >= $CPU_VHIGH ||warning after 160s, alarm after 400s | + | |DOWN ||alarm ||$ix_status != "Up" || |
| |- | |- | ||
| - | |High_CPU ||normal ||$cpu_percent >= $CPU_HIGH || | + | |OFFLINE ||warning ||$mode == "Off-Line" || |
| |- | |- | ||
| - | |OK_CPU ||disabled || ||delete immediately | + | |RASTRECOVERY ||info ||$mode == "Fast Recovery" || $mode == "Fast Recovery (CKPT REQ)" || |
| |- | |- | ||
| - | |Delete ||built-in ||No data state || | + | |QUIESCENT ||info ||$mode == "Quiescent" || |
| + | |- | ||
| + | |UP ||normal || || | ||
| |} | |} | ||
| <br> | <br> | ||
| - | ==== Memory_Hogs Sentry ==== | + | ==== Shared_Memory Sentry ==== |
| + | |||
| + | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| + | |||
| + | '''States''' | ||
| + | |||
| + | {| border="1" cellpadding="6" cellspacing="0" | ||
| + | !width="125" bgcolor="#cccccc" | State | ||
| + | !width="65" bgcolor="#cccccc" | Severity | ||
| + | !width="390" bgcolor="#cccccc" | Condition | ||
| + | !width="120" bgcolor="#cccccc" | Escalation | ||
| + | |- | ||
| + | |DOWN ||disabled||$ix_status != "Up" || | ||
| + | |- | ||
| + | |SHARED_MEM ||normal || || | ||
| + | |} | ||
| + | |||
| + | <br> | ||
| + | |||
| + | ==== Uptime Sentry ==== | ||
| + | |||
| + | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| + | |||
| + | '''States''' | ||
| + | |||
| + | {| border="1" cellpadding="6" cellspacing="0" | ||
| + | !width="125" bgcolor="#cccccc" | State | ||
| + | !width="65" bgcolor="#cccccc" | Severity | ||
| + | !width="390" bgcolor="#cccccc" | Condition | ||
| + | !width="120" bgcolor="#cccccc" | Escalation | ||
| + | |- | ||
| + | |DOWN ||disabled||$ix_status != "Up" || | ||
| + | |- | ||
| + | |UPTIME ||normal || || | ||
| + | |} | ||
| + | |||
| + | <br> | ||
| + | |||
| + | ==== Users Sentry ==== | ||
| ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64 | ||
| Line 445: | Line 516: | ||
| !width="65" bgcolor="#cccccc" | Value | !width="65" bgcolor="#cccccc" | Value | ||
| |- | |- | ||
| - | |MEMORY_HIGH ||Percentage memory usage considered high for a process ||10 | + | |OK_USERS ||Indicating OK number of connections ||790 |
| |- | |- | ||
| - | |MEMORY_VHIGH ||Unacceptable percentage memory usage for a process ||50 | + | |MAX_USERS ||Indicating maximum number of connections ||830 |
| + | |- | ||
| + | |HIGH_USERS ||Indicating a high number of connections ||930 | ||
| |} | |} | ||
| Line 458: | Line 531: | ||
| !width="120" bgcolor="#cccccc" | Escalation | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| + | |DOWN ||disabled||$ix_status != "Up" || | ||
| |- | |- | ||
| - | |VHigh_Memory ||info ||$mem_percent >= $MEMORY_VHIGH ||warning after 160s, alarm after 400s | + | |HIGH_CLIENTS ||alarm ||$active_users > $HIGH_USERS || |
| |- | |- | ||
| - | |High_Memory ||normal ||$mem_percent >= $MEMORY_HIGH || | + | |MAX_CLIENTS ||alarm ||$active_users > $MAX_USERS || |
| |- | |- | ||
| - | |OK_Memory ||disabled || ||delete immediately | + | |OK_CLIENTS ||normal || || |
| - | |- | + | |
| - | |Delete ||built-in ||No data state || | + | |
| |} | |} | ||
| <br> | <br> | ||
| - | ==== Important_Processes 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 481: | Line 570: | ||
| !width="120" bgcolor="#cccccc" | Escalation | !width="120" bgcolor="#cccccc" | Escalation | ||
| |- | |- | ||
| - | |Not_Running ||alarm ||$count == 0 || | + | |DOWN ||critical ||$chunk_status != "up" || |
| |- | |- | ||
| - | |Running_Mult ||normal ||$count > 0 || | + | |ONLINE ||normal || || |
| |- | |- | ||
| - | |Running ||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 |