Neoview Workload Management Services Guide (R2.5)

Table A-22 STATUS SERVICE 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 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
SQL string for setting process priorities or defaultsVARCHAR(1024)SQL_DEFAULTS
Examples
• This command displays information for all the services in WMS:
STATUS SERVICE ALL;
• This command displays information for SERVICE1:
STATUS SERVICE SERVICE1;
246 WMS Commands