Neoview Workload Management Services Guide (R2.5)

AGGREGATE aggregate-parameter-list
specifies that the NDCS server aggregates the query statistics of a repeating query ID before
writing the statistics to the Repository. For more information, see “Query Statistics
Aggregation” (page 27). If you specify more than one aggregate parameter, you must enclose
the parameters in parentheses. An aggregate parameter can be one of these parameters:
QUERY_TYPE query-type-list
specifies the types of SQL queries that will have their statistics aggregated. If you specify
more than one query type, you must enclose the query types in parentheses. The query
type can be one of these values:
SQL_INSERT_UNIQUE queries, which access only one row of data, and
SQL_INSERT_NON_UNIQUE queries, which access multiple rows of data
• INSERT
SQL_UPDATE_UNIQUE queries, which access only one row of data, and
SQL_UPDATE_NON_UNIQUE queries, which access multiple rows of data
• UPDATE
SQL_DELETE_UNIQUE queries, which access only one row of data, and
SQL_DELETE_NON_UNIQUE queries, which access multiple rows of data
• DELETE
SQL_SELECT_UNIQUE queries, which access only one row of data• SELECT
All of the query types, INSERT, UPDATE, DELETE, and SELECT• ALL
IMPORTANT: If you do not specify a query type, there will be no aggregation of the
query statistics.
REPOS_INTERVAL time-value
specifies the frequency, in minutes, at which the aggregated statistics are written to the
Repository. The range is one to five minutes. The default is one minute.
WMS_INTERVAL time-value
specifies the frequency, in minutes, at which the NDCS server updates the WMS process
with query statistics after the aggregation has started. WMS makes those query statistics
available for real-time monitoring in the Neoview Performance Analyzer (or the Neoview
Query Viewer). The range is one to five minutes. The default is one minute. This value
must be less than or equal to REPOS_INTERVAL.
EXEC_INTERVAL time-value
specifies the 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. This threshold applies to each execution of the query. The range is one
to five minutes. The default is one minute.
NO-ACTION
turns off aggregation by clearing all the query types in the QUERY_TYPE field and setting
the REPOS_INTERVAL and WMS_INTERVAL to default values.
rule-comment
is optional text that you can specify to describe the rule you are creating. comment-string
cannot exceed 256 characters. You must delimit the comment in double quotes.
Considerations
You cannot alter one of the predefined connection rules, HPS_MANAGEABILITY1 through 11
or HPS_TRANSPORTER1.
CAUTION: When altering an attribute of a connection rule, you must also specify any existing
attributes in the ALTER RULE CONN command. Otherwise, the ALTER RULE CONN command
deletes the existing attributes.
194 WMS Commands