After shifts and thresholds have been created, you are ready to build rules. The Add Rule File feature ensures that you only create rules for the active shifts within the appropriate time and date ranges. Ultimately when governing a data request with data rules, you are prevented from running a request that exceeds parameter values that were created when you set these up. In addition to selecting date ranges for the use of monitored data, you are able to turn Governing on and off and apply Business Rule Files to compiled rule files.
When building compiled rule files with monitored data, the Rule Parameters are compared with the resources used by already monitored requests. This comparison creates rules at runtime that, when governing is activated, cancel requests judged to exceed those Rule Parameter thresholds.
Note: When building a custom only rule, rule parameters may be used to test for the name in effect. The threshold values are not pertinent in the business rule execution.
For more information on Business Rule Files, see Creating Business Rules.
Before Resource Governor can govern queries, you must first generate the rules that it uses to determine whether to allow a request to execute. You can then set default values for some properties to be used when you add rule files. These properties can be overridden for individual Rule Files as necessary.
Note: This step is available if you have previously added a data source from that application directory to be monitored.
The Add Rule File window opens, as shown in the following image.
Note: If at any time in this process you decide you want to cancel the changes you have made, click the Refresh button, the back button, the Cancel button, or right-click the data source to revert to the settings before the last save.
You can modify the Rule File for a data source by updating its properties or by changing the rule parameter associated with it.
The Rule File window opens.
Note: If at any time in this process you decide you want to cancel the changes you have made, click the Refresh button, the back button, the Cancel button, or right-click the data source to revert to the settings before the last save.
The View Rule Properties window opens.
To view the rule files for a particular data source, and to determine which rule is active:
The Rule Files window opens as shown in the following image.
The View Rule Properties window opens for the selected rule.
If for any reason the rules you are using for one or more of your databases are no longer appropriate, you need to re-create the Rule File. This can happen under one of the following circumstances:
You only recreate rules for data sources that have Rule Files assigned to them.
If the rule type is set to Data or Both, the rule file or knowledge base will be re-created based on the shifts and thresholds that are in effect at this time.
Note: To cancel the delete request, click Cancel in the dialog box.
The Add Rule Files function is used to create a complete program or rule file or knowledge base that contains the rules, thresholds, and active shifts for a data source. This program (referred to as a Rule File throughout this documentation) is what Resource Governor runs during query or report execution to determine whether the request against the data source should run.
The Add Rule File window has the following fields/options:
Is the name of the rule file or knowledge base that Resource Governor executes to determine whether the request can run.
A Rule File that contains only business rules can be associated with multiple data sources, unless those business rules reference specific table names or column names unique to a data source and are not meant to be general.
Is the type of rule file built for the data source.
Is a rule file based on the monitored data for the data source.
Is a rule file based on Business Rules built using the Business Rules Language.
Applies both Data Rules and Business Rules to the data source.
Note: When building a custom only rule, rule parameters are not used.
The name of the file containing business rules that are included when the rule file or knowledge base is built.
Note: If at any time in this process you decide you want to cancel the changes you have made, click the Refresh button on the toolbar to revert to the settings before the last save.
Click Add to save the changes and create the rule file.
WebFOCUS |