Neoview Workload Management Services Guide (R2.4)

Deleting an Execution Rule.............................................................................................................64
Associating Execution Rules With a Service...................................................................................64
Displaying the Execution Rules Associated With a Service............................................................64
Displaying the Services Associated With an Execution Rule..........................................................65
Displaying the Definitions of All Rules................................................................................................66
5 Managing Workload..................................................................................................69
Monitoring System Resources..............................................................................................................69
Monitoring Queries...............................................................................................................................69
Displaying the Aggregated Statistics of Query Workloads............................................................69
Displaying Aggregated Statistics for Services...........................................................................69
Displaying Aggregated Statitics for Segments..........................................................................70
Resetting the Aggregated Statistics Counter.............................................................................70
Displaying the Total Number of Executing Queries.......................................................................71
Displaying the Compile-Time Statistics of Queries........................................................................71
Displaying the Runtime Statistics of Queries..................................................................................72
Displaying the Explain Plan of a Query..........................................................................................74
Displaying the SQL Text of a Query................................................................................................74
Displaying Warning Information..........................................................................................................75
Managing Services................................................................................................................................76
Holding Services..............................................................................................................................76
Releasing Services............................................................................................................................76
Stopping a Service...........................................................................................................................77
Starting a Service.............................................................................................................................77
Managing Queries.................................................................................................................................78
Holding a Query..............................................................................................................................78
Releasing a Query............................................................................................................................78
Cancelling a Query..........................................................................................................................79
A WMS Commands........................................................................................................81
ADD RULE COMP Command.............................................................................................................83
Syntax..............................................................................................................................................83
Considerations.................................................................................................................................85
Examples..........................................................................................................................................85
ADD RULE CONN Command.............................................................................................................86
Syntax..............................................................................................................................................86
Considerations.................................................................................................................................87
Examples..........................................................................................................................................87
ADD RULE EXEC Command...............................................................................................................88
Syntax..............................................................................................................................................88
Considerations.................................................................................................................................89
Examples..........................................................................................................................................90
ADD SERVICE Command....................................................................................................................91
Syntax..............................................................................................................................................91
Considerations.................................................................................................................................93
Examples..........................................................................................................................................93
ALTER RULE COMP Command..........................................................................................................94
Syntax..............................................................................................................................................94
Considerations.................................................................................................................................96
Examples..........................................................................................................................................96
ALTER RULE CONN Command..........................................................................................................97
Syntax..............................................................................................................................................97
Considerations.................................................................................................................................98
Table of Contents 5