FS
Documentation

Informix KB

From Documentation

(Difference between revisions)
Jump to: navigation, search
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_ChunksCSpace 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_proc75s


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