First Autonomic DB2 Optimization Tool For IBM System i

Share Article

New tool brings best practices to all IBM System i customers.

There are literally thousands of pages of DB2 documentation. Within those pages, there are hundreds of best practices for optimizing database tables, indexes, and program access

Today, Centerfield Technology, Inc. (http://www.centerfieldtechnology.com) announced the development of the first autonomic tool designed to optimize DB2 for i5/OS. AutoDBA, short for the autonomic database assistant component, provides expert DB2 advice and options to automatically implement that advice. The first release will focus on fully optimizing database indices (DDS logical files and SQL indices); with the objective of making SQL and RPG programs that process large amounts of data much more efficient.

"There are literally thousands of pages of DB2 documentation. Within those pages, there are hundreds of best practices for optimizing database tables, indexes, and program access," says Mark Holm, Centerfield Technology's Chief Technology Officer. "AutoDBA is Centerfield's platform for delivering those best practices on a silver platter to shops -- shops without the time or expertise to comb though a mountain of documentation. AutoDBA understands those best practices, gathers the data necessary to identify opportunities, graphically shows prioritized advice, and can optionally implement those changes with very little risk to applications."

The first autonomic tool designed to optimize DB2 for i5/OS

"AutoDBA is next step in the evolution of DB2 tools," says Elvis Budimlic, Centerfield Technology's Development Director. "The need to actively manage application databases has increased quickly in recent years due to the complexity of applications, extensive use of SQL, an explosive growth of database tables, more users, and the consolidation of servers. Unfortunately, most shops do not have extra people or time to understand the raw data available in other tools -- most shops need answers and solutions, not more data."

Designed to meet the strict definition of "autonomics" as defined by IBM, AutoDBA provides granular policy controls, focused data collection, manual or automated actions (automatic actions controlled by IT policies), full audit support, and the capability to "undo" all changes. Packaged as part of Centerfield Technology's HomeRun suite of tools, AutoDBA will be available to existing Centerfield customers by summer 2007.

About Centerfield Technology

For 10 years, Centerfield Technology has created a set of groundbreaking tools that help companies and ISVs more effectively utilize the AS/400, iSeries, and System i5 (System i). Today Centerfield helps clients manage complex databases, SQL-based applications with that tools deliver high performance database access, reduce the time needed to diagnose application issues and control unrestricted access to System i data.

# # #

Share article on social media or email:

View article via:

Pdf Print

Contact Author

JENNIEFER HALVERSON
Visit website

Media