Neoview Workload Management Services Guide (R2.5)

RELEASE Command
The RELEASE command releases a query or a set of queries being managed by WMS from the
holding state.
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
RELEASE type
type is:
{ WMS }
| { SERVICE { service-name | ALL } }
| { QUERY { query-id | ALL } }
| { QUERIES SERVICE service-name }
type
specifies one of these options for releasing queries from the holding state:
Releases WMS from a HOLD state.WMS
Changes the service state from HOLD to ACTIVE.
service-name is the name of an existing user-defined service for
managing queries. service-name must exist in the WMS
configuration and cannot be the SYSTEM service. The service name is
not case-sensitive and is always converted to uppercase.
SERVICE service-name
Releases all services on the Neoview platform from a HOLD state.SERVICE ALL
Releases the specified query from a HOLDING state. query-id is the
query identifier and can be a maximum of 160 characters.
QUERY query-id
Releases all queries on the Neoview platform from a HOLDING state.QUERY ALL
Releases all queries in the specified service from a HOLDING state.
service-name is the name of an existing user-defined service for
managing queries. service-name must exist in the WMS
configuration and cannot be the SYSTEM service. The service name is
not case-sensitive and is always converted to uppercase.
QUERIES SERVICE service-name
Examples
• This command releases WMS from the HOLD state:
RELEASE WMS;
• This command changes SERVICE1's state from HOLD to ACTIVE:
RELEASE SERVICE SERVICE1;
• This command changes the state of all services on the Neoview platform from HOLD to
ACTIVE:
RELEASE SERVICE ALL;
• This command releases a specific query from the holding state:
RELEASE QUERY MXID01002031074212110209169193275000000000609ROLE.USR200_73_S1;
• This command releases all queries on the Neoview platform from the holding state:
RELEASE QUERY ALL;
• This command releases all queries in SERVICE1 from the HOLD state:
RELEASE QUERIES SERVICE SERVICE1;
RELEASE Command 225