Neoview Workload Management Services Guide (R2.4)

INFO SERVICE Command
The INFO SERVICE command returns information about the attributes of one or all services in
WMS.
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
INFO SERVICE [ { service-name | ALL } ]
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.
ALL
represents all services in WMS.
Considerations
• The INFO SERVICE command returns this information about one or all services in WMS:
Table A-6 INFO SERVICE Output Information
DescriptionData TypeColumn Name
Name of the serviceVARCHAR(96)SERVICE_NAME
Priority of the service: URGENT, HIGH, MEDIUM-HIGH,
MEDIUM, LOW-MEDIUM, or LOW
VARCHAR(11)SERVICE_PRIORITY
Maximum CPU busy allowed. Zero (0) means this threshold is
not checked.
INTMAX_CPU_BUSY
Maximum memory usage allowed. Zero (0) means this threshold
is not checked.
INTMAX_MEM_USAGE
Maximum number of rows that can be returned.LARGEINTMAX_ROW_FETCHED
Time range during which the service can accept incoming
queries, such as from 00:00 through 24:00.
VARCHAR(19)ACTIVE_TIME
PLAN indicates that the query execution plans are collected for
display. NO_PLAN indicates that no plans are collected for
display.
VARCHAR(7)SQL_PLAN
TEXT indicates that the SQL syntax of executing queries is
collected for display. NO_TEXT indicates that no SQL text is
collected for display.
VARCHAR(7)SQL_TEXT
Timeout value for executing queries in the service. Zero means
no timeout.
INTEXEC_TIMEOUT
Timeout value for waiting queries in the service. Zero means
no timeout.
INTWAIT_TIMEOUT
Timeout value for holding queries in the service. Zero means
no timeout.
INTHOLD_TIMEOUT
Comment stringVARCHAR(1024)COMMENT
INFO SERVICE Command 119