Neoview Workload Management Services Guide (R2.5)

INFO SERVICE Command
The INFO SERVICE command returns information from the WMS metadata about the attributes
of one or all services in WMS. The metadata is updated less often than shared memory in WMS.
See the “STATUS SERVICE Command” (page 245), 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 | 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
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 percentage of CPU busy allowed. Zero means that this
threshold is not checked.
INTMAX_CPU_BUSY
Maximum percentage of memory usage allowed. Zero means that
this threshold is not checked.
INTMAX_MEM_USAGE
Maximum number of rows that can be returned. Zero means no
limit.
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 text of executing queries is collected
for display. NO_TEXT indicates that no SQL text is collected for
display.
VARCHAR(7)SQL_TEXT
Timeout value, in minutes, for executing queries in the service.
Zero means no timeout.
INTEXEC_TIMEOUT
Timeout value, in minutes, for waiting queries in the service. Zero
means no timeout.
INTWAIT_TIMEOUT
Timeout value, in minutes, for holding queries in the service. Zero
means no timeout.
INTHOLD_TIMEOUT
INFO SERVICE Command 219