HP Neoview Release 2.5 Software - Manual (Page 69)

When adding a rule, you can provide information in the following fields:
Description Field Name
Name of the rule. Up to 24 characters (can be multi-bytes). Rule names
support Neoview character sets. Rule Name
WARN-LOW, NO-WARN (Default) Warn Level
SQL_CMD (SQL String can be multi-bytes), NO-ACTION Rule Action
Select one or more query types to be aggregated:
INSERT (unique or non-unique)
UPDATE (unique or non-unique)
DELETE (unique or non-unique)
SELECT (unique—returning one row of data)
NOTE: The Aggregate group box is enabled for R2.5 and later and is
only applied to connection rules.
Aggregation Type
Frequency in minutes at which the NDCS process updates the WMS
process after aggregation has started. The range is 1 to 5 minutes. The
default is 1 minute. WMS time interval must be less than or equal to
Repository time interval and validated by the WMS server. WMS time interval
Frequency in minutes at which the aggregated statistics are written to the
Repository. The range is 1 to 5 minutes. The default is 1 minute. Repository time interval
Expected execution time of the query, in minutes. If the query's execution
time exceeds this interval, its statistics are written to the Repository without
being aggregated. If the query's execution time is less than or equal to this
interval, its statistics are aggregated. The range is 1 to 5 minutes. The
default is 1 minute. Execution time interval must be less than or equal to
Repository time interval and validated by the WMS server. Execution time interval
AND Expression: Logical
SESSION-Session name set in a ODBC connection
APPL-Application name that you can set in an ODBC/JDBC connection
string
LOGIN-Login role name
DSN-Data source to which the connection is made Expression: Property
Empty (disabled) Expression: Operator
Empty (disabled) Expression: Percentage
SESSION- Value (Up to 24 chars)
APPL- Value (Up to 30 chars and can be multi-bytes)
LOGIN- Value (Up to 17 chars)
DSN- Value (Up to 32 chars and can be multi-bytes) Expression: Value
Can contain up 4 expressions Expression
For detailed information about adding a connection rule, see the Neoview Workload Management
Services Guide.
Example:
ADD RULE CONN RCONN2 (SESSION abc, LOGIN role.dba,
DSN ICASE(mYDsN), APPL ICASE( "Neoview Performance Analyzer"),
WARN-LOW, SQL_CMD "set schema "NEO.MYSCHEMA",
AGGREGATE(QUERY_TYPE(INSERT,UPDATE,DELETE,SELECT)
WMS_INTERVAL 1, REPOS_INTERVAL 1, EXEC_INTERVAL 1) )
COMMENT "6/29/2010 10:12 AM; New rule added by superuser";
After a rule is added, you can view the Rule Details by clicking on the rule in the left pane:
Managing Rules 69