Was this helpful?
ema_check_ingres_lock
The ema_check_ingres_lock plug-in checks the status of Ingres locks. This plug-in can be called indirectly from the ema_check_ingres plug-in.
Information displayed includes:
Lock used percentages
Waiting/Active sessions information
The plug-in has the following format:
ema_check_ingres_lock -s|--system ii_system [--database dbname] [-vw x100_options] [-w warn%] [-W warn_value] [-c critical%] [-C critical_value] -test testval| --help |--version
--s | system ii_system_value
Specifies value of your Ingres II_SYSTEM.
--d | database dbname
Specifies name of database to check.
-v | -vw x100_options
Y – Checks locks in associated x100 engine.
N – Does not check locks in associated x100 engine.
-w warn%
Specifies a percentage that indicates a warning condition.
-W warn_value
Specifies a threshold amount that indicates a warning condition.
-c critical%
Specifies a percentage that indicates a critical condition.
-C critical_value
Specifies a threshold amount that indicates a critical condition.
-t testval
5 – Tests using values in conjunction with -W and -C
6 – Tests using percentages in conjunction with -w and -c
--version
Displays version of the plug-in.
--help
Shows usage statement for the plug-in.
Example:
Check for 5000 locks in the demodb database:
ema_check_ingres_lock -s $II_SYSTEM -d demodb –test 5 -W 4000 -C 5000
Last modified date: 01/30/2023