• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Mohawk Slashes Report Delivery Times, Thanks to Centerfield

    January 6, 2009 Alex Woodie

    A year ago, the folks at Mohawk Fine Papers were thinking about adding a Windows-based system to speed up the delivery of critical reports. The core i5/OS infrastructure was maxed out, they feared, and couldn’t churn out the reports as fast as Mohawk’s business moved. But the company found a better solution by utilizing Centerfield Technology‘s database optimization software, HomeRun, and now those Windows plans are shuttered.

    Based in Upstate New York, Mohawk Fine Papers makes and sells $300 million worth of paper around the world every year, and is the largest manufacturer of premium paper in the United States. The company runs several paper mills and operates a distribution network, activities that are managed from a System i-based computer system consisting of BPCS and several other solutions.

    Unlike some mills that have week-long lead times, Mohawk is constantly tweaking its production schedule to meet the needs of customers, says Paul Stamas, vice president of information technology at Mohawk, according to case study that was recently published on the IBM Web site.

    As a result of this business model, Mohawk officials depend heavily on up-to-the-minute reports to make decisions that are profitable. Unfortunately, the company’s System i server did not seem up to the task of running the day-to-day transactional system as well as a demanding reporting environment.

    “As we were looking to get closer to real-time reporting on plant operations, we had doubts that DB2 could reach that goal while it was simultaneously running our basic transactional system,” Stamas says, according to the case study. “We were thinking of trying to reach our real-time reporting goals by offloading the reporting function to a Windows-Intel processor-based infrastructure.”

    Then one of Mohawk’s IT staffers heard of a product called HomeRun from Centerfield Technology. The software helps speed DB2/400 by performing several tasks, such as database index optimization, fine-tuning SQL, and other tricks. The tricks are well-documented in IBM Redbooks, but most administrators don’t have time to read them. With HomeRun, the software guides the administrator through the entire process, and helps minimize the chance of making an error.

    After installing HomeRun last July, Mohawk’s IT department noticed an immediate improvement in DB2/400 performance. The time it took to run reports on the status of various mill processes was cut from 15 minutes to two minutes, while other reports decreased from 45 seconds to five seconds.

    “We saw dramatic improvements immediately,” Stamas says. “It was a game changer.”

    RELATED STORIES

    Mohawk Paper Cuts Waste with Electronic Forms and Payment System

    Centerfield Adds More Smarts to Database Performance Suite



                         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
    New Generation Software

    On Demand Video

    Data Visualization and Analytics
    with NGS-IQ and Microsoft Power BI

    Power BI is a popular visualization and analytics solution, but it’s only as good as the data your analysts can draw from your IBM i database.

    NGS-IQ simplifies and automates the cleansing, transformation, and delivery of IBM i data to Power BI reports and insights. Watch our new video to learn and see how NGS-IQ supports Power BI users while enabling you to maintain control and security.

    www.ngsi.com – 800-824-1220

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    New Generation Software:  Run IBM Query/400 from your Windows desktop!
    Bug Busters Software Engineering:  High availability software that won't break the bank
    COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    Getting Started with PHP for i5/OS: List Price, $59.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 Developers' 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
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    Avnet Partners with Sanko for Turkish Expansion Bypassing a Locked Record, Take Two

    Leave a Reply Cancel reply

Volume 9, Number 1 -- January 6, 2009
THIS ISSUE SPONSORED BY:

ProData Computer Services
Bytware
Maximum Availability
VAULT400
Twin Data

Table of Contents

  • Safestone Gives i Security Officers Greater Control
  • SPSS to Update ShowCase OLAP Server Technology
  • Rand McNally Keeps Truckers On the Go and In the Know
  • The Who’s and What’s of ESBs and eSBs
  • Mohawk Slashes Report Delivery Times, Thanks to Centerfield
  • T.L. Ashford Eases Setup with Barcode400
  • Shore Bancshares Licenses i-Based Core System from Jack Henry
  • LogRhythm Debuts New ‘Intelligent’ IT Search
  • Siemens Taps CCSS to Monitor Outsourced i OS Environment
  • Infor Begins North American VAR Recruitment Drive

Content archive

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

Recent Posts

  • Power10 Boosts NVM-Express Flash Performance
  • Fortra Completes Postmortem Of GoAnywhere Vulnerability
  • Guru: Binding Directory Entries
  • How Does Your Infrastructure Spending Stack Up To The World?
  • IBM i PTF Guide, Volume 25, Number 22
  • Fortra Issues 20th State of IBM i Security Report
  • FNTS Launches Managed Services for Power Servers in IBM Cloud
  • Total LTO Shipped Capacity Up Slightly in 2022
  • Four Hundred Monitor, May 24
  • Update On Critical Security Vulnerability In PowerVM

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 © 2023 IT Jungle