ENQTIME parameter: Difference between revisions
No edit summary |
|||
| Line 16: | Line 16: | ||
==Description== | ==Description== | ||
The <var>ENQTIME</var> parameter specifies the number of milliseconds waited for each automatic record locking retry wait. | |||
<var>ENQTIME</var> can be between 1 and 60000, corresponding to a minimum of 1 millisecond and a maximum of 1 minute. | |||
The default value of <var>ENQTIME</var> is 3000 (3 seconds). | |||
==Usage notes== | |||
If record locking conflicts occur frequently in a busy online, it is recommended that you decrease | |||
<var>ENQTIME</var> from its default value, which is 3000 (3 seconds). | |||
Using that default value, any user with a non-zero value for <var>[[ENQRETRY parameter|ENQRETRY]]</var> | |||
will wait at least 3 seconds before the conflict is dealt with. | |||
This can degrade overall system performance. | |||
<ul> | |||
<li>For example, assuming <var>ENQRETRY</var> = 7: | |||
<p> | |||
If you reset <var>ENQTIME</var> to 100: | |||
</p> | |||
<p> | |||
After a | |||
record locking conflict occurs the thread may retry 7 | |||
times with wait intervals of 1/10 second, and so within at | |||
most 7/10 seconds either the lock becomes available or the | |||
conflict triggers an On unit or cancels the request. | |||
</p> | |||
</li> | |||
</ul> | |||
The <var>ENQTIME</var> parameter may also be reset with <var>[[$Resetn]]</var>. | |||
[[Category:Parameters]] | [[Category:Parameters]] | ||
[[Category:User parameters]] | [[Category:User parameters]] | ||
Revision as of 20:26, 11 April 2018
Record locking retry wait time, milliseconds
Summary
- Default value
- 3000 (i.e., 3 seconds)
- Parameter type
- User
- Where set
- Any user
- Related products
- All
- Introduced
- Model 204 version 7.8 (and available via maintenance in version 7.7)
Description
The ENQTIME parameter specifies the number of milliseconds waited for each automatic record locking retry wait.
ENQTIME can be between 1 and 60000, corresponding to a minimum of 1 millisecond and a maximum of 1 minute. The default value of ENQTIME is 3000 (3 seconds).
Usage notes
If record locking conflicts occur frequently in a busy online, it is recommended that you decrease ENQTIME from its default value, which is 3000 (3 seconds).
Using that default value, any user with a non-zero value for ENQRETRY will wait at least 3 seconds before the conflict is dealt with.
This can degrade overall system performance.
- For example, assuming ENQRETRY = 7:
If you reset ENQTIME to 100:
After a record locking conflict occurs the thread may retry 7 times with wait intervals of 1/10 second, and so within at most 7/10 seconds either the lock becomes available or the conflict triggers an On unit or cancels the request.
The ENQTIME parameter may also be reset with $Resetn.