ema_check_ingres
The ema_check_ingres plug-in checks the status of various Ingres components.
Information that can displayed includes:
• Correct or incorrect number of Ingres servers running
• List of significant Ingres errors reported
• Transaction log file usage
• Number of user sessions and information on sessions threads
• Status of communications servers and/or number of connections
The plug-in has the following format:
ema_check_ingres --system ii_system_value [--errlog] [--servers|--client] [--logfile logfile_options] [--sessions] [--connections connections_options] [--lockwaits lockwaits_options] [--lrq lrq_options] [--license license_options] [--check_inst] [--check_db db_options]
| --help |--version
--system ii_system_value
Specifies the value of your Ingres II_SYSTEM.
--errlog
Checks the Ingres error log and display list of errors reported since last check.
--servers
Shows server information
--client
Shows client-only information
--logfile logfile_options
Shows log file information. Specify log_options as follows:
-w %
Where % is the warning fullness percentage
-c %
Where % is the critical fullness percentage
--sessions
Shows session information.
--connections connections_options
Shows connections information. Specify connections_options as follows:
-f local_address foreign_address
Where above addresses relate to Linux netstat output
--lockwaits lockwaits_options
Shows lockwait information. Specify lockwaits_options as follows:
-d dbname
Specifies database name.
-VW
Checks locks for the database but in the X100 engine.
-w %
Where % is the warning usage percentage
-c %
Where % is the critical usage percentage
--lrq lrq_options
Shows long-running-query information. Specify lrq_options as follows:
-d dbname
Checks for long running queries against the specified database.
ALL
Checks for long running queries against all databases.
--license license_options
Shows license information. Specify lockwaits_options as follows:
-W #
Where # is number of days until license expires when a warning is produced.
--check_inst
Checks availability of the installation.
--check_db db_options
Checks database availability. Specify db_options as follows:
-d dbname
Checks availability of specified database.
-VW
Checks availability of X100 Server for the database.
--version
Displays version of the plug-in.
--help
Shows usage statement for the plug-in.
Example:
Check for a transaction critical log full of 90% plus any other errors:
ema_check_ingres --system $II_SYSTEM --logfile -w90 --errlog
Last modified date: 01/30/2023