Neoview Workload Management Services Guide (R2.5)

INFO SERVICE COMP Command
The INFO SERVICE COMP command returns the names of the compilation rules associated with
the specified service from the WMS metadata. The metadata is updated less often than shared
memory in WMS. See the “STATUS SERVICE COMP Command” (page 247), which returns
information 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
INFO 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-7.
Considerations
The INFO SERVICE COMP command returns this information:
Table A-7 INFO SERVICE COMP Output
DescriptionData TypeColumn Name
COMPVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)RULE_NAME
Services to which rule is associated.VARCHAR(96)SERVICE_NAME
Example
This command displays the names of the compilation rules that are associated with SERVICE1:
INFO SERVICE SERVICE1 COMP;
INFO SERVICE COMP Command 221