Informix KB

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

From Documentation

(Difference between revisions)

Current revision

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.

 <br>
-==== Server_Info Sentry ====
+==== Onconfig_File Sentry ====
 ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
 !width="125" bgcolor="#cccccc" | State
 !width="65"  bgcolor="#cccccc" | Severity
-!width="390" bgcolor="#cccccc" | Condition
+!width="330" bgcolor="#cccccc" | Condition
-!width="120" bgcolor="#cccccc" | Escalation
+!width="180" bgcolor="#cccccc" | Escalation
 |-
 |-
 <br>
-==== Server_Info Sentry ====
+==== Shared_Memory Sentry ====
 ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN         ||alarm   ||$ix_status != "Up"    ||
+|DOWN       ||disabled||$ix_status != "Up"    ||
 |-
-|OFFLINE      ||warning ||$mode == "Off-Line"   ||
+|SHARED_MEM ||normal  ||                      ||
-|-
-|RASTRECOVERY ||info    ||$mode == "Fast Recovery" &#124;&#124; $mode == "Fast Recovery (CKPT REQ)" ||
-|-
-|QUIESCENT    ||info    ||$mode == "Quiescent"  ||
-|-
-|UP           ||normal  ||                      ||
 |}
 <br>
-==== Server_Info Sentry ====
+==== Uptime Sentry ====
 ;Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64
 !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" &#124;&#124; $mode == "Fast Recovery (CKPT REQ)" ||
-|-
-|QUIESCENT    ||info    ||$mode == "Quiescent"  ||
-|-
-|UP           ||normal  ||                      ||
 |}
 <br>
-==== Server_Info Sentry ====
+==== Users Sentry ====
 ;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'''
 !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" &#124;&#124; $mode == "Fast Recovery (CKPT REQ)" ||
+|MAX_CLIENTS  ||alarm   ||$active_users > $MAX_USERS  ||
 |-
-|QUIESCENT    ||info    ||$mode == "Quiescent"  ||
+|OK_CLIENTS   ||normal  ||                            ||
-|-
-|UP           ||normal  ||                      ||
 |}
 <br>
-==== Server_Info Sentry ====
+==== Chunks Sentry ====
 ;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'''
 !width="120" bgcolor="#cccccc" | Escalation
 |-
-|DOWN         ||alarm   ||$ix_status != "Up"    ||
+|DOWN   ||critical ||$chunk_status != "up" ||
 |-
-|OFFLINE      ||warning ||$mode == "Off-Line"   ||
+|ONLINE ||normal   ||                      ||
 |-
-|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>

Sentry	AIX	HPUX	Linux	SCO	Solaris	Tru64
Active_Transactions	√	√	√	√	√	√
Onconfig_File	√	√	√	√	√	√
Server_Infor	√	√	√	√	√	√
Shared_Memory	√	√	√	√	√	√
Uptime	√	√	√	√	√	√
Users	√	√	√	√	√	√

Sentry	AIX	HPUX	Linux	SCO	Solaris	Tru64
Buffers	√	√	√	√	√	√
CPU_States	√	√	√	√	√	√
Checkpoint_Waits	√	√	√	√	√	√
Deadlocks	√	√	√	√	√	√
Latch_Waits	√	√	√	√	√	√
Locks	√	√	√	√	√	√
Over_User_Threads	√	√	√	√	√	√
Read_Ahead	√	√	√	√	√	√
Read_Cache	√	√	√	√	√	√
Sequential_Scans	√	√	√	√	√	√
Write_Cache	√	√	√	√	√	√

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	√

State	Severity	Condition	Escalation
MODIFIED	warning	$mtime != $prev_mtime	OK after acknowledgement
DOWN	disabled	$ix_status != "Up"
DELETED	alarm	!$exists
OK	normal n

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

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

State	Severity	Condition
DOWN	critical	$chunk_status != "up"
ONLINE	normal
Delete	built-in	No data state

Search

Informix KB

From Documentation

Current revision

Contents

Overview

Informix Knowledge Base Version

Informix Knowledge Base

Informix Class

Informix Chunks Class

Informix DBspaces Class

Informix Extents Class

Informix Mirror Chunks Class

Informix Online Log Class

Informix Performance Class

Informix Processes Class

Sentry Details

Overview

Sentry State Details

Active_Transactions Sentry

Onconfig_File Sentry

Server_Info Sentry

Shared_Memory Sentry

Uptime Sentry

Users Sentry

Chunks Sentry