Centerfield Technology has 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.
LATEST COMMENTS
MC Press Online