Neoview Workload Management Services Guide (R2.3)

Changing the EXEC_TIMEOUT, WAIT_TIMEOUT, PLAN, and TEXT parameters does not affect
the currently executing or waiting queries associated with the service. However, changing these
settings does affect new incoming queries associated with the service.
Deleting a Service
Use the DELETE SERVICE command to delete a service from the WMS configuration. After you
delete a service, incoming queries associated with the deleted service are managed either by a
service with the same name as the client role, if one exists, or by the HP_DEFAULT_SERVICE
service if a service with the same name as the client role does not exist. For example, in NCI, this
DELETE SERVICE command removes the DATALOADING service from the WMS configuration:
NS%delete service dataloading;
--- WMS operation complete.
NS%
For the syntax, see the “DELETE SERVICE Command” (page 62). You can also execute the
DELETE SERVICE command in JDBC and ODBC client applications. For more information, see
“How to Execute WMS Commands in NCI” (page 55).
When you issue a DELETE SERVICE command, the state of the deleted service changes from
active or hold to deleting. In the deleting state, WMS cancels all waiting queries and rejects all
incoming queries (that is, execution requests) associated with the service. To cancel currently
executing queries associated with the deleted service, use the IMMEDIATE option with the
DELETE SERVICE command. The IMMEDIATE option cancels all currently executing queries
associated with the service when you delete the service. If you do not specify the IMMEDIATE
option, WMS allows the queries to finish executing.
Displaying Information About the Service Definitions
The INFO SERVICE command displays information about the configuration of one or all services
in WMS:
Name of the serviceSERVICE_NAME
The priority of the service relative to other services. The default is MEDIUM.SERVICE_PRIORITY
A percentage from zero to 100 of the total CPU busy allowed for the service. This value
is an average of CPU busy across all segments in the cluster. The default is zero, meaning
that WMS uses the threshold of the WMS system configuration, if set, or the internal
default threshold of 100%.
MAX_CPU_BUSY
A percentage from zero to 100 of memory usage allowed for the service. This value is
an average of memory usage across all segments in the cluster. The default is zero,
meaning that WMS uses the threshold of the WMS system configuration, if set, or the
internal default threshold of 85%.
MAX_MEM_USAGE
The time period during which the service is active and can execute queries. The default
is 00:00 through 23:59.
ACTIVE_TIME
Displays PLAN to indicate that the query execution plans are collected for display or
NO_PLAN to indicate that no plans are collected for display
SQL_PLAN
Displays TEXT to indicate that the SQL syntax of executing queries is collected for
display or NO_TEXT to indicate that no SQL text is collected for display
SQL_TEXT
The number of minutes a query is allowed to remain in the executing state before WMS
cancels the query. The default is zero, meaning no timeout.
EXEC_TIMEOUT
The number of minutes a query is allowed to remain in the waiting state before WMS
cancels the query. The default is zero, meaning no timeout.
WAIT_TIMEOUT
Text that describes the service. By default, there is no comment.COMMENT
32 Configuring WMS