Neoview Workload Management Services Guide (R2.3)

Table A-1 INFO SERVICE Command Output (continued)
DescriptionData TypeColumn Name
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 are 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 serviceINTEXEC_TIMEOUT
Timeout value for waiting queries in the serviceINTWAIT_TIMEOUT
Optional comment that describes the serviceVARCHAR(1024)COMMENT
• To execute this command in NS mode in NCI, see “How to Execute WMS Commands in
NCI” (page 55).
Examples
• This command displays information about the DATALOADING service:
INFO SERVICE dataloading
• This command displays information about all the services on the system:
INFO SERVICE ALL
INFO WMS Command
The INFO WMS command returns this information about the WMS system configuration:
• Maximum CPU busy
• Maximum memory usage
• Interval at which WMS collects query runtime statistics
Syntax
INFO WMS
Considerations
• The INFO WMS command returns this information about the WMS system configuration:
Table A-2 INFO WMS Command Output
DescriptionData TypeColumn Name
Maximum CPU busy allowed. If this value is zero, it means that
WMS uses the internal value of 100 percent.
INTMAX_CPU_BUSY
Maximum memory usage allowed. If this value is zero, it means that
WMS uses the internal value of 85 percent.
INTMAX_MEM_USAGE
Frequency of updates to query runtime statistics. The default value
is five seconds.
INTSTATS_INTERVAL
• To execute this command in NS mode in NCI, see “How to Execute WMS Commands in
NCI” (page 55).
Examples
• This command displays information about the WMS system configuration:
INFO WMS Command 65