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.
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online