Neoview Control Query Default (CQD) Reference Guide (R2.5)

STREAM_TIMEOUT
Runtime controlsCategory
Enables unblocking using a timeout. When a SQL table is read with stream access, it never
returns the end-of-data condition, but rather blocks as it waits for more rows to be inserted
or updated. Applications, however, may need for the stream to temporarily unblock and
return control so that the application can commit its transaction, or do other work. The
unblocking is achieved by means of a timeout, the duration of which is controlled by this
default.
Description
There is no timeout.‘-1’
The length of time, in 1/100
th
seconds, of the timeout.greater than ‘0’ and up
through ‘2,147,483,583’
The default value is ‘-1’.
Values
An application written to use stream access with timeouts can issue this default with a
“CONTROL QUERY DEFAULT” command.
Usage
It is not recommended to set this default permanently in production, except through the
same application which is using stream access.
Production usage
The impact of setting this default is specific to the application.Impact
QueryLevel
Not applicableConflicts/Synergies
Not applicableAddressing the real
problem
Neoview Release 1.0Introduced in release
Not applicableDeprecated in release
AUTO_QUERY_RETRY_WARNINGS
Operational controlsCategory
Indicates whether a warning should be issued when a query is retried, in case a failed query
is automatically retried.
Description
‘ON’
‘OFF’
The default value is ‘OFF’.
Values
There are certain cases, such as when a CPU failure occurs, where a query may fail
midstream. In many of such failure scenarios, if the query has not returned any data, it is
retried automatically.
When such retries happen, you may want to see a warning that an automatic retry took
place. That would be a reason to turn this on.
Usage
Not applicableProduction usage
You get a warning message every time a query is automatically retried due to a failure.
When there is a CPU failure, a large number of queries may be impacted. So you need to
assess if you want to see a flood of warnings. The warning is returned after the query
completes.
Impact
SystemLevel
Not applicableConflicts/Synergies
Not applicableAddressing the real
problem
STREAM_TIMEOUT 61