Neoview Workload Management Services Guide (R2.5)

Description or ActionAttribute or FieldGroup Box
Maximum number of rows that can be returned by a query.
Enter a number from 0 to 9223372036854775807. Zero means no limit.
If you set a Max Rows Fetched (or MAX_ROWS_FETCHED) limit for
the service, the NDCS server considers this limit when fetching rows
for queries associated with the service. If the number of rows fetched
for a query exceeds the MAX_ROWS_FETCHED limit, the NDCS server
returns part of the data from the query and this error message to the
client application:
SQL error:The limit for maximum rows to be returned
for a query, as set by the administrator, was
exceeded. [yyyy-mm-ddhh:mm:ss]
The hh:mm:ss value is the timestamp of when the error message
occurred.
Max Rows Fetched
Maximum time interval a query can be in the executing state before the
query automatically times out.
Enter a value from 0 to 1440 minutes. Zero means no timeout.
IMPORTANT: Avoid setting an Execution Timeout (or
EXEC_TIMEOUT) value for a service that handles long-running
INSERT-SELECT statements. If you do, WMS cancels the
INSERT-SELECT statement when the timeout value is reached, causing
the entire transaction to be rolled back.
Execution TimeoutTimeout (in
minutes)
Maximum time interval a query can be in the waiting state before the
query automatically times out.
Enter a value from 0 to 1440 minutes. Zero means no timeout.
Wait Timeout
Maximum time interval a query can be in the holding state before the
query automatically times out.
Enter a value from 0 to 1440 minutes. Zero means no timeout.
Hold Timeout
Select the check box to cause the WMS server processes to temporarily
store the execution plans of queries executing in the service. That way,
client tools can display the query plans.
IMPORTANT: Avoid enabling this option because of its overhead.
Instead, use the Neoview Query Workbench to view the query plan
(using the Explain button).
SQL PlanOptions
Select the check box to cause the WMS server processes to temporarily
store the SQL text of queries executing in the service. That way, client
tools can display the SQL text.
IMPORTANT: Avoid enabling this option because of its overhead.
Instead, use the Neoview Query Viewer (or the Live View in the
Neoview Performance Analyzer) to see the first 255 characters of the
SQL or query text, and use the Neoview Repository to see the full SQL
text.
SQL Text
A time range during which the service executes queries. The active time
cannot span more than one day.
Enter a start time in hh:mm, where hh is a value for the hour and mm is
a value for minutes. The minimum start time is 00:00.
From Time (HH:mm)Active Time
Enter an end time in hh:mm, where hh is a value for the hour and mm is
a value for minutes. The maximum end time is 24:00.
To Time (HH:mm)
Enter optional, free-form text to describe the service. You can enter a
maximum of 256 characters.
CommentsComments
60 Configuring Services