Linear Hash Sizelock Administration Tool for OI v9.4 released
In conjunction with the Linear Hash Reporting and Resizing Tool released in March 2016, we are 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 of our web site.
Universal Driver NUL v126.96.36.199 for OpenInsight 9.4 released
Version 188.8.131.52 for OI 9.4 contains bug fixes, an improved UD manager, and a client installer which exposes more UD5 features. A bug which caused a client to hang upon repeated toggling of the resize service is fixed. Version 184.108.40.206 supports passing REVPARAM information via a volume pointer or call to ATTACH_TABLE. Some core system routines including RTP57, RTP49, FIX_LH and RTI_LH_INFO are updated. The UD client installer replaces the REVBOOT file and installs the UD_MANAGER and supporting components into your OpenInsight. With these changes, the UD manager displays lock and session details in a format of MACHINE*USER*PROCESSID. This format lets you determine lock holders in a terminal server or O4W environment. The UD manager window ( MANAGE_REVLH_SERVER ) provides access to sub windows displaying statistics, statistics history, size lock and remake table information. This version also resolves a long-standing issue with corrupted table header counts and sizes, and includes new options to disable or re-enable automatic resizing of tables. It also resolves a potential memory leak/overrun issue when running in 'debug output' or logging mode, and eliminates "hanging" when shutting down the service. This should allow sites to terminate and restart the UD without requiring a server reboot. This is a free upgrade to anyone who purchased a license for the UD NUL 5.X.
Revelation Software named in DBTA 100 2016 - The Companies That Matter Most in Data
The IT landscape is always shifting and being contoured by external market forces and internal industry initiatives.
New requirements for data management and analysis emerge and, in turn, fresh approaches and technologies are developed. Vendors grow and mature and sometimes outstrip others, while new startups take root.
Against this changing backdrop, each year, DBTA presents a list of 100 companies that matter in data, compelling us to pause and reflect on the market changes taking place.
For example, with Hadoop marking its 10th anniversary in 2016, it is now clear that while it is still in early stages of adoption, it is a technology that is here to stay and is also evolving beyond its initial role as a platform for batch processing to include a large network of interwined open source projects. Read On...
Become a friend or a follower. Just click the icons to get our RSS Feeds, LinkedIn Profile, Facebook or YouTube page.
OpenInsight 10 Alpha v2 is available
OpenInsight 10 Alpha v2 is available for download to all Works Members.
This version includes many enhancements to the IDE, Form Designer, Table Builder and O4W.
OpenInsight for Web (O4W) v2.0 included in Openinsight 10 Alpha v2 is a rapid application development tool that lets you generate responsive forms, reports, and dashboards. Use our GUI drag-and-drop to lay out your forms and then test in both desktop and mobile browser mode. Or use our full-function API to create the most sophisticated web pages.
Alpha v2 is set to expire on September 9, 2016.
OpenInsight 9.x Price Increase
Effective October 1, 2016 pricing for OpenInsight 9.x and above Network User Licenses, Annual License Renewals and the pay for versions of the Universal Driver will increase by 8%. Pricing for SQL BFS and MV BFS licenses will increase by 16%. Works Subscription pricing and Universal Driver Heavy pricing will remain the same. Read On...
OpenInsight 8.x Price Increase
Effective October 1, 2016 pricing for OpenInsight 8.x and below SDP's (Runtime and Developer), Annual License Renewals and the pay for versions of the Universal Driver will increase by 8%. Read On...
Universal Driver 4.7.2 now available
The UD 4.7.2 is an upgrade from UD 4.7. It resolves a significant issue with corrupted table header counts and sizes, a potential memory leak/overrun issue when running in 'debug output' or logging mode, and eliminates "hanging" when shutting down the service. This should allow sites to terminate and restart the UD without requiring a server reboot. This upgrade is available for both the "NT" and "NU" versions. This is a free upgrade to anyone who owns a license for the UD 4.7 or UD NUL 4.7. Please contact our Customer Care Department to receive your upgrade.
Universal Driver Heavy 4.7.2 now available
The UDH 4.7.2 is an upgrade from UDH 4.7. It resolves a significant issue with corrupted table header counts and sizes, a potential memory leak/overrun issue when running in 'debug output' or logging mode, and eliminates "hanging" when shutting down the service. This should allow sites to terminate and restart the UDH without requiring a server reboot. This is a free upgrade to anyone who owns a license for the UDH 4.7. Please contact our Customer Care Department to receive your upgrade.