Centerfield’s new HomeRun suite of IBM ServerProven® database tools let IT easily improve SQL performance, optimize DDS logical files and SQL indices, audit data access, control resources used by queries, and secure data. We can help you with tools designed to fix problems that surface when you’re hitting performance out of the ballpark.

insure/INDEX identifies needed indexes without the deep expertise required using traditional methods. Equally important, existing indexes and logical files can be optimized to make RPG applications and SQL queries much faster. In addition, unused indexes and logical files are highlighted so they can be phased out of production database and completely eliminate unnecessary overhead.

insure/INDEX is the first component of HomeRun to take advantage of Centerfield’s Autonomic Database Assistant (AutoDBA). As a result, insure/INDEX provides sophisticated analysis of your database, just like an on-staff database administrator - analysis designed to give mission critical applications the exceptional performance and availability necessary to deliver maximum business value.

insure/ANALYSIS gives database administrators and performance analysts a powerful and intuitive tool to gain knowledge and understanding of database and SQL activity for their mission-critical applications. Tuning time is minimized by drilling into the data and quickly finding the key performance problems so timely action can be taken.

insure/MONITOR allows an operator to identify potential problems earlier and take action to protect critical applications - a very difficult task for modern multi-tier, network-based applications. If you’re running OneWorld® on a System i with Citrix, you can then choose insure/MONITOR for OneWorld® and view OneWorld® jobs and their associated details. Important Job Metrics can be viewed graphically as well, to help monitor and pinpoint specific issues.

insure/RESOURCES lets IT control the use of query tools (Query/400, Open Query File, ODBC apps, Start and Run SQL commands) by allowing them to first track query usage and then define straightforward policies that are automatically enforced to govern the use of system resources.

insure/SECURITY enables security officers to protect critical application data from accidental or malicious damage without the risks of blindly applying traditional IBM System i security.