Neoview Workload Management Services Guide (R2.3)

Considerations
To execute this command in NS mode in NCI, see “How to Execute WMS Commands in NCI”
(page 55).
Examples
• This command suspends all WMS activities and puts WMS in a holding state:
HOLD WMS
• This command holds all waiting queries in the DATALOADING service:
HOLD SERVICE dataloading
• This command holds all services on the Neoview platform:
HOLD SERVICE ALL
• This command holds a specific waiting query:
HOLD QUERY MXID0100100050121203677536...
• This command holds all waiting queries on the Neoview platform:
HOLD QUERY ALL
INFO SERVICE Command
The INFO SERVICE command returns the service name, priority, threshold limits, and any
comments for one or all services in WMS.
Syntax
INFO SERVICE { ALL | service-name }
ALL represents all services on the system.
service-name is the name of a user-defined service for managing queries. service-name
must exist in the WMS configuration. 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.
Considerations
• The INFO SERVICE command returns this information about one service or all the services
on the system:
Table A-1 INFO SERVICE Command Output
DescriptionData TypeColumn Name
Name of the serviceVARCHAR(96)SERVICE_NAME
Priority of the serviceVARCHAR(10)SERVICE_PRIORITY
Maximum CPU busy allowed for this service. If this value is zero, it
means that the default value, means that WMS uses the threshold of
the WMS system configuration, if set, or the internal default threshold
of 100%.
INTMAX_CPU_BUSY
Maximum memory usage allowed for this service. If this value is
zero, the default value, it means that WMS uses the threshold of the
WMS system configuration, if set, or the internal default threshold
of 85%.
INTMAX_MEM_USAGE
Time range during which the service executes queries, such as from
00:00 through 23:59
VARCHAR(19)ACTIVE_TIME
64 WMS Commands