Neoview Workload Management Services Guide (R2.3)

Index
A
Active period, setting start and end times, 30
ACTIVE state, 42
ACTIVE threshold, syntax of, 57, 59
ACTIVE_TIME
description of, 32, 42
setting the value, 30
ADD SERVICE command
example of, 29
syntax of, 56
ALTER SERVICE command, syntax of, 58
ALTER WMS command
example of, 34
syntax of, 60
C
CANCEL command
example of, 52
syntax of, 61
Client data source, specifying a service, 35
Client role, 35
COMMENT, 32
Compile-time statistics, examples of, 43, 44
Configuration, WMS, 25
D
Data source, specifying a service, 35
DELETE SERVICE command, syntax of, 62
Documents, related information, 13
E
EXEC_TIMEOUT, syntax of, 57, 59
Executing queries
displaying in NCI, 45, 46
monitoring, 43, 44
Execution statistics, 47
Explain plan, 50
G
GET SERVICE statement, 38
getServiceName method, 37
H
HOLD command
example of, 51, 52
syntax of, 63
HOLD state, 42
HP_DEFAULT_SERVICE
description of, 25
mapping to, 19, 32
I
INFO SERVICE command
example of, 33
output of, 32
syntax of, 64
INFO WMS command
example of, 34
syntax of, 65
J
JDBC application
getting the service in effect, 37
setting the service of queries, 37, 38
M
MAX_CPU_BUSY threshold
default value, 34
description of, 32, 41
displaying, 34
setting, 34
syntax of, 57, 59, 61
MAX_MEM_USAGE threshold
default value, 34
description of, 32, 41
displaying, 34
setting, 34
syntax of, 57, 59, 61
MODE NS command, 55
Multibyte characters, service name, 38
MXODSN file, specifying a service, 37
N
NCI
installing, 23
NS mode, 55
setting the service of queries, 38
using WMS commands, 55
NDCS server, 17
Neoview Database Connectivity Service (NDCS), 17
Neoview Workload Management Services (WMS),
description of, 17
NO_PLAN, syntax of, 57, 59
NO_TEXT, syntax of, 57, 60
NS mode, 55
O
ODBC application
getting the service in effect, 37
setting the service of queries, 37, 38
ODBC Data Source Administrator, 35
P
PLAN, syntax of, 57, 59
Q
Queries
associating with a service, 35
cancelling, 52
checking the status of all queries, 43
checking the status of queries in a service, 44
75