Neoview Workload Management Services Guide (R2.4)

Considerations
• The STATUS SERVICE command returns this information about one or all services in WMS:
Table A-21 STATUS SERVICE Output
DescriptionData TypeColumn Name
Name of the serviceVARCHAR(96)SERVICE_NAME
State of the service:VARCHAR(9)STATE
— 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)
Priority of the service: URGENT, HIGH, MEDIUM-HIGH,
MEDIUM, LOW-MEDIUM, or LOW
VARCHAR(11)SERVICE_PRIORITY
Maximum CPU busy allowed. Zero (0) means this threshold
is not checked.
INTMAX_CPU_BUSY
Maximum memory usage allowed. Zero (0) means this
threshold is not checked.
INTMAX_MEM_USAGE
Maximum number of rows that can be returned.LARGEINTMAX_ROWS_FETCHED
Time range during which the service can accept incoming
queries, such as from 00:00 through 24:00.
VARCHAR(19)ACTIVE_TIME
PLAN indicates that the query execution plans are collected
for display. NO_PLAN indicates that no plans are collected
for display.
VARCHAR(7)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.
VARCHAR(7)SQL_TEXT
Timeout value for executing queries in the service. Zero means
no timeout.
INTEXEC_TIMEOUT
Timeout value for waiting queries in the service. Zero means
no timeout.
INTWAIT_TIMEOUT
Timeout value for holding queries in the service. Zero means
no timeout.
INTHOLD_TIMEOUT
Examples
• This command displays information for all the services in WMS:
STATUS SERVICE ALL;
• This command displays information for SERVICE1:
STATUS SERVICE SERVICE1;
STATUS SERVICE Command 143