Mercury has been designed and created by one of the industry’s most knowledgeable database management experts; the same expert that Rocket Software leverages to update their UniData and UniVerse Administration exams.
Mercury performs extensive analysis of your database files and suggests new parameters for peak performance and then automatically implements the changes upon your approval. Mercury allows you to specify specific criteria on a per file basis, so that you can override Mercury’s recommendations in special circumstances.
One of the problems associated with Multivalue resizing is that once your database files have been resized and once new data is added, the file has begun the process of becoming incorrectly sized. As each day passes and more and more data is added, the files become less efficient.
To solve this issue, Mercury learns how the database grows and then uses the knowledge to calculate not only the current file size, but the optimal file size that will handle future data. This ensures that files will still be correctly sized days, weeks, even months later.
Mercury also collects and provides extensive statistics about your database files, and on some systems it can even perform file repairs when an issue is discovered.
In the event of an emergency recovery after a system crash, or any other unplanned event, with one click Mercury, can instantly perform validation on the most important database files so that you can verify the database integrity as quickly as possible.
Mercury is currently supported on UniData, UniVerse and Open
WHY MERCURY IS THE SOLUTION
File analysis and database tuning are paramount in keeping a system operating at peak performance. If you have not been resizing your files on a regular basis, your system is wasting valuable resources by performing unnecessary disk I/O, while large portions of disk space become unusable.
It is recommended that all files should be routinely analyzed to calculate the proper file size by determining the correct modulo and separation. Once determined, these values must be implemented by resizing each file on the system.
A common misconception is that dynamic files automatically resize themselves. In theory, dynamic files are supposed to split as data is added and merge when data is deleted. In reality this process is not as quick or accurate as users are lead to believe. In reality, dynamic files often result in excessive overflow or too much unusable disk space locked away inside each group.
Unfortunately Multivalue vendors do not include sufficient tools to manage this process. As a result many organizations must either hire an expensive database administrator to manage their systems, or obtain the assistance of their database vendor to help with this long and tedious task. When you compare the cost of hiring a database administrator to perform this task to the cost of Mercury, the return-on-investment can easily be determined, and a business case in support of Mercury is apparent.
Once Mercury has been installed and is running, user access is achieved via any most web browsers including Google Chrome, Mozilla Firefox or Opera. As a browser based system, Mercury allows nearly any non-technical user to easily access and manage the database via a web browser. This means you do not have to be a database expert to tune your system and you won’t need to install a client application on your workstation and limit database activities to a specific workstation.
With familiar point and click options, Mercury provides a fast and natural feel that is easy to learn and easy to use. You can even schedule file analysis, resizing and even file repairs, for a total set-it-and-forget-it environment.
MERCURY IS SECURE
Mercury is browser based and therefore can be accessed from any device with a modern browser. This means you can access and manage your Multivalue database from anywhere in the world, and since Mercury Flash supports all the latest security protocols you can use SSL/TLS to keep your data secure*.
To the right you will see an actual screen capture of a test performed on a Mercury Flash server by a client using SSL and two factor authentication for remote administration of their UniData environment.
Mercury Flash uses adaptive connection monitoring to automatically detect unauthorized access attempts and when a threat is detected, Mercury Flash can automatically lockout connections from threatening locations.
*OpenQM from Zumasys does not currently support SSL/TLS encryption and therefore is not recommended for access outside of a protected network.
Screen shot of Mercury Test Results of a client site using Qualys SSL Labs.
MERCURY IS CUSTOMIZABLE
Mercury is designed to be customizable. Based on the concept of a Web based desktop, you have the option of placing widgets and commonly used shortcut anywhere on the Mercury desktop, allowing you to easily monitor the the parameters you choose. You can even add external widgets to the desktop which means you can create your own widgets.
Mercury even has the ability to monitor external data collection devices, bring the IoT to you.
Click the video above to watch a short explainer and learn what Mercury can do for you.
Click this video to watch and learn the importance of properly managing your U2 database.
Meet Bill Johnson
The New Guy
Click this video to watch a short demonstration of Mercury Flash.