Neoview Workload Management Services Guide (R2.4)

Table B-2 Comparison of WMS Functionality Between Neoview Release 2.3 and 2.4 (continued)
WMS Functionality in Neoview Release 2.4WMS Functionality in Neoview Release 2.3
Pre-execution control:
New WMS commands allow you to apply a larger set of
rules based on compiler estimates for the decision-making
process. These additional rules can be applied to services
and may include optional actions.
WMS decided how to handle an incoming
query—whether to allow the query to start executing, put
the query in a waiting queue, or reject the query—by
comparing periodic snapshots of available system
resources (CPU and memory) to the MAX_CPU_BUSY
and MAX_MEM_USAGE thresholds. After the
comparison, WMS allowed queries to either execute or
be queued for later execution.
Execution control:
New WMS commands allow you to apply a larger set of
rules based on runtime statistics to the decision-making
process. These additional rules can be applied to services
and may include optional actions.
WMS periodically checked an executing query's elapsed
time to determine if the query had been running longer
than the value specified in the EXEC_TIMEOUT threshold.
If the query had been running longer than the
EXEC_TIMEOUT threshold, WMS cancelled the query.
If you did not set EXEC_TIMEOUT, WMS allowed the
query to run indefinitely.
WMS also periodically checked a query in the waiting
queue to determine whether the query had been waiting
to execute longer than the value specified by the
WAIT_TIMEOUT threshold. If the query had been waiting
longer than the WAIT_TIMEOUT threshold, WMS
cancelled the query. If you did not set WAIT_TIMEOUT,
WMS allowed the query to remain in the waiting queue
indefinitely.
These WMS commands have additional output columns:
Table B-3 WMS Commands With New Output Columns
New Output ColumnsWMS Command
• MAX_ROWS_FETCHED
• EXEC_TIMEOUT
• WAIT_TIMEOUT
• HOLD_TIMEOUT
• RULE_INTERVAL
For a complete list of returned columns, see Table A-9 (page 123).
INFO WMS
• MAX_ROWS_FETCHED
• HOLD_TIMEOUT
For a complete list of returned INFO SERVICE columns, see Table A-6
(page 119).
For a complete list of returned STATUS SERVICE columns, see Table A-21
(page 143)
INFO SERVICE and STATUS SERVICE
What Changed for This Release 157