Neoview Workload Management Services Guide (R2.3)

The time period during which the service is active and can execute queries. The
default is 00:00 through 23:59.
ACTIVE_TIME
Displays PLAN to indicate that the query execution plans are collected for display
or NO_PLAN to indicate that no plans are collected for display
SQL_PLAN
Displays TEXT to indicate that the SQL syntax of executing queries is collected
for display or NO_TEXT to indicate that no SQL text is collected for display
SQL_TEXT
The number of minutes a query is allowed to remain in the executing state before
WMS cancels the query. The default is zero, meaning no timeout.
EXEC_TIMEOUT
The number of minutes a query is allowed to remain in the waiting state before
WMS cancels the query. The default is zero, meaning no timeout.
WAIT_TIMEOUT
A service is in the HOLD state if the current time is outside the active time range of the service
or if a user holds the service by issuing a HOLD command. A service is in the ACTIVE state if
the current time is within the active range of the service or if a user releases the service from the
HOLD state. For more information, see the ACTIVE_TIME threshold in “Adding a Service”
(page 29), or see “Holding a Service” (page 51) or “Releasing a Service” (page 51).
For example, this STATUS SERVICE ALL command displays information about the state and
thresholds of all services being managed by WMS:
NS%status service all;
SERVICE_NAME STATE
SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE ACTIVE_TIME SQL_PLAN SQL_TEXT EXEC_TIMEOUT WAIT_TIMEOUT
------------------------------------------------------------------------------------------------ --------
---------------- ------------ ------------- ------------------- -------- -------- ------------ ------------
SERVICE1 ACTIVE HIGH
0 0 FROM 00:00 TO 23:59 PLAN TEXT 0 0
DATALOADING HOLD
MEDIUM-HIGH 0 0 FROM 22:00 TO 23:59 NO_PLAN NO_TEXT 0 0
SERVICE2 ACTIVE MEDIUM
0 0 FROM 00:00 TO 23:59 PLAN TEXT 0 0
SALESQUERIES HOLD
LOW-MEDIUM 0 0 FROM 08:00 TO 10:00 NO_PLAN NO_TEXT 0 0
HP_DEFAULT_SERVICE ACTIVE LOW
0 89 FROM 00:00 TO 23:59 PLAN TEXT 0 0
SERVICE3 ACTIVE LOW
0 0 FROM 00:00 TO 23:59 PLAN TEXT 0 0
--- WMS operation complete.
NS%
For example, this STATUS SERVICE <service> command displays information about the state
and thresholds of a specified service being managed by WMS:
NS%status service hp_default_service;
SERVICE_NAME STATE
SERVICE_PRIORITY MAX_CPU_BUSY MAX_MEM_USAGE ACTIVE_TIME SQL_PLAN SQL_TEXT EXEC_TIMEOUT WAIT_TIMEOUT
------------------------------------------------------------------------------------------------ --------
---------------- ------------ ------------- ------------------- -------- -------- ------------ ------------
HP_DEFAULT_SERVICE ACTIVE LOW
0 89 FROM 00:00 TO 23:59 PLAN TEXT 0 0
--- WMS operation complete.
NS%
For example, this STATUS SERVICE STATS command displays statistics for all the services on
the system:
NS%status service stats;
SEGMENT SERVICE_NAME
STATE EXECUTING WAITING HOLDING
----------- ------------------------------------------------------------------------------------------------
----------- ----------- ----------- -----------
1 SERVICE1
ACTIVE 0 0 0
2 SERVICE1
ACTIVE 1 0 0
3 SERVICE1
ACTIVE 1 0 0
1 DATALOADING
HOLD 0 0 0
2 DATALOADING
HOLD 0 0 0
42 Managing Workload in WMS