MAX_QUERY_TIME option

Function

Sets a time limit so that the optimizer can disallow very long queries.

Allowed values

0 to 232 - 1 minutes

Scope

Can be set at the session (temporary), user, or PUBLIC level.

Default

0 (disabled)

Description

If the query runs longer than the MAX_QUERY_TIME setting, IQ stops the query and sends a message to the user and the IQ message file. For example:

The operation has been cancelled -- Max_Query_Time exceeded.

This option applies only to queries and does not apply to any SQL statement which is modifying the contents of the database.