In a rule of thumb, you specify the tables, report blocks, and columns that you want to analyze for a specific counter category.
You also define the analysis rules, set the thresholds, and provide tuning recommendations.
- Click Rules of Thumb for the cluster in
the folders pane of the Performance Warehouse window and then
click .
The General page of the Rule-of-Thumb Properties window is displayed.
The Author, Creation date and time, and Modification date and time fields are filled when you click OK. The Author field will contain your DB2® user ID.
- Specify a unique name for the rule of thumb in the Name field.
- If this is the first rule of thumb in the cluster, select
the counter category for the rules of thumb that you want to add in
the Type list.
You can define rules of thumb for Accounting and Statistics.
Important: The counter category you select here determines the category for the entire cluster. Therefore, this selection is not available for the second and subsequent rules of thumb in the cluster.
- You can type a description for the rule of thumb in the Description field. This is optional.
- Click the Definition tab.
On the Definition page you can select the:
- Tables
- Report blocks
- Columns that you want to analyze and for which you want to set rules, threshold values, and tuning recommendations.
- Select a report block or a table. Your selection determines the content of the Columns box.
- Fill the Filter expression and Additional
columns boxes by clicking a column in the Columns box
and then clicking the appropriate Add (
)
button. The entry appearing in these boxes consists of the table and
column names. - If you add several columns to the VALUE expression box, you must use operators to combine the columns into expressions. Simple arithmetic expressions are allowed that contain the operators (, ), +, —, /, *. The result of the arithmetic expression is run against the values that you specify under WARNING and PROBLEM thresholds.
- If you want to include the values of columns that are not part of the arithmetic expression in the analysis result, add these columns to the Additional columns box.
- The SQL query generated from the specifications for this and all other rules of thumb in the cluster and for the rules-of-thumb cluster itself must not exceed 32 KB.
- Make your selections and fill in the various fields.
- Click OK to save the new rule of thumb
and to return to the Performance Warehouse window.
The new rule of thumb appears in the contents pane of the Performance Warehouse window.