Retailer Takes Advantage of CDB's Flexibility


"When it came right down to it, other third party vendor utilities just didn't provide the flexibility we needed. By using CDB/Automation, we are now able to do anything we want."

Environment

  • Processing data for over 500 retail outlets
  • International expansion led to 24x7 availability requirement for some applications
  • Experiencing tremendous DB2 growth
  • Number of utility jobs increased from 1,500 to 7,100 in 2 years
  • Plans to double processing in next 2 years
  • Database greater than 1 terabyte
  • Shortage of DBA staff

Implementation

  • Automated decision of need for Reorg runs based on disorganization factors
  • Automated decision to start a Reorg based on:
    – Remaining batch window
    – Reorg speed history (maintained history per object)
    – Expected elapsed time
    – Table priority
  • Reorged frequently with automated size reallocation
  • Dynamic allocation of Image Copy datasets

Benefits Realized

  • Better transaction times
  • Less batch window invested in Reorg
  • Better utilization of batch window due to prioritizing of objects
  • DASD savings of between 25% and 33%
  • Simplified JCL
  • Standardized Image Copy dataset names
  • Easy implementation of GDGs for Copy
  • Met all availability requirements

Return to Success Stories | < < < Previous | Next > > >


  • PRESS
  • BECOMING A PARTNER
  • SUCCESS STORIES
  • UNIQUE TECHNOLOGIES
  • WHY CDB?
  • VALUE-BASED PRICING

CDB Software:The Industry's Leading Authority on z/Series DB2 Data Management

CDB Software is a leading authority on z/Series DB2 environments and how they can be optimized to meet the changing demands of business. From the critical every-day processes of database performance and protection to the implementation of new requirements for security and compliance, CDB Software is the visionary leader for enterprise DB2 environments that want both flexibility and control.

For more information or to schedule a briefing with a CDB expert, contact CDB Press and Analyst Relations .

Press Releases      |      White Papers &Articles     |     Press Contacts     |     About CDB