SQLBSCAN parameter: Difference between revisions
Jump to navigation
Jump to search
m (Automatically generated page update) |
(Automatically generated page update) |
||
| Line 16: | Line 16: | ||
<p><var class="product">Model 204</var> issues a user restart when an SQL request reaches SQLBSCAN internal operations, which include indexed finds, fetching from files and intermediate result tables, and writing to files and intermediate result tables. The SQLBSCAN counter is not affected by user swapping.</p> | <p><var class="product">Model 204</var> issues a user restart when an SQL request reaches SQLBSCAN internal operations, which include indexed finds, fetching from files and intermediate result tables, and writing to files and intermediate result tables. The SQLBSCAN counter is not affected by user swapping.</p> | ||
<p>SQLBSCAN is an integer whose minimum is -1, maximum is 2147483647, and default is -1. Setting SQLBSCAN to 0 allows the value of SQLLPLIM to determine when a user is restarted. (See [[SQLLPLIM parameter|SQLLPLIM: Internal loop limit]].) Setting SQLBSCAN to -1 places no limit on the total number of operations executed in a user's request.</p> | <p>SQLBSCAN is an integer whose minimum is -1, maximum is 2147483647, and default is -1. Setting SQLBSCAN to 0 allows the value of SQLLPLIM to determine when a user is restarted. (See [[SQLLPLIM parameter|SQLLPLIM: Internal loop limit]].) Setting SQLBSCAN to -1 places no limit on the total number of operations executed in a user's request.</p> | ||
[[Category:User | [[Category:User parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 02:06, 23 April 2013
Summary
- Default value
- -1
- Parameter type
- User
- Where set
- On user's parameter line (CCAIN)
- Related products
- All
- Introduced
- Model 204 V6.1 or earlier
Description
The limit on the number of significant internal operations that a user can execute without causing a user restart
Model 204 issues a user restart when an SQL request reaches SQLBSCAN internal operations, which include indexed finds, fetching from files and intermediate result tables, and writing to files and intermediate result tables. The SQLBSCAN counter is not affected by user swapping.
SQLBSCAN is an integer whose minimum is -1, maximum is 2147483647, and default is -1. Setting SQLBSCAN to 0 allows the value of SQLLPLIM to determine when a user is restarted. (See SQLLPLIM: Internal loop limit.) Setting SQLBSCAN to -1 places no limit on the total number of operations executed in a user's request.