OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4

Chapter 1. Determining whether you have an SQL performance problem 7

Figure 1-2 Components of work: Database request

In Figure 1-2, you can see which operations affect optimization time, open processing time,

and run time. It is key that you identify and minimize the bottlenecks in these three main areas

of the processing of an SQL request.

If it is believed to be SQL related because the problem remained after making the above

changes then let’s look at how you could approach resolving it using the tools available in

V5R4 of i5/OS.

In order to make a quick determination if an SQL problem exists, an analyst could use SQE

Plan Cache described in ...