Neoview Workload Management Services Guide (R2.4)

STATUS SERVICE SEGMENT STATS Command
The STATUS SERVICE SEGMENT STATS command returns aggregated statistics about the
queries running in one or all services on one or all segments of the Neoview platform.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (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 statistics 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 statistics 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 aggregated statistics for all segments of the Neoview platform.
Considerations
• The STATUS SERVICE SEGMENT STATS commands returns these statistics:
Table A-25 STATUS SERVICE SEGMENT STATS Output
DescriptionData TypeColumn Name
Segment numberVARCHAR(4)SEGMENT
Name of the serviceVARCHAR(96)SERVICE_NAME
Total number of queries on this segmentINTTOTAL_QUERIES
Total number of executing queriesINTTOTAL_EXEC
Total number of waiting queriesINTTOTAL_WAIT
Total number of holding queriesINTTOTAL_HOLD
Total number of suspended queriesINTTOTAL_SUSPEND
Total number of rejected queriesINTTOTAL_REJECT
Total number of cancelled queriesINTTOTAL_CANCEL
Total number of completed queriesINTTOTAL_COMPLETE
Average execution time in secondsINTAVG_EXEC_SECS
Average waiting time in secondsINTAVG_WAIT_SECS
Average holding time in secondsINTAVG_HOLD_SECS
Average suspended time in secondsINTAVG_SUSPEND_SECS
Time when statistics collection startedVARCHAR(26)START_TIME
STATUS SERVICE SEGMENT STATS Command 147