LRETBL and (deprecated) LRECLTBL parameters: Difference between revisions

From m204wiki
Jump to navigation Jump to search
Line 19: Line 19:
The length in bytes of each user's part of the record enqueuing table</p>
The length in bytes of each user's part of the record enqueuing table</p>
<p>
<p>
<var>LRETBL</var> is multiplied by the value of the <var>[[NUSERS_parameter|NUSERS]]</var> parameter to get the size of the record enqueuing table. The resolution of this formula <code>(NUSERS * LRETBL) + ((<var>[[NFILES_parameter|NFILES]]</var> +2) * 32) + 88</code> is forced to be at least 600, and its maximum is 2<sup>31</sup> - 1. </p>
<var>LRETBL</var> is multiplied by the value of the <var>[[NUSERS_parameter|NUSERS]]</var> parameter to get the size of the record enqueuing table. The resolution of this formula <code>(NUSERS * LRETBL) + ((<var>[[NFILES_parameter|NFILES]]</var> +2) * 32) + 88</code> is forced to be at least 848, and its maximum is 2<sup>31</sup> - 1. </p>
<p>
<p>
Space in the record enqueuing table is flexibly shared by the users: an individual user is not restricted to <var>LRETBL</var> bytes of the record enqueuing table (except in batch mode, when NUSERS=1).</p>
Space in the record enqueuing table is flexibly shared by the users: an individual user is not restricted to <var>LRETBL</var> bytes of the record enqueuing table (except in batch mode, when NUSERS=1).</p>

Revision as of 16:15, 3 December 2014

The LRECLTBL parameter is an alias for LRETBL. LRECLTBL is deprecated — use LRETBL instead.

Summary

Default value
200
Parameter type
System
Where set
On User 0's parameter line
Related products
All
Introduced
Model 204 V2.2 or earlier

Description

The length in bytes of each user's part of the record enqueuing table

LRETBL is multiplied by the value of the NUSERS parameter to get the size of the record enqueuing table. The resolution of this formula (NUSERS * LRETBL) + ((NFILES +2) * 32) + 88 is forced to be at least 848, and its maximum is 231 - 1.

Space in the record enqueuing table is flexibly shared by the users: an individual user is not restricted to LRETBL bytes of the record enqueuing table (except in batch mode, when NUSERS=1).

The record enqueuing table contains control information necessary to detect conflicts between users who are trying to update records simultaneously. The amount of space in this table needed by a request is roughly proportional to the number of lists and FIND statements in the request. Each FIND or list requires about 46 bytes per file for files less than or equal to 300,000 records. The space required increases at the rate of 2.25 bytes per segment.