Neoview Workload Management Services Guide (R2.3)

service-name is the name of a user-defined service for managing queries. service-name
must exist in the WMS configuration but cannot be the SYSTEM service or
the HP_DEFAULT_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.
IMMEDIATE removes the service immediately from WMS, causing all queries in the service
to be immediately cancelled. When IMMEDIATE is not specified, new queries
are not allowed to enter the service, and any waiting queries are cancelled,
but any executing queries are allowed to finish before the service is deleted.
Considerations
• You cannot delete SYSTEM or HP_DEFAULT_SERVICE.
• To execute this command in NS mode in NCI, see “How to Execute WMS Commands in
NCI” (page 55).
Examples
• This command removes the DATALOADING service from the WMS configuration:
DELETE SERVICE dataloading
• This command removes the SALESQUERIES service immediately from the WMS
configuration and cancels all queries associated with that service, including executing queries:
DELETE SERVICE salesqueries IMMEDIATE
HOLD Command
The HOLD command places a waiting query or a set of waiting queries being managed by WMS
on hold. You cannot hold an executing query. To cancel an executing query, see the “CANCEL
Command” (page 61).
Syntax
HOLD type
type is:
{ WMS }
| { SERVICE { service-name | ALL }
| { QUERY { query-id | ALL } }
type
specifies one of these options for holding queries:
suspends all WMS activities and puts WMS in a holding state.WMS
holds all waiting queries in the specified service. service-name
is the name of a user-defined service for managing queries. 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.
SERVICE service-name
holds all services on the Neoview platform.SERVICE ALL
holds the specified waiting query. query-id is the query identifier
and can be a maximum of 160 characters.
QUERY query-id
holds all waiting queries on the Neoview platform.QUERY ALL
HOLD Command 63