Automatic Volumetric Simulation

InfoSimulation® for DB2 on z/OS

Together with InfoScope and InfoTrace, InfoSimulation is part of the INFO-OPTIMIZER line, an automated software suite ensuring the quality and performance of DB2 applications.

The Problem

  • How can you analyze the performance of your SQL queries, since they depend on the volumes of your objects?
  • How can a development environment reflect a production environment without all the data?
  • How can you evaluate the performance of your applications today, for the larger volumes to be handled tomorrow?
  • How can you modify the DB2 catalog?
    • With the Runstat utility, but only with real data
    • By manually updating the DB2 catalog statistics

This is a fastidious, time-consuming job.

The InfoSimulation solution

  • InfoSimulation allows automatic updates of these statistics by a simple, practical, interactive interface
  • InfoSimulation allows automatic import of the data from one DB2 catalog to another to simulate the volume of a situation that does not yet exist
  • InfoSimulation makes all the necessary calculations based on a key parameter: the number of rows in the table.
  • InfoSimulation allows you to keep all the simulations you make in order to reuse and/or modify them

More details…

The advantages of InfoSimulation

An access strategy based on volume

  • Simple, fast interface for creating a simulation
  • Automatic calculation based on the number of rows in a table
  • Application of the simulation to the DB2 chosen by the user
  • Fast simulation for a development environment
  • Monitoring of the growth in a production environment

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