Neoview Workload Management Services Guide (R2.4)

Index
A
ACCESSED_ROWS
syntax of, 89, 100
Active period, setting start and end times, 32
ACTIVE threshold
syntax of, 92, 102
ACTIVE_TIME
setting the value, 32
ADD RULE COMP command
syntax of, 83
ADD RULE CONN command
syntax of, 86
ADD RULE EXEC command
syntax of, 88
ADD SERVICE command
example of, 29
syntax of, 91
Administrator's role, 23
ALTER RULE COMP command
syntax of, 94
ALTER RULE CONN command
syntax of, 97
ALTER RULE EXEC command
syntax of, 99
ALTER SERVICE command, syntax of, 101
ALTER SERVICE COMP command, syntax of, 104
ALTER SERVICE EXEC command, syntax of, 105
ALTER WMS command
example of, 28
syntax of, 106
ALTER WMS CONN command
syntax of, 108
ALTER WMS RESET STATS command
syntax of, 109
APPL
syntax of, 87, 98
C
CANCEL command
example of, 79
syntax of, 110
Changed information, 156
Compilation rules
action, 85, 95
comment, 85
definition of, 51
expressions, 84, 95
naming, 83, 94
numeric value, 84, 95
rule operator, 84, 95
specifier list, 84, 94
specifier operator, 83, 94
sql-string, 85, 96
warning level, 84, 95
Compile-time statistics, examples of, 71
Configuration, WMS, 27
Configuring rules, 39
Connection rules
action, 87, 98
comment, 87, 96, 98
definition of, 40
expressions, 86, 97
naming, 86, 97, 108
specifier list, 86, 97
specifier operator, 108
sql-string, 87, 98
warning level, 87, 98
CROSS_PRODUCT
syntax of, 84, 95
D
DELETE RULE command, syntax of, 111
DELETE SERVICE command, syntax of, 112
Documents, related information, 13
DSN
syntax of, 87, 98
E
ELAPSED_TIME
syntax of, 89, 100
EST_ACCESSED_ROWS
syntax of, 84, 89, 95, 100
EST_CARDINALITY
syntax of, 84, 95
EST_TOTAL_MEMORY
syntax of, 84, 89, 95, 100
EST_TOTAL_TIME
syntax of, 84, 95
EST_USED_ROWS
syntax of, 84, 89, 95, 100
EXEC_TIMEOUT
syntax of, 92, 102, 106
Executing queries
monitoring, 71
Execution rules
action, 89, 100
comment, 89, 100
definition of, 59
expressions, 89, 100
naming, 88, 99
numeric value, 89, 100
percentage, 89, 100
rule operator, 89, 100
specifier list, 88, 99
specifier operator, 88, 99
warning level, 89, 100
Execution statistics, 71
Explain plan, 74
Expressions, compilation rule
CROSS_PRODUCT, 84, 95
EST_ACCESSED_ROWS, 84, 95
159