Automatic Volumetric Simulation
DB2 InfoSimulation® for z/OS
Together with DB2 InfoScope and DB2 InfoTrace, DB2 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
- DB2 InfoSimulation allows automatic updates of these statistics by a simple, practical, interactive interface
- DB2 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
- DB2 InfoSimulation makes all the necessary calculations based on a key parameter: the number of rows in the table.
- DB2 InfoSimulation allows you to keep all the simulations you make in order to reuse and/or modify them