RiteWay Reorgs is how you can simplify the maintenance and optimize the performance of your Synergy/DE DBMS ISAM data files.
News Update: January, 2016 - Riteway-isutl and Riteway-fconvert V4.4.0 have been released. This new version is released as a 64 bit Linux and 32 bit Windows version tested with Synergy/DE V10.3x and has itself been built under its most up to date language build toolset. The newest feature in this release is that on the Linux platform, we've added what we call LCM - Life Cycle Monitoring. LCM for Windows is available via manual setup of the recurring job within the Windows Scheduled Jobs Manager.
Jobs are setup in a platforms job scheduling system to periodically scan your files for key file metrics and graphical plots can be interactively generated. Check out the screen shots below. If you have a serious Synergy DBMS ISAM database, then this feature is for you. Other new features allow individual or en masse patching of ISAM files to current rev level, explicit up/down or auto increase file page sizes during file reorder operations, tuning files with explicit support for TByte and Compress file attributes. The GUI has been cleaned up for smoother/faster repaints. Additional buttons on the Toolbar are placed for easier switching from standard to the more comprehensive maximum view.
Did you know that your Synergy/DE DBMS ISAM data files are really a very high performance data file subsystem? It's True! However, to keep these files performing at peak efficiency, it is necessary to be able to understand the empirical elements of information about your files that enable you to make essential decisions about what and how to tune or to rebuild index and or reorder records.
- The first question for many users of these data files is "What files do I reorganize?".
- The usual answer is that it depends on the design, structure and usage patterns of data files by your applications. Often the determination is made by someone with applications level experience and or just guessing!
- Empirically, this is manually determined by using command line tools on files on a one by one basis so as to study the file layouts, index utilizations, fill rates and other technical metrics. This is a tedious and time consuming task. Over the life of these files this process seems endlessly repeated.
- The next question is "How often do I reorganize my files once I figure out which ones?". The answer here is mostly the same as the answer to the first question. But, Life Cycle Monitoring of your files can reveal these answers.
- The next question is "Isn't there a better, faster, easier and lower cost way to do this?" The simple answer to this question is "Yes! Riteway Reorgs with LCM support!"
Unfortunately, few sites want to take on the manual task of analysis and then maybe do enough to just get by. Without additional tooling to help you easily gather the empirical evidence needed to make informed decisions, you continue to expend large amounts of work studying and managing only some of your files the hard way. With Riteway Reorgs, you can manage all your files the easy way.
Riteway Reorgs is the desktop graphical interactive toolset that identifies your Synergy DBMS ISAM data files, collects (using standard Synergy DBMS tools) essential detailed file metrics about your files and presents that data in an easy to understand spreadsheet appearing graphical desktop application. Once you can see all your files in such a presentation it becomes easy to see which ones need maintenance and perform that maintenance with a few clicks of the mouse and a press of a button!
With Riteway Reorgs - You finally have empirical evidence to base your decisions on! You can review the candidate list of files along with the critical internal information that qualifies a file for reorganization or tuning and finally, you can execute a reorganization procedure on any or all of the file(s).
With Riteway Reorgs, you won't waste time by letting your system get bogged down with excess file I/O overhead. By periodically reorganizing and tuning your DBMS ISAM data files you keep your applications and servers running their best. This means happy users, happy administrators, happy management and valuable time saved.
Riteway Reorgs is a stand alone Graphical UI program for either Windows or Linux. Operation of the program on either platform is virtually identical. It has no outside 3rd party application dependencies other then utilizing a standard Synergy/DE operating environment. It utilizes the standard Synergy/DE DBMS file utilities for file analysis, indexing and reordering. This program takes all the brute force work out of your hands and makes file reorganizations fast, safe and reliable via the click of the mouse.
To get a copy for your site, just inquire and we'll arrange to send you a full function (time limited) demo version of the software. We're here to help you advance the efficiency of your Synergy DBMS ISAM database files. This tool will significantly help you achieve that goal.
Below you will find several screen shots of the application.
This screenshot shows the main application screen in standard view. More columns of detailed data can be seen by switching to the Maximum View. Click HERE for a larger view.
The Maximum View shows all the data collected by the program about the list of ISAM files. Collecting all this data by hand would be more than tedious and pron to error. Click HERE to view a larger image.
This screenshot shows the Execution Log when file plan processing has occurred. Note how it summarizes the top ten space saving file operations. The indentation and colorization of the log makes for maximum ease in reading the output. Click HERE for a larger image.
Here we can see the FIle Operation Job History screen. It shows basic information about each file, the file operation plan, completion status, Before/After file size and a graphical bar chart showing the percentage of file size change. You can even click the button at the right to view the exact log file from the jobs execution. With these tools, you can track the life of your data files like you have never done before. Click HERE for a larger image.
Here we can see the main Riteway-isutl screen with a file selected and the right mouse button menu shown. This illustrates the wealth of selection features provided to adjust your files for maximum efficiency. The most recent addition to this menu is the LCM Graph option shown at the bottom.
Click HERE for a larger image.
Here we can see an LCM Data File Graph. This samples shows the life of a Synergy DBMS file after undergoing various file cycles of growh and reorganizations. The graph reveals that during the life of the file, as the file grew in size and record counts, the files Index Depths changed. How would you know how these states corrolate if you did not have a Riteway LCM graph to show you? This sample file had undergone massive record Adds, Updates with changed record sizes and Deletes. Note how the RFA vector counts are shown.
Click HERE for a larger view.
Here we can see another LCM Data File Graph. Note how this graph reveals how the data files index depth grew as the files record counts increased. Here again, this file was subjected to high record insertions with random Deletes and Updates. RFA Vector counts rapidly rose during initial growth and began to level off, still leaving large numbers of RFA Vectors and Unused Record Space in the file despite ongoing record operations. While this file shows some stabilisation occurring, the file could benefit from a Index and Data Record reordering so as to reclaim unused space. By increasing the page size, the Index depths would reduce making for faster index key lookups.
You can also see how we've built in a set of Sliders at the bottom of the graph page. Use them to narrow the lower and upper range of collected data samples to get an expanded view of the portions of the graphs you want to study the most. Set the sliders as needed, press the refresh button and the graph is updated instantly to show the selected range. You can also go back to the main screen and open as many individual file graphs as you want so you can view them simultaneously.
The four graphs per file are organized to illustrate the Key File Metrics that exist for a file. Record & Storage Stats, Page & Index Stats and lastly Unused/Free Space with RFA Vector percentages vs Used Records.
Click HERE for a larger view.