Neoview Workload Management Services Guide (R2.5)

specifier operator, 182, 196
start interval, 52
warning level, 183, 197
Explain plan, 134
Expressions, compilation rule
CROSS_PRODUCT, 175, 190
EST_ACCESSED_ROWS, 175, 190
EST_CARDINALITY, 175, 190
EST_TOTAL_MEMORY, 175, 190
EST_TOTAL_TIME, 175, 190
EST_USED_ROWS, 175, 190
NUM_JOINS, 175, 190
SCAN_SIZE, 175, 190
UPDATE_STATS_WARNING, 175, 190
Expressions, connection rule
APPL, 179, 193
DSN, 179, 193
LOGIN, 179, 193
SESSION, 179, 193
Expressions, execution rule
ACCESSED_ROWS, 183, 197
CPU_TIME, 183, 197
ELAPSED_TIME, 183, 197
EST_ACCESSED_ROWS, 183, 197
EST_TOTAL_MEMORY, 183, 197
EST_USED_ROWS, 183, 197
TOTAL_MEM_ALLOC, 183, 197
USED_ROWS, 183, 197
G
GET SERVICE statement, 65
H
HOLD command, 212
HOLD_TIMEOUT, syntax of
service, 186, 200
WMS system, 204
HP Database Manager (HPDM), 39
HP_DEFAULT_SERVICE
description of, 48
mapping to, 23
HPS_ connection rules, 47
HPS_ services, 47
I
INFO RULE command, 214
INFO RULE COMP command, 216
INFO RULE CONN command, 217
INFO RULE EXEC command, 218
INFO SERVICE command, 219
INFO SERVICE COMP command, 221
INFO SERVICE EXEC command, 222
INFO WMS command, 223
INFO WMS CONN command, 224
Information, new and changed, 13
K
Killing queries (see Cancelling queries)
L
Live View
configuration options, 125
description of, 121
pause display, 122
refresh display, 122
Logging services status, 149
LOGIN, syntax of, 179, 193
M
Max processor utilization, 52
MAX_CPU_BUSY threshold, syntax of
service, 186, 200
WMS system, 204
(see also Max processor utilization)
MAX_MEM_USAGE threshold, syntax of
service, 186, 200
WMS system, 204
MAX_ROWS_FETCHED threshold, syntax of
service, 186, 200
WMS system, 204
Memory usage, displaying, 255
Metric Miner, 39
MODE NS command, 38
MODE WMS command, 38
Monitoring Query window, 128
N
NCI
installing, 38
NS mode, 38
using WMS commands, 38
WMS mode, 38
NDCS server, 21
Neoview Database Connectivity Service (NDCS), 21
Neoview Performance Analyzer
connecting to the Neoview platform, 37
description of, 35
launching, 36
Neoview Query Viewer
description of, 35
launching, 36
Neoview Repository, 45
Neoview Stored Procedures in Java (SPJs), 45
Neoview Workload Management Services (WMS),
description of, 21
New information, 13
NO_PLAN, syntax of, 187, 200
NO_TEXT, syntax of, 187, 201
NS mode, 38
NUM_JOINS, syntax of, 175, 190
P
PLAN, syntax of, 187, 200
Predefined connection rules, 47
Predefined services, 47
Q
Queries
268 Index