Neoview Workload Management Services Guide (R2.5)

cancelling, 145
compile-time statistics, 135
execution plan, 134
explain plan, 134
handling incoming, 24
holding
all queries in a service, 151
all queries in all services, 153
specific query, 142
managing, 142
miscellaneous facts, 131
monitoring, 126
per-table statistics, 137
rate-based metrics, 131
releasing
all sets of queries, 156
specific query, 144
specific set of queries, 154
rule warnings, 133
runtime statistics, 136
SQL text, 133
time-based metrics, 130
types managed by WMS, 261
Query plan, 134
Query states, 263
Query statistics aggregation, 27
Query substates, 263
Query text, 133
Query workload types, 43
R
RELEASE command, 225
Rule start interval, 52
RULE_INTERVAL, syntax of, 205
RULE_INTERVAL_QUERY_EXEC_TIME, syntax of, 205
(see also Rule start interval)
Rules
associating with services, 114
compilation, 84
configuring, 69
connection, 70
description of, 69
displaying, 112
execution, 98
monitoring, 126
warnings, 133
Runtime statistics, 136
S
SCAN_SIZE, syntax of, 175, 190
Service level agreement (SLA), 43
Services
active period, 49
adding, 57
altering, 61
comment, 187, 200
configuring, 54
deleting, 63
displaying, 54
holding
all services, 153
specific service, 151
logging status, 149
managing, 151
monitoring, 146
naming, 185
priorities, 48, 185
releasing
all services, 156
specific service, 154
starting, 160
stopping, 157
SESSION, syntax of, 179, 193
SQL text, 133
SQL_DEFAULTS option, 186, 200
START SERVICE command, 226
START WMS command, 227
State
queries, 263
Statistics
aggregation, 27
compile-time, 135
runtime, 136
STATS_INTERVAL, syntax of, 205
STATUS ADMIN command, 228
STATUS QUERIES command, 229
STATUS QUERY command, 238
STATUS RULE command, 240
STATUS RULE COMP command, 242
STATUS RULE CONN command, 243
STATUS RULE EXEC command, 244
STATUS SERVICE command, 245
STATUS SERVICE COMP command, 247
STATUS SERVICE EXEC command, 248
STATUS SERVICE RULE command, 249
STATUS SERVICE SEGMENT STATS command, 250
STATUS WMS command, 252
STATUS WMS CONN command, 254
STATUS WMS DETAIL command, 255
STATUS WMS SEGMENT STATS command, 256
STATUS WMS VERSION command, 258
STOP SERVICE command, 259
STOP WMS command, 260
Substates, queries, 263
System Offender, 39
System resources
configuring, 51
monitoring, 165
SYSTEM service, description of, 47
System thresholds, altering, 51
T
TEXT, syntax of, 187, 201
Thresholds
service, 186, 200
system, 50, 204
TOTAL_MEM_ALLOC, syntax of, 183, 197
269