HP Neoview Release 2.5 Software - Manual (Page 60)

Description Field
Priority of the service relative to other services in WMS:
• URGENT
• HIGH
• MEDIUM-HIGH
• MEDIUM
• LOW-MEDIUM
• LOW
NOTE: The service priority is not a process priority.
SERVICE_PRIORITY
Maximum CPU busy allowed. Zero means this threshold is not checked. MAX_CPU_BUSY
Maximum memory usage allowed. Zero means this threshold is not checked. MAX_MEM_USAGE
Maximum number of rows that can be returned. MAX_ROWS_FETCHED
Time range during which the service can accept incoming queries, such as from 00:00
through 24:00. ACTIVE_TIME
PLAN indicates that the query execution plans are collected for display.
NO_PLAN indicates that no plans are collected for display. SQL_PLAN
TEXT indicates that the SQL syntax of executing queries is collected for display.
NO_TEXT indicates that no SQL text is collected for display. SQL_TEXT
Maximum time interval a query can be in the executing state before the query
automatically times out. Zero means no timeout. EXEC_TIMEOUT
Maximum time interval a query can be in the waiting state before the query automatically
times out. Zero means no timeout. WAIT_TIMEOUT
Maximum time interval a query can be in the holding state before the query automatically
times out. Zero means no timeout. HOLD_TIMEOUT
SQL string that sets process priorities or session defaults for the service SQL_DEFAULTS
Services User Interface
You can perform actions on the services with these interface options:
• [Add] and the add service toolbar (plus sign) are always enabled and launch the Add Service
dialog box that lets you add a service. See “Add a New WMS Service ” (page 61) .
• [Alter] and the alter service toolbar (pencil icon) are enabled if only one row is selected in
the data grid. When you click on these controls, the selection on the configuration tree will
move to the service selected in the summary grid. The right pane will display the service
details and you can alter the service details. You can also double-click on a data grid row to
navigate to the specific service.
• [Delete] and the delete service toolbar (X icon) are enabled if one or more rows are selected
in the data grid and allow you to delete the selected services. In R2.4, only services that are
in a stopped state are deleted. System-created services HP_DEFAULT_SERVICE,
HPS_MANAGEABILITY, HPS_TRANSPORTER cannot be deleted. If one of these
system-created services is in the selected list, it will be ignored and an informational message
will be displayed.
• [Start] and start service toolbar (right arrow icon) are enabled if one or more rows are selected
in the data grid. If enabled, you can start the selected services. Only services in a stopped
state are started. (R2.4 feature). For R2.3 [Start] and the start toolbar are hidden.
• [Stop] and the stop service toolbar (red square icon) are enabled if one or more rows are
selected in the data grid. If enabled, you can stop the selected services. Only active services
can be stopped. (R2.4 feature) For R2.3, [Stop] and the stop toolbar are hidden. System-created
services HP_DEFAULT_SERVICE, HPS_MANAGEABILITY, HPS_TRANSPORTER cannot
60 Neoview Workload Management Services (WMS) Configuration