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.
Rocket Software recommends 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 U2 does 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 U2 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, Opera or Internet Explorer. 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.