In conjunction with the Linear Hash Reporting and Resizing Tool released in March 2016, Revelation Software is publishing a sizelock administration tool called RTI_SET_SIZELOCK. This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and modify the file sizelock parameter.
The sizelock parameter is used to control the automatic resizing of the primary address space. A sizelock of "0" indicates that a table should be allowed to expand as more rows are entered, and become smaller as rows are deleted. A sizelock of "1" indicates that a table should be allowed to expand, but should not become smaller. This is useful in cases of a presized table, when a preliminary expectation is for the table to hold 1000 rows, but more rows may be added. If a sizelock is set to "2" or more, the table is not allowed to expand or contract. A sizelock of "2" is very important during a select operation executed on a network, when one user is searching a table for information while another user is entering new data.
OpenInsight increments the sizelock by 2 for the duration of the select operation. If another user is adding information, it is possible that the system could determine that a table needs to be resized. If this were to occur during a select operation, the process might yield unpredictable results: rows that have not yet been evaluated might be skipped, or rows might be processed more than once. Because the sizelock is "2", no resizing takes place. Once the process is finished, the sizelock is decremented by 2, restoring it to the table's original sizelock value. While the table might now be slightly out of size, the addition or deletion of another row will result in correct resizing.
The RTI_SET_SIZELOCK tool will allow an OpenInsight system administrator to globally set the sizlelock parameter on all or select tables. For instance if a sizelock parameter is set to "2" or greater the table will not resize. You can use this to disable resizing during busy periods and then re-enable resizing during quiet periods.
You can use this tool on any table, including ! and DICT files, as well as system files such as SYSLISTS and SYSOBJ.
RTI_SET_SIZELOCK is available at no cost to all current Works members and can be downloaded from the Works Download section.
Founded in 1982, Revelation Software delivers a suite of application development tools and companion services that take full advantage of leading network computing architectures, messaging, groupware, and client server platforms. Today, the company's flagship product OpenInsight is the only database development and application environment that provides both Windows and Java-based GUI s tools to develop and deploy web-based and client server applications that support native and relational XML, SQL, Lotus Notes and the leading legacy Multi-Value data sources such as Arev, Pick and IBM Universe. There are more than 1.5 million licensed users of Revelation products across 60,000 deployed sites worldwide. The company has offices in Westwood, New Jersey, as well as a European distributor in the United Kingdom, and an Asia Pacific subsidiary in Australia.
OpenInsight is a repository-based applications development environment
that enables development teams to work collaboratively to design,
develop, deploy and scale high-performance business solutions on
leading messaging and client/server platforms. OpenInsight is a
Windows-based application development environment that can reside
on either Windows or Linux servers when used in conjuction with our
network product Universal Driver 4.5. Arev32, Character to
OpenInsight (CTO), the U2 Connector, WebOI and the Bravo Dashboard
are all included in OpenInsight 9.0 Server Edition and above.