Neoview Workload Management Services Guide (R2.5)

Index
A
ACCESSED_ROWS, syntax of, 183, 197
Active period, setting start and end times, 49
ACTIVE threshold, syntax of, 186, 200
ACTIVE_TIME
description of, 219, 245
setting the value, 49
ADD ADMIN command, 173
ADD RULE COMP command, 174
ADD RULE CONN command, 178
ADD RULE EXEC command, 182
ADD SERVICE command, 185
Admin role (see Administrator role)
Administrator role
adding, 40
deleting, 42
description of, 39
displaying, 39
Aggregation, query statistics, 27
ALTER RULE COMP command, 189
ALTER RULE CONN command, 192
ALTER RULE EXEC command, 196
ALTER SERVICE command, 199
ALTER SERVICE COMP command, 202
ALTER SERVICE EXEC command, 203
ALTER WMS command, 204
ALTER WMS CONN command, 206
ALTER WMS RESET STATS command, 207
APPL, syntax of, 179, 193
C
CANCEL command, 208
Cancellation, queries, 145
Changed information, 13
Compilation rules
action, 176, 190
adding, 87
altering, 94
associating with a service, 114
comment, 176
definition of, 84
deleting, 96
displaying, 86
expressions, 175, 190
naming, 174, 189
numeric value, 175, 190
rule operator, 175, 190
specifier list, 175, 189
specifier operator, 174, 189
sql-string, 176, 191
warning level, 175, 190
Configuration, WMS, 47
Connection attributes, 37
Connection rules
action, 179, 193
adding, 74
altering, 80
associating with a service, 114
attributes, 72
comment, 180, 191, 194
definition of, 70
deleting, 82
displaying, 73
expressions, 179, 193
naming, 178, 192, 206
specifier list, 178, 192
specifier operator, 206
sql-string, 179, 193
warning level, 179, 193
CPU usage, displaying, 255
CPU_TIME, syntax of, 183, 197
CROSS_PRODUCT, syntax of, 175, 190
D
DELETE ADMIN command, 209
DELETE RULE command, 210
DELETE SERVICE command, 211
Documents, related information, 17
DSN, syntax of, 179, 193
E
ELAPSED_TIME, syntax of, 183, 197
EST_ACCESSED_ROWS, syntax of
compilation rule expression, 175, 190
execution rule expression, 183, 197
EST_CARDINALITY, syntax of, 175, 190
EST_TOTAL_MEMORY, syntax of
compilation rule expression, 175, 190
execution rule expression, 183, 197
EST_TOTAL_TIME, syntax of, 175, 190
EST_USED_ROWS, syntax of
compilation rule expression, 175, 190
execution rule expression, 183, 197
EXEC_TIMEOUT, syntax of
service, 186, 200
WMS system, 204
Execution rules
action, 183, 197
adding, 101
altering, 108
associating with a service, 114
comment, 183, 197
definition of, 98
deleting, 110
displaying, 100
expressions, 183, 197
naming, 182, 196
numeric value, 183, 197
percentage, 183, 197
rule operator, 183, 197
specifier list, 182, 196
267