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: | ||