Neoview Workload Management Services Guide (R2.3)

1 Introducing Neoview Workload Management Services
(WMS)
The Neoview Workload Management Services (WMS) feature provides the infrastructure to help
you manage system and service-level resources for executing queries on a Neoview platform.
You can configure service levels in WMS to prioritize and set rules for groups of queries (that
is, query workloads) executing on the Neoview platform. You can then monitor queries in service
levels, identify problematic queries, hold queries to free resources, and cancel runaway queries
to prevent them from monopolizing system resources.
WMS supports management tools, such as the Neoview Command Interface (NCI) for executing
WMS commands and the Neoview Management Dashboard Client for monitoring active queries
in a graphical user interface. Those management tools enable you to monitor and manage queries
in WMS from a client workstation.
How WMS Works
WMS acts as a query manager for Neoview Database Connectivity Service (NDCS) server
instances, obtaining information from the requesting NDCS servers and using that information
to manage query workload. WMS monitors queries that are submitted to NDCS services from
various client applications, such as JDBC or ODBC client applications or the NCI command-line
interface. WMS manages both prepared queries and queries that are executed directly. However,
WMS does not manage singleton queries, which access and return only one row of data. Singleton
queries run directly against the database without being managed by WMS. If a query accesses
multiple rows, even if the query returns only one row of data, such as in the case of SELECT
COUNT(*), WMS manages that query. Figure 1-1 shows how a query is executed through WMS.
The numbers in the diagram show the sequence in which query requests are handled by WMS.
Figure 1-1 Execution of Queries Through WMS
How WMS Works 17