Neoview Workload Management Services Guide (R2.4)
For example, this ADD SERVICE command defines a service that sets the maximum number of
rows to 2000:
ADD SERVICE service3
PRIORITY LOW,
MAX_CPU_BUSY 55,
MAX_MEM_USAGE 40,
MAX_ROWS_FETCHED 2000,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/09";
If you set a MAX_ROWS_FETCHED limit for the service, the NDCS server considers this limit
when fetching rows for queries associated with the service. If the number of rows fetched for a
query exceeds the MAX_ROWS_FETCHED limit, the NDCS server returns part of the data from
the query and this error message to the client application:
SQL error:The limit for maximum rows to be returned for a query, as set
by the administrator, was exceeded. [yyyy-mm-ddhh:mm:ss]
The hh:mm:ss value is the timestamp of when the error message occurred.
Setting the Output Options of the Service
You can specify one or both of these output options for a service:
• PLAN option
• TEXT option
Specify the PLAN option to collect the execution plans of queries executing in the service. Client
tools, such as NCI and the Neoview Manageability Repository, can then use and display this
data. If you do not specify PLAN, which is equivalent to you specifying NO_PLAN, WMS does
not collect any plans for the queries associated with the service.
Specify the TEXT option to collect the SQL syntax of queries executing in the service. Client tools,
such as NCI and the Neoview Manageability Repository, can then use and display this data. If
you do not specify TEXT, which is equivalent to you specifying NO_TEXT, WMS does not collect
any SQL text for the queries associated with the service.
For example, this ADD SERVICE command defines a service that collects query execution plans
and SQL text for the queries associated with the service:
ADD SERVICE service3
PRIORITY LOW,
MAX_CPU_BUSY 55,
MAX_MEM_USAGE 40,
MAX_ROWS_FETCHED 2000,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/09";
Adding a Comment for the Service
You can optionally provide a comment to describe the service that you are creating. You must
delimit the comment in double quotes. For example, this ADD SERVICE command has a comment
that identifies who created the service and when it was created:
ADD SERVICE service3
PRIORITY LOW,
MAX_CPU_BUSY 55,
MAX_MEM_USAGE 40,
MAX_ROWS_FETCHED 2000,
PLAN, TEXT,
COMMENT "Created by DBA on 5/14/09";
For details about the syntax, see “ADD SERVICE Command” (page 91).
34 Configuring Services