Sets the time limit for a database query. (QQRYTIMLMT)
Database query time limit, also known as QQRYTIMLMT, is a member of the performance category of i5/OS™ system values. You can use this system value to set the time limit for a database query. To learn more, keep reading.
| Quick reference | |
|---|---|
| Location | In iSeries™ Navigator, select your system, |
| Special authority | All object (*ALLOBJ) and security administrator (*SECADM) |
| Default value | No maximum |
| Changes take effect | Immediately |
| Lockable | No |
Specifies the query processing time limit that is compared to the estimated number of elapsed seconds that a query must run. The time limit determines if the database query can start.
The following are possible options:
There is no maximum number of estimated elapsed seconds.
Specifies the number of seconds that are compared to 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.
To learn more, go to the performance system values overview topic. If you are looking for a specific system value or category of system values, try using the i5/OS system value finder.