Neoview Workload Management Services Guide (R2.4)

EST_CARDINALITY, 84, 95
EST_TOTAL_MEMORY, 84, 95
EST_TOTAL_TIME, 84, 95
EST_USED_ROWS, 84, 95
NUM_JOINS, 84, 95
SCAN_SIZE, 84, 95
UPDATE_STATS_WARNING, 84, 95
Expressions, connection rule
APPL, 87, 98
DSN, 87, 98
LOGIN, 86, 97
SESSION, 86, 97
Expressions, execution rule
ACCESSED_ROWS, 89, 100
ELAPSED_TIME, 89, 100
EST_ACCESSED_ROWS, 89, 100
EST_TOTAL_MEMORY, 89, 100
EST_USED_ROWS, 89, 100
TOTAL_MEM_ALLOC, 89, 100
USED_ROWS, 89, 100
G
GET SERVICE statement, 37
H
HOLD command
example of, 78
syntax of, 113
HOLD SERVICE ALL command
example of, 76
HOLD SERVICE command
example of, 76
HOLD_TIMEOUT
syntax of, 92, 102, 106
HP_DEFAULT_SERVICE
description of, 27
mapping to, 18
I
INFO RULE command
syntax of, 115
INFO RULE COMP command
syntax of, 116
INFO RULE CONN command
syntax of, 117
INFO RULE EXEC command
syntax of, 118
INFO SERVICE command
syntax of, 119
INFO SERVICE COMP command
syntax of, 121
INFO SERVICE EXEC command
syntax of, 122
INFO WMS command
example of, 29
syntax of, 123, 124
Information
changed, 156
new, 155
L
LOGIN
syntax of, 86, 97
M
MAX_CPU_BUSY
syntax of, 106
MAX_CPU_BUSY threshold
syntax of, 92, 102
MAX_MEM_USAGE
syntax of, 106
MAX_MEM_USAGE threshold
syntax of, 92, 102
MAX_ROWS_FETCHED
syntax of, 106
MAX_ROWS_FETCHED threshold
syntax of, 92, 102
MODE NS command, 25
N
NCI
installing, 25
NS mode, 25
using WMS commands, 25
NDCS server, 17
Neoview Database Connectivity Service (NDCS), 17
Neoview Workload Management Services (WMS),
description of, 17
New information, 155
NO_PLAN, syntax of, 92, 102
NO_TEXT, syntax of, 93, 103
NS mode, 25
NUM_JOINS
syntax of, 84, 95
P
PLAN, syntax of, 92, 102
Q
Queries
cancelling, 79
checking the status of all queries, 71
checking the status of queries in a service, 71
compile-time statistics, 71
execution statistics, 71
explain plan, 74
handling incoming, 20
holding
all queries in a service, 76
all queries in all services, 76
specific query, 78
managing, 78
monitoring, 69
releasing
all sets of queries, 76
specific query, 78
specific set of queries, 76
runtime statistics, 72
SQL text, 74
160 Index