Neoview Workload Management Services Guide (R2.5)

Table of Contents
About This Document.......................................................................................................13
Intended Audience................................................................................................................................13
New and Changed Information in This Edition...................................................................................13
Document Organization.......................................................................................................................14
Notation Conventions...........................................................................................................................15
General Syntax Notation.................................................................................................................15
Related Documentation........................................................................................................................17
Neoview Customer Library.............................................................................................................17
Publishing History................................................................................................................................18
HP Encourages Your Comments..........................................................................................................19
1 Introduction...................................................................................................................21
Purpose and Benefits of WMS..............................................................................................................21
How WMS Manages Queries................................................................................................................21
How WMS Applies Rules and Services................................................................................................22
Connection Phase............................................................................................................................22
Compilation Phase...........................................................................................................................24
Execution Phase...............................................................................................................................26
Query Statistics Aggregation................................................................................................................27
Benefits of Query Statistics Aggregation.........................................................................................27
Behavior Without Aggregation.......................................................................................................28
Behavior With Aggregation.............................................................................................................28
How Query Statistics Aggregation Works......................................................................................29
How to Start Using WMS.....................................................................................................................30
Example of How to Use WMS.........................................................................................................31
2 Getting Started.............................................................................................................35
Installing and Starting WMS on the Neoview Platform.......................................................................35
Using the Neoview Performance Analysis Tools.................................................................................35
Launching the Neoview Performance Analyzer.............................................................................36
Launching the Neoview Query Viewer...........................................................................................36
Connecting to the Neoview Platform..............................................................................................37
Set the Connection Attributes....................................................................................................37
Using the Neoview Command Interface (NCI)....................................................................................38
How to Execute WMS Commands in NCI......................................................................................38
Using the HP Database Manager (HPDM)...........................................................................................39
Assign Administrators..........................................................................................................................39
Display the Admin Roles Summary................................................................................................39
Add an Admin Role.........................................................................................................................40
Delete an Admin Role......................................................................................................................42
3 Understanding Your Workload Environment.............................................................43
Identifying Query Workloads in an Enterprise Data Warehouse.........................................................43
Defining the Query Workloads.............................................................................................................43
Analyzing and Refining the Query Workload Configuration..............................................................44
4 Configuring Services....................................................................................................47
What Are Services?...............................................................................................................................47
Table of Contents 3