Informix KB

From Documentation

(Difference between revisions)

Revision as of 07:55, 14 July 2006

1 Overview
- 1.1 Informix Knowledge Base Version
2 Informix Knowledge Base
3 Sentry Details
- 3.1 Overview
- 3.2 Sentry State Details

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
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
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	75s	√
Onconfig_File	Informix	FileInfo	75s	√
Server_Info	Informix	infoAg	75s	√	√
Shared_Memory	Informix	Status	75s		√
Uptime	Informix	Status	75s		√
Users	Informix	Status	75s		√
Chunks	Chunks	CSpace	75s	√
DB_Spaces	DBspaces	CSpace	75s	√
Extents	Extents	Extnts	75s	√	√
Mirror_Chunks	Mirror_Chunks	CSpace	75s		√
Online_Log	Online_Log	OnLog	75s		√
Buffers	Performance	Perf	75s		√
CPU_States	Performance	Perf	75s		√
Checkpoint_Waits	Performance	Perf	75s		√
Deadlocks	Performance	Perf	75s		√
Latch_Waits	Performance	Perf	75s		√
Locks	Performance	Perf	75s		√
Over_User_Threads	Performance	Perf	75s		√
Read_Ahead	Performance	Perf	75s		√
Read_Chche	Performance	Perf	75s		√
Sequential_Scans	Performance	Perf	75s		√
Write_Cache	Performance	Perf	75s		√
Virtual_Processor	Processes	virtual_proc	75s		√

Sentry State Details

CPU_Hogs Sentry

Availability: AIX, HPUX, Linux, SCO, Solaris, Tru64

Constants

Constant	Description	Value
CPU_HIGH	Percentage CPU usage considered high for a process	10
CPU_VHIGH	Unacceptable percentage CPU usage for a process	50

States

State	Severity	Condition	Escalation
VHigh_CPU	info	$cpu_percent >= $CPU_VHIGH	warning after 160s, alarm after 400s
High_CPU	normal	$cpu_percent >= $CPU_HIGH
OK_CPU	disabled		delete immediately
Delete	built-in	No data state

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
Not_Running	alarm	$count == 0
Running_Mult	normal	$count > 0
Running	normal

Retrieved from "https://documentation.fs.com.au/index.php/Informix_KB"

 !width="65"  bgcolor="#cccccc" | Logging
 |-
-|CPU_Hogs           ||Processes  ||ProcessInfo ||75s  ||align="center" | &radic; ||
+|Active_Transactions ||Informix     ||Status      ||75s  ||align="center" | &radic; ||
 |-
-|Memory_Hogs        ||Processes  ||ProcessInfo ||75s  ||align="center" | &radic; ||
+|Onconfig_File       ||Informix     ||FileInfo    ||75s  ||align="center" | &radic; ||
 |-
-|Important_Processes||Processes  ||ProcessInfo ||75s  ||align="center" | &radic; ||align="center" | &radic;
+|Server_Info         ||Informix     ||infoAg      ||75s  ||align="center" | &radic; ||align="center" | &radic;
 |-
-|Event_Manager      ||Processes  ||ProcessInfo ||75s  ||                         ||align="center" | &radic;
+|Shared_Memory       ||Informix     ||Status      ||75s  ||                         ||align="center" | &radic;
 |-
-|Host_Monitor       ||Processes  ||ProcessInfo ||75s  ||                         ||align="center" | &radic;
+|Uptime              ||Informix     ||Status      ||75s  ||                         ||align="center" | &radic;
+|-
+|Users               ||Informix     ||Status      ||75s  ||                         ||align="center" | &radic;
+|-
+|Chunks              ||Chunks       ||CSpace      ||75s  ||align="center" | &radic; ||
+|-
+|DB_Spaces           ||DBspaces     ||CSpace      ||75s  ||align="center" | &radic; ||
+|-
+|Extents             ||Extents      ||Extnts      ||75s  ||align="center" | &radic; ||align="center" | &radic;
+|-
+|Mirror_Chunks       ||Mirror_Chunks||CSpace      ||75s  ||                         ||align="center" | &radic;
+|-
+|Online_Log          ||Online_Log   ||OnLog       ||75s  ||                         ||align="center" | &radic;
+|-
+|Buffers             ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|CPU_States          ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Checkpoint_Waits    ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Deadlocks           ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Latch_Waits         ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Locks               ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Over_User_Threads   ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Read_Ahead          ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Read_Chche          ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Sequential_Scans    ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Write_Cache         ||Performance  ||Perf        ||75s  ||                         ||align="center" | &radic;
+|-
+|Virtual_Processor   ||Processes    ||virtual_proc||75s  ||                         ||align="center" | &radic;
 |}
 <br>
 === Sentry State Details ===

Search

Informix KB

From Documentation

Revision as of 07:55, 14 July 2006

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

CPU_Hogs Sentry

Memory_Hogs Sentry

Important_Processes Sentry