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.
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
• Use the ALTER WMS CONN command a connection rule with a service.
• You cannot add a rule that begins with the reserved “HPS_” prefix or that has the same
name as one of the predefined rules, HPS_MANAGEABILITY1 through 11 and
HPS_TRANSPORTER1.
• Client applications can provide the session name, application name, Neoview role of the
user who is logged on, and the data source name. All of these connection attributes must
be true. Otherwise, the connection rule is ignored.
Examples
• This command adds a connection rule that requires the client session to have a session name
called JOB2486 and have the user logged in as ROLE.USR1:
180 WMS Commands