Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

Linear Hash Reporting and Resizing Tool for OI v9.4 released

This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and resize poorly hashed tables.

Conference Schedule

Phoenix 2019 - April 8th-11th
More Info



Release Date: Wednesday, June 15, 2016

In an effort to help assist OpenInsight system administrators manage Linear Hash tables Revelation Software is publishing a reporting and resizing tool called RTI_LH_STATISTICS. This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and resize poorly hashed tables.

Poorly hashed/sized tables are one of the most significant reasons for degradation in system performance.

The Remake table option of RTI_LH_STATISTICS utilizes a program called RTI_REMAKETABLE. RTI_REMAKETABLE works by sampling 10% of the rows in a table, calculating the average record size, then making a new pre-sized table with the frame size larger than the average record size and a threshold of 50% to force the table to resize more frequently. RTI_REMAKETABLE copies the rows from the existing table to the new table, then edits the REVMEDIA record to point to the new table rather than the old and attaches the table again.
For poorly hashed tables that have been resized the .LK will be larger in size and the .OV smaller in size. The total size of .LK + .OV will most likely increase. By making a larger .LK and a frame size larger than the average record, the resize program will force most records into the primary (LK) frames. The result will be that the performance of reads and writes will increase significantly.

You can use this tool on any table, including ! and DICT files, as well as system files such as SYSLISTS and SYSOBJ. Please be aware that the underlying REV number will change, for example as table whose DOS name was REV12345.LK may become REV12890.lk. You can run the window while the system is busy, but when resizing tables all users and background processes should be stopped. The process will update the DBT to reflect the new DOS filenames.

RTI_LH_Statistics is available at no cost to all current Works members and can be downloaded from the Works Download section.


# # #          # # #          # # #


About Revelation Software

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.

For more information, visit http:/​/​www.revelation.com

About OpenInsight

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.

For more information, visit http:/​/​www.revelation.com/​Revelation.nsf/​byTitle/​5DA001116EB098C085256DC500658FF4?OpenDocument

Related Articles:

Return to top