Configuration Parameter | Description of Value to Set |
Enable SNMP Events | True |
Trap Community | Community string to which to send SNMP traps. Default: public. Make sure the SNMP client uses the same value as you set here. |
Trap Host List | A comma-separated list of host names or IPs that will be sent the SNMP v3 trap messages. |
Trap Port | Specify the port for the trap receiver. |
Information to Monitor | Description of Notice | Configuration Steps |
TDV Session | Alert if it reaches a certain threshold | Create a query that uses the /services/databases/system/SYS_SESSIONS published view in the SYSTEM repository. |
TDV Cache | Monitor required for cache success or failure | Define the following traps under Events and Logging > Event Generation > Cache Events configuration parameters: Cache Refresh Start, Cache Refresh Fail, Cache RefreshEnd You can instead define a query that uses the STATUS column from the /services/databases/system/SYS_CACHES view to capture the information and write it to the log files or SNMP monitor program. |
Data Sources | Determine whether the data source is up and running or not | Define the following traps under Events and Logging > Event Generation > Data Source Events: Data Source Up, Data Source Down You can instead define a query that uses the STATUS column in /services/databases/system/SYS_DATASOURCES to capture the information and write it to the log files or SNMP monitor program. |
Trigger | Alert on failure | Define the following traps under Events and Logging > Event Generation > Trigger Events: Trigger Start, Trigger Fail, Trigger End You can instead define a query that uses the STATUS column in /services/databases/system/SYS_TRIGGERS to capture the information and write it to the log files or SNMP monitor program. |
Long-running queries | Alert if it reaches a certain threshold | Define the threshold value for the duration which is considered as long in Events and Logging > Event Generation > Request Events: Request Run Time This value must be in minutes and controls the period of time after which a request is considered to be long-running, resulting in the generation of a RequestRunForTooLong event. |
Number of waiting requests | Alert if it reaches a certain threshold | 1. Add “SNMP” to the value of the Events and Logging > Event Generation > Request Events > Request Wait Queue Threshold Passed configuration parameter. 2. Set the Server > Runtime Processing Information > Wait Queue > Wait Queue Threshold configuration parameter. This is the number of requests in the wait queue at which a wait queue threshold event is triggered. This generates a csRequestWaitQueueThresholdPass trap. |