Neoview Workload Management Services Guide (R2.5)

STATUS SERVICE Command
The STATUS SERVICE command returns information from shared memory about the attributes
of one or all services in WMS.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
STATUS SERVICE [ { service-name | ALL } ]
service-name
is the name of a user-defined service for managing queries. service-name can be a maximum
of 24 characters and must be a unique name in WMS. service-name must exist in the WMS
configuration but cannot be the SYSTEM service. The service name is not case-sensitive and
is always converted to uppercase. WMS supports multibyte characters in the service name.
For guidelines on using multibyte character sets, see the Neoview Character Sets Administrator's
Guide. For output information, see Table A-22 (page 245).
ALL
returns status information about all the services in WMS.
Considerations
The STATUS SERVICE command returns this information about one or all services in WMS:
Table A-22 STATUS SERVICE Output
DescriptionData TypeColumn Name
Name of the serviceVARCHAR(96)SERVICE_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)
VARCHAR(9)STATE
Priority of the service: URGENT, HIGH, MEDIUM-HIGH,
MEDIUM, LOW-MEDIUM, or LOW
VARCHAR(11)SERVICE_PRIORITY
Maximum percentage of CPU busy allowed. Zero means that this
threshold is not checked.
INTMAX_CPU_BUSY
Maximum percentage of memory usage allowed. Zero means that
this threshold is not checked.
INTMAX_MEM_USAGE
Maximum number of rows that can be returned. Zero means no
limit.
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
STATUS SERVICE Command 245