Neoview Workload Management Services Guide (R2.5)

Example of How to Use WMS

This example demonstrates Tasks 3 through 5, which are mentioned in “How to Start Using

WMS” (page 30).

1. Configure a WMS service with thresholds that limit the system resources that queries allowed

to consume and determine when queries are allowed to run:

Welcome to the HP Neoview Command Interface 2.5

Connected to Data Source: TDM_Default_DataSource

SQL>mode wms

WMS>ADD SERVICE SERVICE1

+> PRIORITY HIGH,

+> MAX_CPU_BUSY 100,

+> MAX_MEM_USAGE 100,

+> ACTIVE 00:00 TO 24:00,

+> EXEC_TIMEOUT 120,

+> WAIT_TIMEOUT 720,

+> HOLD_TIMEOUT 1440,

+> COMMENT "Created by DBA on 5/14/2010";

--- WMS operation complete.

WMS>

This step shows the WMS command, “ADD SERVICE Command” (page 185). 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 4 (page 47).

2. Configure connection, compilation, and execution rules for the service.

• Add connection rules:

WMS>ADD RULE CONN CONNRULENCI1 (APPL ICASE(NCI), LOGIN ICASE(ROLE.DBA));

--- WMS operation complete.

WMS>ADD RULE CONN CONNRULENCI2 (APPL ICASE(NCI), LOGIN ICASE(SUPER.SERVICES));

--- WMS operation complete.

WMS>

• Add compilation rules:

WMS>ADD RULE COMP COMPRULE1 (EST_USED_ROWS > 50000, WARN-HIGH, REJECT);

--- WMS operation complete.

WMS>ADD RULE COMP COMPRULE2 (EST_USED_ROWS > 25000, WARN-MEDIUM, HOLD);

--- WMS operation complete.

WMS>ADD RULE COMP COMPRULE3 (EST_USED_ROWS > 1000, WARN-LOW);

--- WMS operation complete.

WMS>

• Add execution rules:

WMS>ADD RULE EXEC EXECRULE1 (USED_ROWS >= 10000, WARN-HIGH, CANCEL);

--- WMS operation complete.

WMS>ADD RULE EXEC EXECRULE2 (USED_ROWS >= 1000, WARN-MEDIUM);

--- WMS operation complete.

How to Start Using WMS 31