Neoview Workload Management Services Guide (R2.5)

STATUS SERVICE EXEC Command
The STATUS SERVICE EXEC command returns the names of the execution rules associated with
the specified service from shared memory.
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 EXEC
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. For output information, see Table A-22 (page 245).
Considerations
The STATUS SERVICE EXEC command returns this information:
Table A-24 STATUS SERVICE EXEC Output
DescriptionData TypeColumn Name
EXECVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)RULE_NAME
Services to which the rule is associatedVARCHAR(96)SERVICE_NAME
Example
This command displays the names of the execution rules associated with SERVICE1:
STATUS SERVICE SERVICE1 EXEC;
248 WMS Commands