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