Neoview Workload Management Services Guide (R2.5)

About This Document
This manual describes how to use the Neoview Workload Management Services (WMS) to
perform workload and resource management on a Neoview data warehousing platform. WMS
commands enable you to define services and resource thresholds, monitor system resources,
and manage queries.
Intended Audience
This manual is intended for customers who are using WMS to manage workloads on a Neoview
data warehousing platform. If you are in HP Support, see additional information about WMS in
a chapter of the Neoview Database Support Guide.
New and Changed Information in This Edition
New or Changed InformationChapter or Appendix
Updated the “Related Documentation” (page 17).About This Document
In Release 2.5, you now have the option of enabling query statistics aggregation
for repetitive, short-running queries. The aggregation of query statistics improves
system performance and enables you to use the Neoview Repository data more
effectively. For more information, see “Query Statistics Aggregation” (page 27).
Chapter 1: Introduction
Added information about using the Neoview Performance Analysis Tools to
connect to the Neoview platform and configure and monitor WMS.
Added instructions for assigning administrators in WMS.
Chapter 2: Getting Started
Added guidelines for defining query workloads.Chapter 3: Understanding Your
Workload Environment
Included instructions on how to configure and monitor WMS using the Neoview
Performance Analysis (NPA) Tools. Moved the WMS-command examples to
Appendix A: WMS Commands.
Chapter 4: Configuring Services
Chapter 5: Configuring Rules
Chapter 6: Monitoring and
Managing Workloads
WMS now returns a standard SQL error message, 8007, to the client application
when an executing query is cancelled, and the client application remains
connected to the Neoview platform. For a comparison of Release 2.4 and 2.5
behavior, see Table 1 (page 14).
Chapter 6: Monitoring and
Managing Workloads
Added these WMS commands:
• “ADD ADMIN Command” (page 173)
• “DELETE ADMIN Command” (page 209)
• “START WMS Command” (page 227)
• “STATUS ADMIN Command” (page 228)
• “STATUS WMS DETAIL Command” (page 255)
• “STOP WMS Command” (page 260)
Appendix A: WMS Commands
Updated these WMS commands:
• “ADD RULE COMP Command” (page 174)
• “ADD RULE CONN Command” (page 178)
• “ADD RULE EXEC Command” (page 182)
• “ADD SERVICE Command” (page 185)
• “ALTER RULE COMP Command” (page 189)
• “ALTER RULE CONN Command” (page 192)
• “ALTER RULE EXEC Command” (page 196)
• “ALTER SERVICE Command” (page 199)
• “ALTER SERVICE COMP Command” (page 202)
• “ALTER SERVICE EXEC Command” (page 203)
Intended Audience 13