This is the AEC rules database to support the new Rules GUI. The rule content would also be embedded into a database column. The advantages are remote rule authoring, access control, and a single store for all AEC content.
policyname is the primary key. This assumes the rules based on XML files as follows. SAX parser is used to parse the XML files to process the rules.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| name | varchar(50) | not null | Name of rule set for policy watchers |
| classid | varchar(50) | with null | Not used, originally used for unique identification. |
| description | varchar(255) | with null | Description of the rule, what it does |
| launchtype | char(10) | with null | AEC which applciation, who is calling |
| created | integer | with null | Time stamp when the rule set was created |
| createdby | varchar(60) | with null | Author/User who created this rule set |
| modified | integer | with null | Last date that demand policy or description was changed. |
| modifiedby | varchar(60) | with null | User who changed it |
| evalnode | varchar(64) | with null | Zero or more comma delimited nodes. Can also be a station group. Wildcards supported. See opra_msg_msgnode |
| status | char(15) | with null | Active/inactive (if active, it uses a filter for interface) |
| rulecontent | long byte | with null | Blob files containing the embedded XML rule file contents |
Product Name: Unicenter Network and System Management/Advanced EventCorrelation
Table Type: Table