Neoview Workload Management Services Guide (R2.3)

3 Configuring WMS
• “How Services Work” (page 25)
• “Configuring User-Defined Services” (page 29)
• “Configuring the WMS System Configuration” (page 33)
How Services Work
• “What Are Services?” (page 25)
• “How Service Priorities and System Resource Thresholds Work” (page 25)
• “Effect of Service-Level Thresholds” (page 29)
What Are Services?
Service levels are a mechanism in WMS to enable you to prioritize query workloads on a Neoview
platform and to partition available workload resources. Each service level in WMS has a priority
and system resource thresholds associated with it. By default, WMS uses the default service,
HP_DEFAULT_SERVICE, to handle incoming queries. You can alter the thresholds of
HP_DEFAULT_SERVICE but cannot delete it from the system.
You can define your own services to partition query workload resources according to your
workload management strategy. You may add up to 16 user-defined services in addition to
HP_DEFAULT_SERVICE on a Neoview platform. User-defined services have these attributes:
The priority of the service relative to other services. The default is MEDIUM.PRIORITY
A percentage from zero to 100 of the total CPU busy allowed for the service. This value
is an average of CPU busy across all segments in the cluster. The default is zero, meaning
that WMS uses the threshold of the WMS system configuration, if set, or the internal
default threshold of 100%.
MAX_CPU_BUSY
A percentage from zero to 100 of memory usage allowed for the service. This value is
an average of memory usage across all segments in the cluster. The default is zero,
meaning that WMS uses the threshold of the WMS system configuration, if set, or the
internal default threshold of 85%.
MAX_MEM_USAGE
The time period during which the service is active and can execute queries. The default
is 00:00 through 23:59.
ACTIVE
The number of minutes a query is allowed to remain in the executing state before WMS
cancels the query. The default is zero, meaning no timeout.
EXEC_TIMEOUT
The number of minutes a query is allowed to remain in the waiting state before WMS
cancels the query. The default is zero, meaning no timeout.
WAIT_TIMEOUT
Either collects the query execution plans or not so that client tools can use and display
that data. The default is NO_PLAN.
PLAN or NO_PLAN
Either collects the query syntax or not so that client tools can use and display that data.
The default is NO_TEXT.
TEXT or NO_TEXT
Text that describes the service. By default, there is no comment.COMMENT
To change the attributes of a user-defined service, use the ALTER SERVICE command. For more
information, see “Altering a Service” (page 31) and the “ALTER SERVICE Command” (page 58).
How Service Priorities and System Resource Thresholds Work
WMS controls the execution of queries based on the service priority. The priority of a service
determines when the queries associated with the service are executed in relation to queries
associated with other services. If a service has a lower priority and if the queries associated with
How Services Work 25