Application development and capacity planning

You can also use OMEGAMON® XE for DB2® PE in application development and capacity planning.

The Explain and the SQL Activity reports can help you anticipate how an application will perform. The Online Monitor Explain and Source Explain functions as well as some functions of thread activity can assist you in tuning your application’s SQL online.

Accounting and Statistics reports that are ordered by INTERVAL are useful in capacity planning. Use these reports to identify peak periods in system activity as well as the need to adjust system resources. monitoring Db2 subsystems