Neoview Workload Management Services Guide (R2.3)

Table of Contents
About This Document.......................................................................................................11
Intended Audience................................................................................................................................11
New and Changed Information in This Edition...................................................................................11
Document Organization.......................................................................................................................11
Notation Conventions...........................................................................................................................11
General Syntax Notation.................................................................................................................11
Related Documentation........................................................................................................................13
Neoview Customer Library.............................................................................................................13
Publishing History................................................................................................................................15
HP Encourages Your Comments..........................................................................................................15
1 Introducing Neoview Workload Management Services (WMS)............................17
How WMS Works.................................................................................................................................17
How to Use WMS.................................................................................................................................20
Setting Up Services and Thresholds in WMS..................................................................................20
Setting System Thresholds in WMS................................................................................................20
Monitoring and Managing Queries in WMS...................................................................................20
2 Getting Started.............................................................................................................23
Installing and Starting WMS on the Neoview Platform.......................................................................23
Installing the Neoview Command Interface (NCI)..............................................................................23
3 Configuring WMS........................................................................................................25
How Services Work...............................................................................................................................25
What Are Services?..........................................................................................................................25
How Service Priorities and System Resource Thresholds Work.....................................................25
Service Priority Weights.............................................................................................................26
Calculation of Expected Query Execution Percentage...............................................................26
Example 1: How Service Priorities and System Resource Thresholds Work.............................26
Example 2: How Service Priorities and System Resource Thresholds Work.............................28
Effect of Service-Level Thresholds..................................................................................................29
Configuring User-Defined Services......................................................................................................29
Adding a Service..............................................................................................................................29
Naming the Service....................................................................................................................29
Setting the Priority of the Service...............................................................................................29
Setting the System Resource Thresholds of the Service.............................................................30
Setting the Active Time of the Service.......................................................................................30
Setting the Execution and Waiting Timeouts of the Service......................................................30
Setting the Output Options of the Service.................................................................................30
Adding a Comment for the Service............................................................................................31
Example of Adding a Service.....................................................................................................31
Altering a Service.............................................................................................................................31
How an Altered Service Affects Queries...................................................................................31
Deleting a Service............................................................................................................................32
Displaying Information About the Service Definitions..................................................................32
Configuring the WMS System Configuration......................................................................................33
Altering the WMS System Configuration.......................................................................................34
Displaying the WMS System Configuration...................................................................................34
Table of Contents 3