• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Centerfield Makes SQL Tuning Easier with HomeRun 7.0

    June 15, 2010 Alex Woodie

    System i database performance experts Centerfield Technology recently launched HomeRun version 7.0, the newest version of its suite of application and database optimization tools for the i/OS platform. With HomeRun version 7.0, Centerfield has overhauled AutoDBA, the suite’s automated database administrator component of the suite, to make it easier to use and to allow customers to get results quicker than before.

    HomeRun is a suite of tools aimed at getting customers the highest level of performance out of their DB2/400 applications. The suite includes five integrated components (INDEX, ANALYSIS, MONITOR, RESOURCES, and SECURITY) that address various aspects of performance monitoring, tuning, resource consumption, security, and auditing.

    Tying it all together is AutoDBA, which was introduced during 2007 spring training (and shipped during the dog days of August) to provide a built-in surrogate database administrator (a pinch hitter of sorts) that can make suggestions on complex DB2/400 performance issues. The product also provides wizards that guide the user through the process of applying (or removing) the optimized indexes that are suggested to the user. AutoDBA can be thought of as the distillation of IBM’s lengthy technical treatises on DB2/400 optimization by Centerfield’s technical whizzes, coupled with autonomic functionality.

    Most of the enhancements with HomeRun 7.0 have to do with AutoDBA. For starters, Centerfield has completely overhauled AutoDBA’s Windows-based GUI to make it easier for System i administrators (since System i shops traditionally have no actual DBAs) to comprehend the advice that AutoDBA disseminates. In particular, this release makes it easier for admins to filter, order, and sort AutoDBA’s advice on a graphical grid.

    New sorting and filtering mechanisms added to the AutoDBA GUI should make it easier for System i shops to take advantage of the performance tuning suggestions made by the Centerfield product.

    Centerfield has also taken steps to prioritize the recommendations made by AutoDBA, so that customers get the most value from every new index they add. With this release, AutoDBA will also generate its first index recommendations quicker than before–within a few hours by looking at the most active files on the system. The company has also made changes to the policy and permissions filter that make it easier to remove indexes if they are not being used.

    The company has also adopted Microsoft‘s .NET technology to develop new reporting elements of AutoDBA. This gives customers another way to look at the changes AutoDBA recommends. Centerfield also added the capability to export AutoDBA’s output to other formats, including Excel, PDF, and Word.

    This release also brings more fine-grained controls over the activities performed by AutoDBA. Customers can restrict how much time (and therefore how much System i resource) AutoDBA will take to implement the performance advice. Customers also get new commands that restrict AutoDBA from working on certain types of files.

    HomeRun 7.0 is available now. For more information visit the company’s website at www.centerfieldtechnology.com.

    RELATED STORIES

    Centerfield Passes a Stimulus Package for i OS Applications

    Centerfield Adds More Smarts to Database Performance Suite

    Centerfield Debuts Installation Service for DB2 Web Query

    Database Optimizing Goes Autonomic with New Tool from Centerfield

    Centerfield Aims to Ease iSeries SQL Management with AutoDBA



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    FOCAL POINT SOLUTIONS GROUP

    IntellaFLASH™

    FPSG is the only hosting provider that offers IntellaFLASH™.  IntellaFLASH was created by FPSG and is an exclusive FPSG solution that provides the following:

    • No User downtime for production backups
    • Supports BRMS and Tivoli Storage Manager
    • Provides near Continuous Data Protection (CDP)
    • Create point-in-time copies of your entire environment within minutes
    • Easy and quickly repeatable
    • Processes are tied into Job Schedulers
    • No user downtime for planned outages
    • No disruption to the send and receive process production, and DR stays in sync during the Switch test
    • Supports heterogeneous environments
    • Create test/development environments on the fly
      ⇒ Simplify operating system/application upgrade testing efforts
      ⇒ Improve quality assurance testing

     

    Watch our IntellaFLASH™ Video to learn more

    Let’s Discuss Your Custom Solution Needs

    ContactUs@FocalPointSg.com

    Follow us on LinkedIn

    focalpointsg.com | 813.513.7402

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    looksoftware:  Recreate your IBM i applications with re:new! Free Webinar!
    Shield Advanced Solutions:  Receiver Apply Program ~ affordable availability for the IBM i
    COMMON:  Join us at the Fall 2010 Conference & Expo, Oct. 4 - 6, in San Antonio, Texas

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    Apple’s iOS 4: That’s Exactly What I Was Thinking! Shield Unveils New DR Solution for i/OS

    Leave a Reply Cancel reply

Volume 10, Number 22 -- June 15, 2010
THIS ISSUE SPONSORED BY:

LANSA
Help/Systems
Patrick Townsend Security Solutions
DRV Technologies
Shield Advanced Solutions

Table of Contents

  • Shield Unveils New DR Solution for i/OS
  • Synergivity Brings i/OS Change Management to US Market
  • Centerfield Makes SQL Tuning Easier with HomeRun 7.0
  • Linoma Beefs Up MFT Offering
  • VAI Unveils New SaaS Option
  • TMW Updates i/OS-Based Trucking Software
  • Under Armour Taps Manhattan Associates for WMS
  • Agilysys Tapped for CityCenter Project in Vegas, Reports Numbers
  • RTC Touts POS Install at JDA Shop
  • Bug Busters Updates Menu and Security System

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • COMMON Set for First Annual Conference in Three Years
  • API Operations Management for Safe, Powerful, and High Performance APIs
  • What’s New in IBM i Services and Networking
  • Four Hundred Monitor, May 18
  • IBM i PTF Guide, Volume 24, Number 20
  • IBM i 7.3 TR12: The Non-TR Tech Refresh
  • IBM i Integration Elevates Operational Query and Analytics
  • Simplified IBM i Stack Bundling Ahead Of Subscription Pricing
  • More Price Hikes From IBM, Now For High End Storage
  • Big Blue Readies Power10 And IBM i 7.5 Training for Partners

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.