Neoview Workload Management Services Guide (R2.4)

STATUS SERVICE COMP Command
The STATUS SERVICE COMP command returns the names of the compilation rules associated
with the specified service.
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 COMP
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-21 (page 143).
Considerations
• The STATUS SERVICE COMP command returns this information:
Table A-22 STATUS SERVICE COMP Output
DescriptionData TypeColumn Name
COMPVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)RULE_NAME
Services to which the rule is associatedVARCHAR(96)SERVICE_NAME
Examples
• This command displays the names of the compilation rules that are associated with
SERVICE1:
STATUS SERVICE SERVICE1 COMP;
144 WMS Commands