Neoview Workload Management Services Guide (R2.3)

compile-time statistics, 43, 44
execution statistics, 47
explain plan, 50
filtering, 44
holding
all queries in a service, 51
all queries in all services, 51
specific query, 52
managing, 52
monitoring, 41
releasing
all sets of queries, 51
specific query, 52
specific set of queries, 51
runtime statistics, 48, 49
SQL text, 50
Query plan, 50
Query text, 50
R
RELEASE command
example of, 51, 52
syntax of, 66
Role, 35
Runtime statistics, 48, 49
S
SERVICE_NAME, 32, 41
SERVICE_PRIORITY, 32, 41
Services
active period, 30
adding, 29
altering, 31
associating with queries, 35
checking the status, 41, 42
comment, 57, 59
configuring, 29
deleting, 32
displaying statistics, 42
holding
all services, 51
specific service, 51
managing, 51
monitoring, 41
naming, 56
priorities, 25, 56
releasing
all services, 51
specific service, 51
SET SERVICE statement, 38
setServiceName method, 37
SQL text, 50
SQLGetConnectAttr function, 37
SQLSetConnectAttr function, 37
STATE, 41
Statistics
compile-time, 43, 44
runtime, 48, 49
STATS_INTERVAL threshold
default value, 34
displaying, 34
setting, 34
syntax of, 61
STATUS command
QUERIES <state> option, example of, 45
QUERIES ALL STATS option, example of, 48
QUERIES ROLE option, example of, 46
QUERIES SERVICE option, example of, 46
QUERY <query-id>, example of, 47
QUERY STATS option, example of, 49
SERVICE <service> option, example of, 42
SERVICE ALL option, example of, 42
SERVICE STATS option, example of, 42
syntax of, 66
WMS option, example of, 41
System resources
configuring, 34
monitoring, 41
System thresholds, altering, 34
T
TEXT, syntax of, 57, 60
Thresholds
service, 57, 59
system, 34, 61
Timeout
executing queries, 30
waiting queries, 30
W
WAIT_TIMEOUT, syntax of, 57, 59
WMS
configuring, 25
description of, 17
how to use, 20
installing, 23
monitoring, 41
WMS commands
list of, 55
using in NCI, 55
Workload, definition of, 17
76 Index