EVENT_RULES_V

The EVENT_RULES_V view displays information about event rules.
Table 1. The EVENT_RULES_V view
Column name Description Type Length
Event_rule_name The name of the event rule. string 40
Event_rule_description The description of the event rule. string 120
Event_rule_type The type of rule. Possible values are:
F
Filter
Q
Sequence
S
Set
character 1
Is_draft If the event rule definition is currently enabled. Possible values are:
Y
Yes
N
No
character 1
Event_rule_status The status of the event rule. Possible values are:
active
The event rule was activated successfully.
update pending
The event rule whose status is active was updated and must be deployed again.
error during update
An error occurred deploying the active event rule that has been updated.
activation pending
The event rule is waiting to be activated.
error during activation
An error occurred activating the event rule.
deactivation pending
The event rule was set to isDraft and must be deployed again to reflect the new status.
error during deactivation
An error occurred deactivating the event rule.
not active
The event rule is not active.
character 1
Valid_from The starting date from which the event rule is ready to be activated and therefore deployed. date
10
In DB2®
9
In Oracle
Valid_to The last date that the event rule is active and therefore deployed. date
10
In DB2®
9
In Oracle
Start_offset The start time when the event rule becomes active and ready to be deployed. This time is expressed in milliseconds calculated as an offset starting from 00.00 a.m. For example, if the start time is 11:30 a.m. the value is (((11 * 60) + 30) * 60) * 1000 = 41400000. integer 12
End_offset The end time when the event rule is no longer active. This time is expressed in milliseconds calculated as an offset starting from 00.00 a. m. For example, if the end time is 11:30 a. m. the value is (((11 * 60) + 30) * 60) * 1000 = 41400000. integer 12
Time_zone The time zone defined for the event rule that the product uses to deploy the rule. string 40
Time_interval The length of time after which the timeout action is to start. integer 12
Group_attribute_list A comma-separated list of attributes on which are correlated the events defined for the rule. string not defined