Neoview Workload Management Services Guide (R2.5)

WMS>ADD RULE EXEC EXECRULE3 (USED_ROWS > EST_USED_ROWS, WARN-LOW);
--- WMS operation complete.
WMS>
This step shows these WMS commands: “ADD RULE CONN Command” (page 178), “ADD
RULE COMP Command” (page 174), and “ADD RULE EXEC Command” (page 182). You
can also perform this step using the Neoview Performance Analyzer or the Neoview Query
Viewer (that is, the NPA Tools). For more information, see Chapter 5 (page 69).
3. Associate the rules with the service.
• Associate the connection rules with the service:
WMS>ALTER WMS CONN ( (CONNRULENCI1, CONNRULENCI2) SERVICE1 );
--- WMS operation complete.
WMS>
• Associate the compilation rules with the service:
WMS>ALTER SERVICE SERVICE1 COMP (COMPRULE1, COMPRULE2, COMPRULE3);
--- WMS operation complete.
WMS>
• Associate the execution rules with the service:
WMS>ALTER SERVICE SERVICE1 EXEC (EXECRULE1, EXECRULE2, EXECRULE3);
--- WMS operation complete.
WMS>
This step shows these WMS commands: “ALTER WMS CONN Command” (page 206),
“ALTER SERVICE COMP Command” (page 202), or “ALTER SERVICE EXEC Command”
(page 203). You can also perform this step using the Neoview Performance Analyzer or the
Neoview Query Viewer (that is, the NPA Tools). For more information, see Chapter 5
(page 69).
4. Submit a query to the Neoview platform:
WMS>mode sql
SQL>show role
ROLE ROLE.DBA
SQL>SELECT COUNT(*)
+> FROM (SELECT * FROM NEO.HP_METRICS.QUERY_STATS_VW1 VA
+> , NEO.HP_METRICS.QUERY_STATS_VW1 VB
+> , NEO.HP_METRICS.QUERY_STATS_VW1 VC
+> , NEO.HP_METRICS.QUERY_STATS_VW1 VD
+> WHERE VA.SEGMENT_NAME = VB.SEGMENT_NAME
+> and VB.SEGMENT_NAME = VC.SEGMENT_NAME
+> and VC.SEGMENT_NAME = VD.SEGMENT_NAME
+> FOR READ UNCOMMITTED ACCESS)
+> AS AA;
_
32 Introduction