- Application problems may lead to the DB2
system - DB2 system problems often lead to application
design and SQL coding - Application and system problems may lead to
DASD, z/OS, CICS, IMS - z/OS performance problems may lead to
applications or DB2 memory consumption
As you find a problem, as correct it, other performance problems will surface that may not have been obvious before.
Monitoring and tuning is a constant process, not a one time exercise.
The only exception to this is if/when your environment is static – no application changes, no workload or data growth, no migration to newer releases or maintenance levels….