Centerfield Announces Improved DB2 Optimization Tool for IBM System i

Share Article

HomeRun enhancement brings DB2 best practices to all IBM System i customers.

Today, Centerfield announced the general availability of HomeRun version 6.1, an updated version of its groundbreaking autonomic tools targeted at DB2 for i5/OS.

Elvis Budimlic, Development Director for Centerfield commented on his team's hard work and the new version: "Since the introduction of our autonomic database administrator (AutoDBA) last year, we've received tremendous feedback from our customers and many suggestions on how to make it even better. So our team enhanced HomeRun based on that feedback to make the function easier to use and flexible."

He goes on to say, "HomeRun 6.1 provides long sought enhancements that allow customers to collect deepest level of SQL performance data specifying particular current or group user, web server or fat client IP address, library filter and more which is then analyzed and followed by index advice from 6 different sources."

AutoDBA, the name of the new component introduced last year, provides expert DB2 advice and options to automatically implement changes. The first release focused on fully optimizing DDS logical files and SQL indices; with the objective of making SQL and RPG programs that process large amounts of data much more efficient.

With HomeRun Version 6.1, IBM System i shops get:

  • Improved prioritization of index recommendations to ensure they are getting the most value from every new index.
  • The ability to further pinpoint jobs for data collection by current user profile, current group profile, IP address, and by range of IP addresses. The ability to filter by this additional criterion is supported on i5/OS releases V5R2 and higher.
  • Expert advice generated by AutoDBA can now be implemented outside of the HomeRun product using information surfaced in the graphical interface. This allows shops full control over when and how changes are made to optimize DB2 while still retaining most of the benefits of auditing and the ability to easily undo changes.
  • Advice related to the use of "clustered indexes" has been reorganized to make it easier to identify the candidate index.

For further information please contact:

Jenniefer Halverson
Centerfield Technology, Inc.
Telephone: (888) 387-8119 (toll free)
Fax: (507) 536-0474
e-mail: (info @

About Centerfield Technology:

Since being founded in 1997, Centerfield Technology has created a set of groundbreaking tools that help companies and ISVs more effectively utilize the AS/400, iSeries, and System i. Centerfield's tools manage complex databases, SQL-based applications and the end-users that work with them. The HomeRun software suite helps IT personnel deliver high performance database access, reduce the time needed to diagnose application issues and control unrestricted access to System i data.

For further information about Centerfield Technology, visit the company's web site at

# # #

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Visit website