Ultrafast DB2 Tablespace Reorganization

InfoReorg® for DB2 on z/OS

Together with InfoLoad and InfoUnload, InfoReorg is part of the INFO-UTIL line, a software suite ensuring operational performance and data availability.

The Problem

DB2 Tablespaces and Indexspaces rapidly become disorganized as you add, delete, and update data.This causes fast degrading of application response times.You need to reorganize your data, but :

  • The utility batch window is becoming smaller and smaller
  • The Tablespaces are becoming larger and larger
  • The standard DB2 utility often requires several hours to perform such processing
  • It may even become impossible to reorganize certain Tablespaces

The InfoReorg solution

  • InfoReorg is an ultrafast utility for reorganizing huge Tablespaces to guarantee application performance
  • InfoReorg is very easy to use. It reorganizes the critical Tablespaces to optimize usage of the utility batch window
  • InfoReorg provides database administrators with a reorganizer that runs up to ten times faster than standard products
  • InfoReorg is compatible with the IBM utility (syntax and JCL) and preserves your existing job streams

More details…

The advantages of InfoReorg

Speed, reliability, and simplicity

  • The fastest tool on the market
  • All the reorganization tasks run in parallel
  • Freespace is dynamically allocated around hot spots, thereby reducing future reorganization needs
  • Application performance is improved by enabling more frequent reorganizations and allowing those which had become almost impossible
  • Reduction in data reorganization costs by decreasing CPU time and I/Os
  • Automatic allocation and optimization of the workspace required for reorganizations

We are prepared to demonstrate to you the excellent return on investment you will achieve with InfoReorg.