Neoview Workload Management Services Guide (R2.5)
Understand the Service Definitions
This table describes the attributes of the WMS services that appear in the Services Summary
pane:
DescriptionField
Name of the serviceSERVICE_NAME
State of the service:
• INIT (initialization)
• ACTIVE (when the service is within its active period)
• HOLD (when the service is put on hold)
• STOPPING (when the service has been stopped by a STOP SERVICE command but
queries are still executing in the service)
• STOPPED (when the service is stopped by a STOP SERVICE command)
• TRANSIENT (when the service temporarily goes into different states, such as
STOPPED and STOPPING, on different segments of the Neoview platform)
STATE
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 percentage of CPU busy allowed. Zero means that this threshold is not
checked.
MAX_CPU_BUSY
Maximum percentage of memory usage allowed. Zero means that this threshold is not
checked.
MAX_MEM_USAGE
Maximum number of rows that can be returned. Zero means no limit.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 text of executing queries is collected for display.
NO_TEXT indicates that no SQL text is collected for display.
SQL_TEXT
Maximum time interval, in minutes, that a query can be in the executing state before
the query automatically times out. Zero means no timeout.
EXEC_TIMEOUT
Maximum time interval, in minutes, that a query can be in the waiting state before the
query automatically times out. Zero means no timeout.
WAIT_TIMEOUT
Maximum time interval, in minutes, that 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 serviceSQL_DEFAULTS
56 Configuring Services