Synergy DBMS Reorgs
Open Quick Reference

 Call Us: 262-509-5990

  • Register

RiteWay Reorgs is how you can simplify the maintenance and optimize the performance of your Synergy/DE DBMS ISAM data files.

Newsflash: June, 2015 - Riteway-isutl and Riteway-fconvert V4.0.0 have been released.  This new version is released as a 64 bit Linux and 32 bit Windows version tested with Synergy/DE V10.x and has itself been built under its most up to date language build toolset.  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 rebuilds, converting files with explicit support for TByte and Compress file attributes.  The GUI has been cleaned up for smoother/faster GUI repaints.  Additional buttons on the Toolbar are placed for easier switching from standard to the more comprehensive maximum view.

RiteWay Reorgs.

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 may become necessary to periodically tune and reorganize them.

  1. The first question for many users of these data files is "What files do I reorganize?".
    1. 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!
    2. Empirically, this is determined by manually 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.
  2. 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.
  3. 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"

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.


Riteway-isutl_StandardView

 

 

 

 

 

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.

 

 

 

 

 

 

 

 

Riteway-isutl Maximum 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.

 

 

 

 

 

Riteway-isutl_PlanExecutionLogView

 

 

 

 

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.

 

 

 

 

 

Riteway-isutl_JobHistoryView

 

 

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.

 

S5 Box

Login

Register