Products documentation

Book Creator

Add this page to your book

Book Creator

Remove this page from your book

This monitor will look for locks on table objects and generate alarms if too many locks are waiting since a given time

Use the surveillance table to adjust the monitoring settings: - Wait time - Max number of locks. You can filter on client and table name.

Parameter	Description
Active	Use this field to activate or deactivate a line of configuration.
Client	A filter on the client.
Table Name	The name of the table to filter. You can use regular expressions, or * to match any object.
Max wait time (min)	The threshold for the maximum time a lock can be waiting, in minutes.
Max locks	The maximum number of lock waiting since more that the configured waiting time.
Aggregate	If checked, the alarm will indicate how many matching locks are waiting since too long time. If not checked, it will send an alarm per table having too many waiting locks.
Severity	The default level of severity of the alarm generated by this line of surveillance.
Auto clear	If checked, the alarm will be cleared as soon as the alarm condition is not met anymore.
Alarm tag	This field allows to add custom text within the alarm message. %MSG% variable will contain the actual generated message and can be used such as: “my_prefix %MSG% my_suffix”. By default, tag will be used as prefix.
Alarm	If checked, this line of surveillance will be used for alarm generation.
Metric	If checked, this line of surveillance will be used for metric generation.
Report	If checked, this line of surveillance will used for showing threshold and severity in the daily report

Active	Client	Table Name	Max wait time (min)	Max locks	Aggregate	Severity	Auto clear	Alarm tag	Alarm	Metric	Report
true	*	*	600	10	false	MAJOR	true		true	false	false

Effect : Sends a MAJOR alarm for each table having more than 10 waiting locks since more than 600 minutes.

Active	Client	Table Name	Max wait time (min)	Max locks	Aggregate	Severity	Auto clear	Alarm tag	Alarm	Metric	Report
true	800	TBC.*	480	1	true	WARNING	true		true	false	false

Effect : Sends a WARNING alarm if, in client 800, at least 1 table with name starting with TBC has a lock since more than 480 minutes

metricId	metricUnit	metricTarget	metricDescription
LONG_EXCLUSIVE_LOCKS_NUMBER	Seconds	TABLE	The number of exclusive locks waiting on the table