Current release is 3.6.2
Keith W. Hare: Photo courtesy of Leena Bengani
JCC Consulting headquarters in Granville, Ohio USA
Jeffrey S. Jalbert presenting a seminar in North Ryde, Australia
Keith W. Hare at a "Seminar on Information Management Technical Standards," Ürümqi, China

The JCC LogMiner Loader handles unexpectedly large transactions.


One customer was successfully using the Loader until extensive maintenance revealed a performance issue. The company had been using the Loader to regularly process 4,000 transactions per second.  The DBAs did a convert/commit and changed the truncate table statements into delete from table. The result was transactions of half a million rows. Performance was no longer something to brag about.

Occasionally, contacting the support desk reveals something that exceeds the Loader's capacity. Some of these become enhancements to the product.

The next release of the Loader included an enhancement to adjust the locking approach automatically when a certain threshold was reached. The new approach avoided heavy use of the OpenVMS lock manager and achieved the goal of getting the huge transactions out of the way as quickly as possible so that regular processing could resume.

 

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Essential
These cookies are needed to make the website work correctly. You can not disable them.