Performance system values: Database query time limit
The Database query time limit system value is also known as QQRYTIMLMT. You can use this system value to set the time limit for a database query.
Quick reference | |
---|---|
Location | From IBM® Navigator for i, select . Right-click on Performance and click Properties, then select the Database tab. |
Special authority | All object (*ALLOBJ) and security administrator (*SECADM). |
Default value | No maximum. |
Changes take effect | Immediately. |
Lockable | No. |
What can I do with this system value?
You can specify the query processing time limit that is compared with the estimated time that a query must run. The time limit determines if the database query can start.
This system value has the following options:
- No maximum (*NOMAX)
- There is no maximum number of estimated elapsed seconds.
- 0-2147352578 (0-2147352578)
- This option specifies the number of seconds that is compared with the estimated number of elapsed seconds that are required to run a query. If the number of estimated elapsed seconds is greater than this value, the query is not started. 2147352578 seconds is approximately 68 years.