FS
Documentation
You are here
Search
 

Informix KB

This page was last modified 08:57, 14 July 2006.

From Documentation

(Difference between revisions)
Jump to: navigation, search
Revision as of 07:32, 14 July 2006
Moff (Talk | contribs)

← Previous diff		 Current revision
Moff (Talk | contribs)
(→Users Sentry)
Line 349: Line 349:
!width="65" bgcolor="#cccccc" | Logging !width="65" bgcolor="#cccccc" | Logging
|- |-
-|CPU_Hogs ||Processes ||ProcessInfo ||75s ||align="center" | √ ||+|Active_Transactions ||Informix ||Status ||60s ||align="center" | √ ||align="center" | √
|- |-
-|Memory_Hogs ||Processes ||ProcessInfo ||75s ||align="center" | √ ||+|Onconfig_File ||Informix ||FileInfo ||20s ||align="center" | √ ||
|- |-
-|Important_Processes||Processes ||ProcessInfo ||75s ||align="center" | √ ||align="center" | √+|Server_Info ||Informix ||infoAg ||30s ||align="center" | √ ||
|- |-
-|Event_Manager ||Processes ||ProcessInfo ||75s || ||align="center" | √+|Shared_Memory ||Informix ||Status ||60s ||align="center" | √ ||
|- |-
-|Host_Monitor ||Processes ||ProcessInfo ||75s || ||align="center" | √+|Uptime ||Informix ||Status ||60s ||align="center" | √ ||
 +|-
 +|Users ||Informix ||Status ||60s ||align="center" | √ ||align="center" | √
 +|-
 +|Chunks ||Chunks ||CSpace ||900s ||align="center" | √ ||
 +|-
 +|DB_Spaces ||DBspaces ||CSpace ||900s ||align="center" | √ ||
 +|-
 +|Extents ||Extents ||Extnts ||300s ||align="center" | √ ||
 +|-
 +|Mirror_Chunks ||Mirror_Chunks||CSpace ||900s ||align="center" | √ ||
 +|-
 +|Online_Log ||Online_Log ||OnLog ||n/a ||align="center" | √ ||
 +|-
 +|Buffers ||Performance ||Perf ||90s ||align="center" | √ ||
 +|-
 +|CPU_States ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √
 +|-
 +|Checkpoint_Waits ||Performance ||Perf ||90s ||align="center" | √ ||
 +|-
 +|Deadlocks ||Performance ||Perf ||90s ||align="center" | √ ||
 +|-
 +|Latch_Waits ||Performance ||Perf ||90s ||align="center" | √ ||
 +|-
 +|Locks ||Performance ||Perf ||90s ||align="center" | √ ||
 +|-
 +|Over_User_Threads ||Performance ||Perf ||90s ||align="center" | √ ||
 +|-
 +|Read_Ahead ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √
 +|-
 +|Read_Chche ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √
 +|-
 +|Sequential_Scans ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √
 +|-
 +|Write_Cache ||Performance ||Perf ||90s ||align="center" | √ ||align="center" | √
 +|-
 +|Virtual_Processor ||Processes ||virtual_proc||75s ||align="center" | √ ||
|} |}
<br> <br>
 +
=== 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 387: 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" &#124;&#124; $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 408: 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 421: 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 444: 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_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 √


[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


Retrieved from "https://documentation.fs.com.au/index.php/Informix_KB"
Home : About : Contact Us : Site Map : Terms of Use
All trademarks and registered trademarks of products mentioned in this web site are recognised by Functional Software. Site content and images © 1997-2021 Functional Software