This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
uls:agents:informix_tools [2014-06-24 13:18] uls created |
uls:agents:informix_tools [2014-12-16 17:43] (current) uls [ULS-Agent for Informix Databases] |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== ULS-Agent for Informix Databases ===== | ===== ULS-Agent for Informix Databases ===== | ||
- | Aka the INFORMIX_TOOLS, is the ULS-agent for gathering runtime metrics | + | Aka the INFORMIX_TOOLS, is the [[http://www.gnu.org/licenses/gpl.txt|GPLv3]]-based ULS-agent for gathering runtime metrics |
and status information, logging configuration settings and | and status information, logging configuration settings and | ||
executing regular administrative jobs on [[http://www-01.ibm.com/software/data/informix/|Informix]] database instances | executing regular administrative jobs on [[http://www-01.ibm.com/software/data/informix/|Informix]] database instances | ||
Line 12: | Line 12: | ||
* gather runtime metrics of an Informix database instance | * gather runtime metrics of an Informix database instance | ||
- | * do regular full database backups and backup of logical logs | + | * do regular databse consistency checks, full database backups and backup of logical logs |
* collect database relevant information as a Informix instance information report | * collect database relevant information as a Informix instance information report | ||
* provide database start and stop scripts, used in [[:sccl]] packages | * provide database start and stop scripts, used in [[:sccl]] packages | ||
Line 30: | Line 30: | ||
==== Features ==== | ==== Features ==== | ||
- | The ORACLE_TOOLS provide: | + | The INFORMIX_TOOLS provide: |
- | * metrics about sessions, processes and PGA | + | * number of current sessions, data manipulations and sorting |
- | * several system statistics like db block changes, physical reads and writes, sorts, user calls and commits | + | * buffer and disk reads and writes and their cache hit ratios |
- | * information about tablespace usage | + | * information about dbspace and sblobspace usage |
- | * figures of the SGA, buffer cache and shared pool usage | + | * figures of the memory consumption, logical log usage and flusher activity |
- | * metrics about fast recovery area, wait events, redo logs | + | * filtered contents of the online.log (database instance message file) |
+ | ----- | ||
==== Download & Installation ==== | ==== Download & Installation ==== | ||
Line 73: | Line 74: | ||
----- | ----- | ||
- | ==== What You Got ==== | + | ==== What You Get ==== |
The scripts of the INFORMIX_TOOLS: | The scripts of the INFORMIX_TOOLS: |