Neoview Workload Management Services Guide (R2.5)

STATUS SERVICE SEGMENT STATS Command
The STATUS SERVICE SEGMENT STATS command returns running counts and average times
of the queries in one or all services on one or all segments of the Neoview platform. The command
returns the total number of queries in various states (executing, waiting, holding, and suspended)
and their average execution, waiting, holding, and suspended times.
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 ] [ SEGMENT segment-num ] STATS [DETAIL]
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. If you specify a service name, the command returns query counts and average times
for that service on one or all segments.
segment-num
is the number of a segment on the Neoview platform. If you specify a segment number, the
command returns query counts and average times for one or all services on the specified
segment.
DETAIL
returns statistics for each segment of the Neoview platform. If you do not specify DETAIL,
the command returns query counts and average times for all segments of the Neoview
platform.
Considerations
• The STATUS SERVICE SEGMENT STATS commands returns these query counts and average
times:
Table A-26 STATUS SERVICE SEGMENT STATS Output
DescriptionData TypeColumn Name
Segment numberVARCHAR(4)SEGMENT
Name of the serviceVARCHAR(96)SERVICE_NAME
Cumulative number of queries on this segment since the start of
statistics collection
INTTOTAL_QUERIES
Cumulative number of queries that were in the executing state
since the start of statistics collection
INTTOTAL_EXEC
Cumulative number of queries that were in the waiting state since
the start of statistics collection
INTTOTAL_WAIT
Cumulative number of queries that were in the holding state since
the start of statistics collection
INTTOTAL_HOLD
Cumulative number of queries that were in the suspended state
since the start of statistics collection
INTTOTAL_SUSPEND
Cumulative number of queries that were rejected since the start of
statistics collection
INTTOTAL_REJECT
250 WMS Commands